Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.
Select an option to see the answer and solution.
Database · all questionsManaging Multiuser Databases
Managing Multiuser Databases
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
The overall responsibility of the DBA is to facilitate the development and use of the database.
Select an option to see the answer and solution.
The size of the lock is referred to as the lock granularity.
Select an option to see the answer and solution.
A durable transaction is one in which all committed changes are permanent.
Select an option to see the answer and solution.
An ACID transaction is one that is atomic, consistent isolated, and durable.
Select an option to see the answer and solution.
When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
Select an option to see the answer and solution.
The size of a lock is referred to as lock sizing.
Select an option to see the answer and solution.
When two transactions are being processed against the database at the same time they are termed concurrent transactions.
Select an option to see the answer and solution.
Locks placed by the DBMS are explicit locks.
Select an option to see the answer and solution.
In optimistic locking, the assumption is made that conflict will occur.
Select an option to see the answer and solution.
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.
Select an option to see the answer and solution.
The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.
Select an option to see the answer and solution.
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
Select an option to see the answer and solution.
Database administration refers to a function that applies to the entire organization.
Select an option to see the answer and solution.
Locks placed by command are implicit locks.
Select an option to see the answer and solution.
The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
Select an option to see the answer and solution.
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
Select an option to see the answer and solution.
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.
Select an option to see the answer and solution.
A point of synchronization between the database and the transaction log is generally referred to as a stop point.
Select an option to see the answer and solution.
An exclusive lock locks the item from change but not from read.
Select an option to see the answer and solution.