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

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

What is the correct syntax for a CTE?

What does DBCC stand for?

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

When you are dealing with lots of NULL Values in columns,which datatype is better?

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

What exactly is a Super key?

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

Which one of the following statements about Indexes is wrong?

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