Managing Multiuser Database Questions and Answers
Practice ModeShowing 10 of 20 questions
Q1
Locks placed by command are called ________ .
Answer: Option B
Q2
Which of the following locks the item from change but not from read?
Answer: Option D
Q3
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?
Answer: Option B
Q4
A transaction for which all committed changes are permanent is called:
Answer: Option D
Q5
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Answer: Option A
Q6
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Answer: Option A
Q7
The advantage of optimistic locking is that:
Answer: Option A
Q8
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?
Answer: Option C
Q9
Which of the following refers to a cursor type where changes of any type and from any source are visible?
Answer: Option D
Q10
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Answer: Option C