How is the following query incorrect?

select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

Which data type in the SQL SERVER 2005 converts itself into the type of data that is inserted into it?

Which of the following methods is used to backup the Transaction log on to a secondary database in order to backup and recover data in a synchronized manner?

Which of the following statements is/are wrong?

Which of the following is a database object?

State whether True or False. A User Defined Function 'findsum' is to be created as follows: Create function findsum(@x int, @y int) As Begin Return(@x+@y) End But the SQL SERVER is unable to create the desired function and gives an error. The error can be removed by specifying the return type of the function

True or False? The EXEC keyword and the EXEC() function are equivalent to each other.

Which of the following indices does NOT change the physical order of the rows in the table?

Which statement adds a row to a table?

What does 'UDF' stand for?

'Primary Key' can only be created on a column that doesn't accept NULL