1 The purpose of a HAVING clause in a query is to apply conditions to the groups formed by "GROUP BY".

a) True

b) False

2) A Foreign Key with CASCADE DELETE means that if a record in the referenced table is deleted, then the corresponding records in the referencing table will automatically be deleted too.

a) True

b) False

3) Consider the schema below , Which of the following finds the first name and last name10+ of all employees who are professors with the title as 'assistant professor' and first names starting with the letter W.

(a) SELECT fname, lname FROM employee WHERE fname LIKE 'W%' AND ssn IN ( SELECT ssn FROM professor WHERE title = 'assistant professor' );

(b) SELECT fname, lname FROM employee WHERE fname LIKE 'W%' AND ssn = (SELECT ssn FROM professor WHERE title = 'assistant professor');

(c) SELECT fname, lname FROM employee INNER JOIN professor ON employee.ssn = professor.ssn WHERE fname LIKE "W%" AND title = 'assistant professor';

(d) SELECT fname, lname FROM employee WHERE fname LIKE 'W%' AND ssn = (SELECT ssn FROM employee WHERE title = 'assistant professor');

(e) All of these

(d) None of these