EXAMIANS
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 : ?
YOUR ANSWER : ?
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 : ?
The size of a lock is called:
YOUR ANSWER : ?
A cursor type in which the application can only move forward through the recordset is called:
YOUR ANSWER : ?
The size of a lock is referred to as lock sizing.
YOUR ANSWER : ?
When two transactions are being processed against the database at the same time they are termed concurrent transactions.
YOUR ANSWER : ?
Locks placed by command are called ________ .
YOUR ANSWER : ?
The size of the lock is referred to as the lock granularity.
YOUR ANSWER : ?
An exclusive lock locks the item from change but not from read.
YOUR ANSWER : ?
Locks placed by the DBMS are explicit locks.
YOUR ANSWER : ?