A durable transaction is one in which all committed changes are permanent. True False TRUE ANSWER : ? YOUR ANSWER : ?
Database administration refers to a function that applies to the entire organization. True False TRUE ANSWER : ? YOUR ANSWER : ?
Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed. False True 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 : ?
What is the overall responsibility of the DBA? Facilitate the development and use of the database Create and populate tables Both the first and third answers above are correct. Development, operation, and maintenance of the database and its applications TRUE ANSWER : ? YOUR ANSWER : ?
The size of the lock is referred to as the lock granularity. 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 Phantom read Nonrepeatable read Dirty read TRUE ANSWER : ? YOUR ANSWER : ?
A point of synchronization between the database and the transaction log is generally referred to as a stop point. False True 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. False True TRUE ANSWER : ? YOUR ANSWER : ?
Locks placed by command are called ________ . implicit locks explicit locks exclusive locks shared locks TRUE ANSWER : ? YOUR ANSWER : ?