EXAMIANS
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
YOUR 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.
YOUR ANSWER : ?
When two transactions are being processed against the database at the same time they are termed concurrent transactions.
YOUR ANSWER : ?
Which of the following locks the item from access of any type?
YOUR ANSWER : ?
The size of the lock is referred to as the lock granularity.
YOUR ANSWER : ?
A transaction in which either all of the database actions occur or none of them do is called:
YOUR ANSWER : ?
Locks placed by the DBMS are called ________ .
YOUR ANSWER : ?
Which of the following refers to a cursor type where changes of any type and from any source are visible?
YOUR ANSWER : ?
Locks placed by the DBMS are explicit locks.
YOUR ANSWER : ?
A durable transaction is one in which all committed changes are permanent.
YOUR ANSWER : ?