In optimistic locking, the assumption is made that conflict will occur. False True TRUE ANSWER : ? YOUR ANSWER : ?
A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all. True False TRUE ANSWER : ? YOUR ANSWER : ?
Locks placed by the DBMS are called ________ . exclusive locks shared locks implicit locks explicit locks TRUE ANSWER : ? YOUR ANSWER : ?
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images. True False TRUE ANSWER : ? YOUR ANSWER : ?
Locks placed by command are called ________ . explicit locks implicit locks exclusive locks shared locks TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read? Consistent read Nonrepeatable read Dirty read Phantom read TRUE ANSWER : ? YOUR ANSWER : ?
Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions. True False TRUE ANSWER : ? YOUR ANSWER : ?
What is the overall responsibility of the DBA? Both the first and third answers above are correct. Create and populate tables Facilitate the development and use of the database Development, operation, and maintenance of the database and its applications TRUE ANSWER : ? YOUR ANSWER : ?
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. Read committed Read uncommitted Serializable Repeatable read TRUE ANSWER : ? YOUR ANSWER : ?
The overall responsibility of the DBA is to facilitate the development and use of the database. False True TRUE ANSWER : ? YOUR ANSWER : ?