Which of the following mechanisms is used by "ENCRYPTION by passphrase" to encrypt the data in the SQL SERVER 2005?

Which one of the following statements about Indexes is wrong?

__________ is a container that holds tables, views, procedures, functions and so on.

What exactly is a Super key?

State whether True or False. Triggers can be created in Assemblies.

Which one of the following statements is correct?

To Improve stored procedure performance,which statement below is used to write beginning of SP?

What does DBCC stand for?

What is the correct syntax for a CTE?

Which of the following SQL Server built-in functions is nondeterministic?

Given a table with the following schema: create table table1 (field1 int) The table contains 1000 records. What would the following sql statement result in: update top (100) table1 set field1 = 1