Managing Multiuser Databases MCQs
Practice free Managing Multiuser Databases multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 43 questions — no login required.
Question 28hard
When two transactions are being processed against the database at the same time they are termed concurrent transactions.
Question 30medium
In optimistic locking, the assumption is made that conflict will occur.
Advertisement
Question 31hard
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.
Question 32hard
The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.
Question 33hard
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
Advertisement
Question 34medium
Database administration refers to a function that applies to the entire organization.
Question 36hard
The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.