Which Transact-SQL statement should you include at the beginning of a stored procedure to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back?

GETDATE() is a ....... function?

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?

Starting from the slowest, arrange the following operators in the order in which they produce results in 'SQL WHERE' query. 1. >, >=, <, <= 2. <> 3. = 4. LIKE

Which one of the following statements is correct?

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.