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. Page-2 section-1

11
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
12
A transaction in which either all of the database actions occur or none of them do is called:
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
13
A cursor type in which the application can only move forward through the recordset is called:
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
14
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
15
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
16
Which of the following locks the item from access of any type?
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
17
The size of a lock is called:
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
18
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
19
What is the overall responsibility of the DBA?
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
20
Locks placed by the DBMS are called ________ .
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board