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 best describes the flow for the execution of a CLR stored procedure?

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?

You have a database named 'marketnikkie', the backup of which is stored at 'D:\marketnikkie.bak' location on your server. Due to some electric fluctuations, the database gets corrupt. Which of the following is the correct query to restore your database?