Home/Database/Managing Multiuser Databases

Managing Multiuser Databases MCQs

43 questionsDatabasePage 2 of 5

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 10medium

Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?

⚑ Report ✎ Feedback

Question 11medium

Dirty read, nonrepeatable, and phantom reads are not possible in this instance.

⚑ Report ✎ Feedback

Question 12medium

A transaction in which either all of the database actions occur or none of them do is called:

⚑ Report ✎ Feedback

Question 13medium

A cursor type in which the application can only move forward through the recordset is called:

⚑ Report ✎ Feedback

Question 14medium

Which of the following occurs when one transaction reads a changed record that has not been committed to the database?

⚑ Report ✎ Feedback

Question 15medium

Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?

⚑ Report ✎ Feedback

Question 16easy

Which of the following locks the item from access of any type?

⚑ Report ✎ Feedback

Question 17easy

The size of a lock is called:

⚑ Report ✎ Feedback

Question 18medium

A cursor type in which the application sees the data as they were at the time the cursor was opened is called:

⚑ Report ✎ Feedback