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

31
Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
32
The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
33
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
34
Database administration refers to a function that applies to the entire organization.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
35
Locks placed by command are implicit locks.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
36
The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
37
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
Discuss
Answer & Solution
Answer: Option B
Solution:
Phantom read does not refer to modifications or deletions of existing rows.

It occurs when a transaction reads a set of rows that satisfy a condition, and then, upon re-execution of the same query, finds additional rows (phantoms) that were inserted by another committed transaction.

This is different from non-repeatable reads, where a transaction rereads data and finds that it has been modified or deleted by another transaction.

Therefore, the statement given in the question describes a non-repeatable read, not a phantom read.
38
A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
39
A point of synchronization between the database and the transaction log is generally referred to as a stop point.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
40
An exclusive lock locks the item from change but not from read.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board