The size of the lock is referred to as the lock granularity.
Answer: A
No answer description available for this question.
Enter details here
When two transactions are being processed against the database at the same time they are termed concurrent transactions.
Answer: A
No answer description available for this question.
Enter details here
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Answer: C
No answer description available for this question
Enter details here
What is the overall responsibility of the DBA?
Answer: D
No answer description available for this question.
Enter details here
A transaction for which all committed changes are permanent is called:
Answer: D
No answer description available for this question.
Enter details here
A cursor type in which the application can only move forward through the recordset is called:
Answer: A
No answer description available for this question.
Enter details here
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
Answer: B
No answer description available for this question.
Enter details here
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Answer: A
No answer description available for this question.
Enter details here
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.
Answer: A
No answer description available for this question.
Enter details here
The overall responsibility of the DBA is to facilitate the development and use of the database.
Answer: A
No answer description available for this question.
Enter details here