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

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?

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

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

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

Which level of data abstraction describes the data that is stored in the database and their corresponding relationships?

Which of the following is used to change tracking?

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

Which statement is allowed inside of a User Defined Function?

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

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