A table has following values for its department field:

marketing, production, production, sales, NULL, NULL, Marketing, Null

What will the following query return:

Select distinct(department) from employees

Consider the following two tables: 1. customers( customer_id, customer_name) 2. branch ( branch_id, branch_name ) What will be the output if the following query is executed: Select *, branch_name from customers,branch

Select the correct option:

Which of the following is false with regards to sp_help?

Which of the following is the syntax for creating an Index?

Study the situation described below and identify the nature of relationship? Each student can enroll into more than one class. Each class can accommodate more than one student.

Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?

User defined data type columns can be designated with ROWGUIDCOL.

What is returned by NULLIF if the two expressions that it compares are NOT equal?

An identifier denoting a global temporary object in SQL Server 2008 starts with a ______ sign.

What is the maximum value for the sum of the values of MIN_CPU_PERCENT and MIN_MEMORY_PERCENT for all the resource pools of SQL Server?