The size of the lock is referred to as the lock granularity. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads? Serializable Read committed Repeatable read Read uncommitted TRUE ANSWER : ? YOUR ANSWER : ?
The overall responsibility of the DBA is to facilitate the development and use of the database. True False TRUE ANSWER : ? YOUR ANSWER : ?
The size of a lock is called: implicit lock exclusive lock shared lock lock granularity TRUE ANSWER : ? YOUR ANSWER : ?
Locks placed by the DBMS are called ________ . exclusive locks implicit locks shared locks explicit locks TRUE ANSWER : ? YOUR ANSWER : ?
A durable transaction is one in which all committed changes are permanent. True False 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 Dirty read Phantom read Nonrepeatable read TRUE ANSWER : ? YOUR ANSWER : ?
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. Repeatable read Read committed Serializable Read uncommitted TRUE ANSWER : ? YOUR ANSWER : ?
A point of synchronization between the database and the transaction log is generally referred to as a stop point. True False TRUE ANSWER : ? YOUR ANSWER : ?
A cursor type in which the application can only move forward through the recordset is called: forward only. keyset. static. dynamic. TRUE ANSWER : ? YOUR ANSWER : ?