16. The ________________ command is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another.

A. SELECT ONLY V_CODE

FROM PRODUCT;

B. SELECT UNIQUE V_CODE

FROM PRODUCT;

C. SELECT DIFFERENT V_CODE

FROM PRODUCT;

D. SELECT DISTINCT V_CODE

FROM PRODUCT;

17. All transactions must display _____________________.

A. atomicity, serializability, and durability

B. durability, atomicity, consistency, and isolation

C. serializability, durability, and isolation

D. durability and isolation

18. The ANSI has defined standards that govern SQL database transactions. Transaction support is provided by two SQL statements: ____________________ and ROLLBACK.

A. RETRIEVE

B. ASSIGN

C. UPDATE

D. COMMIT

19. Joe is working on the Course table and needs to know which courses have prerequisite. To find the information he would ____________.

A. create a new query

B. create a new table

C. create a new form

D. create a new constraint