Tag: databases

Questions Related to databases

SQL Server 2005 has the ability to improve business intelligence. Which features help to achieve this?

technology databases

  1. (a) Data Migration

  2. (b) Improved analytical capabilities

  3. (c) Smaller Data engine

  4. (d) Superior Integration properties

Show answer
Correct Option: A,B,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 databases

  1. (a) SQL Server 2005 Developer Edition

  2. (b) SQL Server 2005 Enterprise Edition

  3. (c) SQL Server 2005 Standard Edition

  4. (d) SQL Server 2005 Express Edition

Show answer
Correct Option: B,C

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

  1. (a) Database Mirroring

  2. (b) Integration Services

  3. (c) Notification Services

  4. (d) All of the above

Show answer
Correct Option: C

SQL Profiler tool is used for?
technology databases

  1. (a) Configuring Services

  2. (b) Detecting slow running queries

  3. (c) Troubleshooting

  4. (d) All of the above

Show answer
Correct Option: B,C

Is it possible to rename a database and database objects in SQL Server 2005?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

  1. (a) DTUTIL

  2. (b) BCP

  3. (c) Object Explorer

  4. (d) None of the above

Show answer
Correct Option: D

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

  1. (a) Model database

  2. (b) Master Database

  3. (c) msdb

  4. (d) Temporary database

Show answer
Correct Option: A,B,C

Which objects related to a SQL Server component can you analyze using Upgrade Advisor?
technology databases

  1. (a) Desktop Applications

  2. (b) Encrypted Stored procedures

  3. (c) Stored procedures

  4. (d) Trace files

  5. (e) Triggers

Show answer
Correct Option: C,D,E

What are the different options in SQL Server 2005 for accessing a Linked Server?
technology databases

  1. (a) Distributed Queries

  2. (b) OPENROWSET function

  3. (c) Remote Stored Procedures

  4. (d) Execute Statement

  5. (e) All of the above

Show answer
Correct Option: A,C,D

Does SQL Server 2005 support SMTP?
technology databases

  1. True

  2. False

Show answer
Correct Option: A