An ACID transaction is one that is atomic, consistent isolated, and durable. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction? Phantom read Dirty read Nonrepeatable read Consistent read 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 ________ . shared locks explicit locks implicit locks exclusive locks TRUE ANSWER : ? YOUR ANSWER : ?
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. Read uncommitted Read committed Repeatable read Serializable TRUE ANSWER : ? YOUR ANSWER : ?
When one transaction reads a changed record that has not been committed to the database a filthy read occurs. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following refers to a cursor type where changes of any type and from any source are visible? Static Keyset Dynamic Forward only TRUE ANSWER : ? YOUR ANSWER : ?
An exclusive lock locks the item from change but not from read. True False TRUE ANSWER : ? YOUR ANSWER : ?