Tag: web technology

Questions Related to web technology

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

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

What are different variants of SQL Server 2005?
technology web technology

  1. Developer Edition

  2. Express Edition

  3. Integration Edition

  4. Standard Edition

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 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

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

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

What are the different recovery models in SQL Server 2005?
technology web technology

  1. Simple

  2. Bulk Logged

  3. Full

  4. All of the above

Show answer
Correct Option: D

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

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