Managing Multiuser Databases MCQs
Practice free Managing Multiuser Databases multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 43 questions — no login required.
Question 37hard
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
Question 38hard
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.
Question 39hard
A point of synchronization between the database and the transaction log is generally referred to as a stop point.
Advertisement
Question 41easy
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Question 42easy
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?
Advertisement