Which statement adds a row to a table?

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

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

'SELECT UNIQUE city FROM customers' will return what data set?

Which of the following is NOT an aggregate function in SQL Server?

'SELECT name FROM t1 UNION SELECT name FROM t2 ' is the same as 'SELECT DISTINCT name FROM t1 UNION ALL SELECT DISTINCT name FROM t2'

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 data type in the SQL SERVER 2005 converts itself into the type of data that is inserted into it?

How is the following query incorrect? select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

Which query will be used for a particular column of a table, if 'Reading' is to be replaced by 'Writing'?

You want to select a row using cursors in the table 'qlist'. Which of the following statements DECLARES a cursor 'qselect' to perform the desired operation?