The simplest query must include at least ________ and _________.

Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set

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 used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?

Analyze the following code snippet: DECLARE @myTime TIME(4) = '02:02:02.234567 +01:01' SELECT @myTime AS '@myTime' What is the output of the above code?

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?