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:

You should avoid the use of cursors because:

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

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

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

Which constraints can be used to enforce the uniqueness of rows in a table?

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?

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

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 query is valid?

Which operator is used for un-nesting the nested tuples and bags?