What does referential integrity (also called relational integrity) prevent?

Which one is true with reference to Triggers?

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

Consider the following table structure of students: rollno int name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?

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:

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?