ExamVeda
Login
Home

Managing Multiuser Databases - Database MCQ Questions and answers- Technical Aptitude

Managing Multiuser Databases(Database) mcq questions and answers with easy and logical explanations for various competitive examination, interview and entrance test. Database Mcq question are important for technical exam and interview.

1
Locks placed by command are called ________ .
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
2
Which of the following locks the item from change but not from read?
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
3
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?
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
4
A transaction for which all committed changes are permanent is called:
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
5
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
6
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
7
The advantage of optimistic locking is that:
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
8
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?
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
9
Which of the following refers to a cursor type where changes of any type and from any source are visible?
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
10
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board