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 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.
YOUR ANSWER : ?
The advantage of optimistic locking is that:
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?
YOUR ANSWER : ?
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
YOUR ANSWER : ?
An exclusive lock locks the item from change but not from read.
YOUR ANSWER : ?
The size of the lock is referred to as the lock granularity.
YOUR ANSWER : ?
The size of a lock is called:
YOUR ANSWER : ?
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
YOUR ANSWER : ?
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
YOUR ANSWER : ?