Which of the following is not a type of Database backup in the SQL SERVER 2005?

Which clause will be used to extract data from Tables A and B having a similar structure but no relation between themselves?

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?

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 versions of SQL Server support table partitioning?

Which of the following best describes the flow for the execution of a CLR stored procedure?

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

Which of the following is used to change tracking?

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