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 the syntax for creating an Index?

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?

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