Question 1

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

technology databases

(a) Database Mirroring
(b) Integration Services
(c) Notification Services
(d) All of the above

Answer

Correct Option: C

Question 2

SQL Profiler tool is used for?

technology databases

(a) Configuring Services
(b) Detecting slow running queries
(c) Troubleshooting
(d) All of the above

Answer

Correct Option: B,C

Question 3

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

technology databases

True
False

Answer

Correct Option: A

Question 4

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

technology databases

(a) DTUTIL
(b) BCP
(c) Object Explorer
(d) None of the above

Answer

Correct Option: D

Question 5

Which are the System Databases in SQL Server 2005?

technology databases

(a) Model database
(b) Master Database
(c) msdb
(d) Temporary database

Answer

Correct Option: A,B,C

Question 6

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

technology databases

(a) Desktop Applications
(b) Encrypted Stored procedures
(c) Stored procedures
(d) Trace files
(e) Triggers

Answer

Correct Option: C,D,E

Question 7

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

technology databases

(a) Distributed Queries
(b) OPENROWSET function
(c) Remote Stored Procedures
(d) Execute Statement
(e) All of the above

Answer

Correct Option: A,C,D

Question 8

Does SQL Server 2005 support SMTP?

technology databases

True
False

Answer

Correct Option: A

Question 9

What is Full Text Search in SQL Server 2005?

technology databases

(a) Allows fast and flexible indexing for keyword based query
(b) Provides a message based communication platform
(c) Supports sending Email from the database
(d) None of the above

Answer

Correct Option: A

Question 10

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 databases

(a) Use the bcp command
(b) Use the BULKINSERT statement
(c) Create a custom format file
(d) None of the above

Answer

Correct Option: A

Question 11

You want to access data that is located on two SQL Server 2005 computers. One Server is SQL 1 and the other server is SQL 2. You have permissions to write a stored Procedure on SQL 1 but on SQL 2 you have only permission to select data. You write a stored procedure on SQL 1. The stored procedure accesses SQL 2 by OPENQUERY T-SQL Statement. The query fails. What should you do the solve the problem?

technology databases

(a) Add SQL 2 as linked server to SQL 1
(b) Add SQL 2 as remote Server to SQL 1
(c) Reference SQL 2 by an alias
(d) None of the above

Answer

Correct Option: A

Question 12

You want to access data that is located on two SQL Server 2005 computers. One Server is SQL 1 and the other server is SQL 2. You have permissions to write a stored Procedure on SQL 1 but on SQL 2 you have only permission to select data. You write a stored procedure on SQL 1. The stored procedure accesses SQL 2 by OPENQUERY T-SQL Statement. The query fails. What should you do the solve the problem?

technology databases

(a) Add SQL 2 as linked server to SQL 1
(b) Add SQL 2 as remote Server to SQL 1
(c) Reference SQL 2 by an alias
(d) None of the above

Answer

Correct Option: A

Question 13

Which is true for recovery models :

technology databases

(a) In the Bulk-Logged recovery model, all transactions are logged
(b) In the Simple recovery model, all transactions are logged.
(c) In the Full recovery model, most transactions are minimally logged
(d) In the Simple recovery model, most transactions are minimally logged

Answer

Correct Option: D

Question 14

What does database schema do?

technology databases

(a) It defines the database catalog
(b) It defines the table catalog
(c) It groups database objects
(d) It groups databases

Answer

Correct Option: C

Question 15

Which data type would you use to store up to 2 GB of text data and still be able to query and manipulate it by using standard functions and operators?

technology databases

(a) Text
(b) Varbinary
(c) Varchar(max)
(d) Varchar

Answer

Correct Option: C

Question 16

Your database has become damaged. Which of the following can be used to determine which backups can be used to restore the database?

technology databases

(a) SQL Server error log
(b) msdb.dbo.sysbackuphistory table
(c) Windows Application Event Log
(d) msdb.dbo.backupset table

Answer

Correct Option: A,C,D

Question 17

You want to move a database from server 1 to server 2. When this operation is going on users should be able to execute their reports without modifying reports. Which method you will use?

technology databases

(a) Detach / attach
(b) SMO
(c) Backup/restore
(d) All

Answer

Correct Option: B,C

Question 18

Which operation is allowed in a trigger

technology databases

(a) Create index
(b) Alter database
(c) Insert data
(d) Restore Database

Answer

Correct Option: C

Question 19

Which will not allow to drop a table?

technology databases

(a) UNION
(b) SCHEMABINDING
(c) CHECK OPTION
(d) All

Answer

Correct Option: B

Question 20

Which option restricts changes to data to conform to the select criteria of a view?

technology databases

(a) SCHEMABINDING
(b) CHECK OPTION
(c) ANSI_NULLS
(d) All

Answer

Correct Option: B

Description: databases Online Quiz - 126
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 126

Find more quizzes from top tags