"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?

All Database Backup/Restore Related information stored in which system database?

'Unique Constraint' can be created on a column that accepts NULL

True or False? You cannot execute dynamic SQL code from a function.

Which statement is allowed inside of a User Defined Function?

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

Which of the following is not an Aggregate function?

Which level of data abstraction describes the data that is stored in the database and their corresponding relationships?

Which of the following SQL queries correctly selects the rows from the table 'employees' that have NULL value in the 'salary' column?

Which of the following is the new sample database in the SQL SERVER 2005?