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 not an Aggregate function?

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

All Database Backup/Restore Related information stored in which system database?