Which of the following operators is used for un-nesting the nested tuples and bags?

Which query is valid?

Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries work?

Which of the following are false for batches (batch commands)?

View the following Create statement: 1 Create table Pers 2(EmpNo Int not null, 3 EName Char not null, 4 Join Datetime not null, 5 Pay Smallmoney) Which line contains an error?

The IF UPDATE (column_name) parameter in a trigger definition will return TRUE in case of an INSERT statement being executed on the triggered table:

What is the numeric range that is supported by the datatype tinyint?

A cursor is a pointer that identifies a specific working row within a set

How can you change 'Hansen' into 'Nilsen' in the LastName column in the PersonsTable?

You should avoid the use of cursors because:

Consider the transaction: Begin Transaction Create table A ( x smallint , y smallint ) Create table B ( p smallint , q smallint ) Update A set x=600 where y > 700 Update B set p=78 where q=99 If @@ error != 0 Begin RollBack Transaction Return End Commit Transaction Select the correct option: