Question 1 of 25
Hints left: 3
Q1
Locks placed by command are implicit locks.
Q2
When two transactions are being processed against the database at the same time they are termed concurrent transactions.
Q3
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.
Q4
When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
Q5
The overall responsibility of the DBA is to facilitate the development and use of the database.
Q6
Locks placed by the DBMS are called ________ .
Q7
An ACID transaction is one that is atomic, consistent isolated, and durable.
Q8
A durable transaction is one in which all committed changes are permanent.
Q9
Which of the following locks the item from access of any type?
Q10
Database administration refers to a function that applies to the entire organization.
Q11
In optimistic locking, the assumption is made that conflict will occur.
Q12
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
Q13
A point of synchronization between the database and the transaction log is generally referred to as a stop point.
Q14
What is the overall responsibility of the DBA?
Q15
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
Q16
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
Q17
The size of the lock is referred to as the lock granularity.
Q18
Locks placed by the DBMS are explicit locks.
Q19
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
Q20
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.
Q21
The size of a lock is referred to as lock sizing.
Q22
The size of a lock is called:
Q23
Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.
Q24
The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
Q25
The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.