Home/Database/Managing Multiuser Databases

Managing Multiuser Databases MCQs

43 questionsDatabasePage 1 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 1easy

Locks placed by command are called ________ .

⚑ Report ✎ Feedback

Question 2medium

Which of the following locks the item from change but not from read?

⚑ Report ✎ Feedback

Question 3hard

Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

⚑ Report ✎ Feedback

Question 4easy

A transaction for which all committed changes are permanent is called:

⚑ Report ✎ Feedback

Question 5medium

In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.

⚑ Report ✎ Feedback

Question 6hard

Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

⚑ Report ✎ Feedback

Question 7easy

The advantage of optimistic locking is that:

⚑ Report ✎ Feedback

Question 8hard

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?

⚑ Report ✎ Feedback

Question 9medium

Which of the following refers to a cursor type where changes of any type and from any source are visible?

⚑ Report ✎ Feedback