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:

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?

Examine the description of the STUDENTS table: STD_ID INT COURSE_ID VARCHAR (10) START_DATE DATETIME END_DATE DATETIME The aggregate functions valid on the START_DATE column are:

Sample Code CREATE TABLE table1( column1 varchar(50), column2 varchar(50), column3 varchar(50), column4 varchar(50)); Which one of the following is the correct syntax for adding the column named 'column2a' to the table shown above?

What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;

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 return type of the value returned by @@DATEFIRST in SQL Server 2008?

The AND operator displays a row if ANY conditions listed are true. The OR operator displays a row if ALL of the conditions listed are true

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

What is the correct SQL syntax for selecting all the columns where the 'LastName' is alphabetically between (and including) 'Hansen' and 'Pettersen'?

The sales database contains a customer table and an order table. For each order there is one and only one customer, and for each customer there can be zero or more orders. How should primary and foreign key fields be placed into the design of this database?