database:

1.

2.

3.

4.

5.

means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed. Select one: O a. Serializability O b. Time stamping O c. Atomicity O d. Isolation As long as two transactions, T1 and T2, access data, there is no conflict, and the order of execution is irrelevant to the final outcome. Select one: a. unrelated b. locked C. shared d. common The information stored in the is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program's abnormal termination, or a system failure such as a network discrepancy or a disk crash. Select one: a. transaction log b. rollback manager C. metadata O d. data dictionary Which command would be used to add 5 percent to the price for all products that have current prices below $100? Select one: a. UPDATE PRODUCT SET P PRICE =P PRICE +P PRICE * 5% WHERE P PRICE