Multiple Choices questions:

1. ________ is a relational set operator.

a. FROM

b. HAVING

c. EXCEPT

d. CROSS

2. In an SQL statement, the ________ specifies the table from which the data will be drawn.

a. IN clause

b. WHERE clause

c. FROM clause

d. ANY clause

9. A(n) ________ query can be used to produce a relation that retains duplicate rows.

a. UNION statement

b. UNION ALL statement

c. INTERSECT statement

d. EXCEPT statement

10. The ________ statement can be used to combine rows from two queries, returning only the rows that appear in both sets.

a. UNION statement

b. UNION ALL statement

c. INTERSECT statement

d. EXCEPT statement

11. The ________ in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

a. UNION statement

b. UNION ALL statement

c. INTERSECT statement

d. EXCEPT statement

12. Which of the following subqueries can be used in place of INTERSECT if the RDBMS does not support it?

a. IN subquery

b. HAVING subquery

c. ANY subquery

d. WHERE subquery

13. Which of the following subqueries can be used in place of MINUS if the RDBMS does not support it?

a. FROM subquery

b. NOT IN subquery

c. ALL subquery

d. HAVING subquery

14. The following SQL statement uses a(n) ________.

SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME

FROM PRODUCT, VENDOR

WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

a. Set operator

b. Natural join

c. Old-style join

d. Procedural statement

15. The ________ is the traditional join in which only rows that meet a given criteria are selected.

a. full join

b. inner join

c. outer join

d. set join

16. The statement SELECT * FROM T1, T2 produces a(n) ________.

a. cross join

b. natural join

c. old-style join

d. full join

17. A ________ of two tables returns rows with matching values and includes all rows from both tables with unmatched values.

a. natural join

b. cross join

c. full outer join

d. left outer join