Consider the following query:

Select name from employees where name like "%_n_"

Which names will be displayed?

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?

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

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?

'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 is NOT an aggregate function in SQL Server?

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

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?