"Unique Constraint" can be created on a column that accepts NULL

True or False? You cannot execute dynamic SQL code from a function.

Which statement is allowed inside of a User Defined Function?

Which of the following statements removes one or more previously granted or denied permissions?

Which of the following is used to change tracking?

TRUE OR FALSE: Is it possible to execute a Stored Procedure in a UDF.

Which of the following SQL queries correctly selects the rows from the table 'employees' that have NULL value in the 'salary' column?

Which of the following is the new sample database in the SQL SERVER 2005?

State whether True or False. The plus (+) and minus (-) operators cannot be used to perform increment/decrement operations on datetime and smalldatetime values.

You have two tables emp_1 and emp_2, having the following data: Table emp_1 Name Date Robert 1/5/2008 John 1/6/2008 Michael 1/7/2008 Rachael 1/10/2008 Joey 1/10/2008 Table emp_2 Name Date Lewis 1/05/2008 David 1/07/2008 George 1/11/2008 Jerry 1/12/2008 Monica 1/12/2008 The following query is run in the Query Analyzer: SELECT Date FROM emp_1 EXCEPT SELECT Date FROM emp_2 What will be the result of the query?

Which among the following are the new datatypes introduced in the SQL Server 2005?