6. Which of the following will cause a deadlock? A. Transaction T1 requests an exclusive lock on data A at the same time as transaction T2 B. Transaction T1 places an exclusive lock on data A, then transaction T2 requests a shared lock on data A C. Transaction T1 and T2 modify data A without any lock D. Transaction T1 places an exclusive lock on data A, then requests one on data B. Simultaneously, transaction T2 places an exclusive lock on data B, then requests one on data A

7. Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee) under the immediate update mode. The transaction terminates abnormally after 10 rows have been updated in the database (and the normal operations have taken place on the log). What should the recovery procedure perform to make sure the transaction completes as desired? A. Redo B. Redo followed by execution of the transaction again C. Undo followed by execution of the transaction again D. Undo

8. The _______________ query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1.

A. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE

FROM PRODUCT

WHERE P_CODE <'1558-QW1';

B. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE

FROM PRODUCT

WHERE P_CODE = [1558-QW1]

C. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE

FROM PRODUCT

WHERE P_CODE = (1558-QW1)

D. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE

FROM PRODUCT

WHERE P_CODE = {1558-QW1}

9. The primary objective of database design is __________________.

A. To create the most efficient database possible

B. To create the fastest queries

C. To create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models

D. To be able to add data quickly

10. The command to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the value of V_CODE match is ________________.

A. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE

FROM PRODUCT, VENDOR

WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;

B. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE

FROM PRODUCT, VENDOR

WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

C. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE

FROM PRODUCT, VENDOR

WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;

D. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE

FROM PRODUCT, VENDOR

WHERE PRODUCT.V_CODE => VENDOR.V_CODE;