Tag: web technology

Questions Related to web technology

You are planning for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols will you use to achieve this goal?

technology web technology

  1. Named Pipes

  2. Shared Memory

  3. Virtual Interface Adapter

  4. TCP/IP

Show answer
Correct Option: D

You have currently installed SQL Server 7.0 Standard Edition SP4 and wish to upgrade to SQL Server 2005. Which versions of SQL Server 2005 can you upgrade to?
technology web technology

  1. SQL Server 2005 Developer Edition

  2. SQL Server 2005 Enterprise Edition

  3. SQL Server 2005 Express Edition

  4. SQL Server 2005 Standard Edition

Show answer
Correct Option: D

You are importing data into SQL server 2005 database. You are receiving text files that contain Sales transactions from stores across the city. You need to import the files into Sales Database. What should you do?
technology web technology

  1. Use the bcp command

  2. Use the BULKINSERT statement

  3. Create a custom format file

  4. None of the above

Show answer
Correct Option: A

What is Full Text Search in SQL Server 2005?
technology web technology

  1. Allows fast and flexible indexing for keyword based query

  2. Provides a message based communication platform

  3. Supports sending Email from the database

  4. None of the above

Show answer
Correct Option: A

It is possible to rename a database and database objects in SQL Server 2005
technology web technology

  1. True

  2. False

Show answer
Correct Option: B

Which are the System Databases in SQL Server 2005?
technology web technology

  1. Model database

  2. Master Database

  3. msdb

  4. Temporary database

Show answer
Correct Option: A

You want to send Personalized Messages to a group of people. Which SQL Server 2005 services would you use?
technology web technology

  1. Database Mirroring

  2. Integration Services

  3. Notification Services

  4. All of the above

Show answer
Correct Option: C

Which SQL Server 2005 tool helps in running T-SQL queries from command prompt?

technology web technology

  1. DTUTIL

  2. BCP

  3. Object Explorer

  4. None of the above

Show answer
Correct Option: D

What are the requirements to create a CLR based user-defined type?
technology web technology

  1. The CLR must be enable for the database

  2. The CLR must be enabled for the instance

  3. A class created with a Microsoft .NET language

  4. A class created with a CLR-compatible language

Show answer
Correct Option: B

Which TCP/IP port does SQL Server run on?
technology web technology

  1. 143

  2. 1433

  3. 1432

  4. 142

Show answer
Correct Option: B