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'

A relationship that identifies that a column contains primary key values from another table is referred as what?

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?

Consider the following query: Select name from employees where name like '%_n_' Which names will be displayed?