2. (TCO 3) What constraint can only be applied at table level or with an ALTER statement? (Points : 4) Foreign key Not null Single field primary key Composite primary key

Question 3. 3. (TCO 3) You are creating a table called Department with fields for the primary key DeptID (Integer) and department name (VARCHAR). What (if anything) is wrong with the following code? CREATE TABLE Department ( deptID INTEGER Primary Key, deptName VARCHAR(10) NOT NULL, ); (Points : 4)

You must use curly braces, not parentheses. The comma after NOT NULL must be removed. The keywords cannot be in uppercase. Nothing is wrong.

7. (TCO 7) A left join returns _____. (Points : 4) rows in the left table that dont satisfy the join condition unmatched rows from both the left and right tables rows in the right table that dont satisfy the join condition the Cartesian product of the two tables

Question 8. 8. (TCO 7) What type of subquery is executed once for each row processed by the main query? (Points : 4)

Correlated Uncorrelated Inner Outer

Question 9. 9. (TCO 7) Which of the following statements is correct? (Points : 4)

WHERE operates on groups formed by aggregate functions and HAVING operates on individual rows. WHERE can only be used along with HAVING. HAVING can only be used along with WHERE. WHERE operates on individual rows and HAVING operates on groups formed by aggregate functions.

Question 10. 10. (TCO 9) Assuming the SELECT statement below is a proper query, which is true regarding the following statement? CREATE VIEW example AS SELECT vendor_name, SUM(invoice_total) AS Invoice Sum FROM vendors JOIN invoices ON vendors.vendor_id = invoices.vendor_id GROUP BY vendor_name ORDER BY vendor_name; (Points : 4)

It will fail because the GROUP BY clause is not allowed in a view. It will fail because SUM function is not allowed in a view. It will fail because ORDER BY clause is not allowed in a view. It will succeed.