Which one of the following must be specified in every DELETE statement?

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?

Consider the following tables: Books ------ BookId BookName AuthorId SubjectId PopularityRating (the popularity of the book on a scale of 1 to 10) Language (such as French, English, German etc) Subjects --------- SubjectId Subject (such as History, Geography, Mathematics etc) Authors -------- AuthorId AuthorName Country What is the query to determine how many books have been written on each subject. Displaying Name of Subject and count of the Books?

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)?