database:

1.

2.

3.

4.

5.

Which command would be used to update more than one attribute in table row where the P_CODE = '13-Q2/P Select one: O a. UPDATE PRODUCT SET P_INDATE = '18-JAN-2018' AND P_PRICE = 17.99 AND P_MIN = 10 WHERE P_CODE = '13-Q2/P2': O b. UPDATE PRODUCT SET P INDATE = '18-JAN-2018 SET P_PRICE = 17.99 SET P_MIN = 10 WHERE P_CODE = '13-Q2/P2'; O c. UPDATE PRODUCT SET P_INDATE = '18-JAN-2018', P_PRICE = 17.99, P_MIN = 10 WHERE P_CODE = '13-Q2/P2'; O d. UPDATE PRODUCT SET P_INDATE = '18-JAN-2018'; P_PRICE = 17.99; P_MIN = 10 WHERE P_CODE = '13-Q2/P2'; The manager is responsible for assigning and policing the locks used by transactions. Select one: a. transaction b. database O c. lock d. schedule Which command would be used to delete the table row where the P CODE is 'BRT-345"? Select one: ROLLBACK FROM PRODUCT WHERE P CODE = 'BRT-345'; O b. DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345'; PRODUCT c. ERASE FROM WHERE P_CODE = 'BRT-345'; PRODUCT O d. REMOVE FROM WHERE P_CODE = 'BRT-345'; requires that all operations of a transaction be completed. Select one: a. Time stamping O b. Specificity O c. Durability O d. Atomicity A lock will lock the entire table, preventing access to any row by a transaction while another transaction is using the table. Select one: O a. page-level O b. row-level C. table-level d. database-level