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-3 section-1

21
Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
22
The overall responsibility of the DBA is to facilitate the development and use of the database.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
23
The size of the lock is referred to as the lock granularity.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
24
A durable transaction is one in which all committed changes are permanent.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
25
An ACID transaction is one that is atomic, consistent isolated, and durable.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
26
When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
27
The size of a lock is referred to as lock sizing.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
28
When two transactions are being processed against the database at the same time they are termed concurrent transactions.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
29
Locks placed by the DBMS are explicit locks.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
30
In optimistic locking, the assumption is made that conflict will occur.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board