Examine the data in the EMPLOYEES table given below:

LAST_NAME  DEPTARTMENT_ID     SALARY

ALLEN                10                      3000

MILLER              20                     1500

King                   20                      2200

Davis                 30                      5000

Which of the following Subqueries work?

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?

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:

The STUDENT_GRADES table has these columns: STUDENT_ID INT SEMESTER_END DATETIME GPA FLOAT Which of the following statements finds the highest Grade Point Average (GPA) per semester?

You use a Command object to retrieve employee names from the employee table in the database. Which of the following will be returned when this command is executed using ExecuteReader method?

Consider the following two tables: 1. customers( customer_id, customer_name) 2. branch ( branch_id, branch_name ) What will be the output if the following query is executed: Select *, branch_name from customers,branch

The STUDENT_GRADES table has these columns: STUDENT_ID INT SEMESTER_END DATETIME GPA FLOAT Which of the following statements finds the highest Grade Point Average (GPA) per semester?

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:

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?

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

Examine the two SQL statements given below: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC What is true about them?