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 : ?
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction. False True TRUE ANSWER : ? YOUR ANSWER : ?
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. Read uncommitted Repeatable read Read committed Serializable TRUE ANSWER : ? YOUR ANSWER : ?
The advantage of optimistic locking is that: the lock is obtained before the transaction has processed. transactions that are best suited are those with a lot of activity. the lock never needs to be obtained. the lock is obtained only after the transaction has processed. TRUE ANSWER : ? YOUR ANSWER : ?
Locks placed by command are called ________ . implicit locks explicit locks shared locks exclusive locks TRUE ANSWER : ? YOUR ANSWER : ?
A durable transaction is one in which all committed changes are permanent. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur? Read committed Serializable Repeatable read Read uncommitted TRUE ANSWER : ? YOUR ANSWER : ?
Database administration refers to a function that applies to the entire organization. True False TRUE ANSWER : ? YOUR ANSWER : ?
A cursor type in which the application sees the data as they were at the time the cursor was opened is called: static forward only dynamic keyset TRUE ANSWER : ? YOUR ANSWER : ?
An ACID transaction is one that is atomic, consistent isolated, and durable. False True TRUE ANSWER : ? YOUR ANSWER : ?