True Or False

Question 1 :

Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.


A). True
B). False
Answer : Option A

Question 2 :

The overall responsibility of the DBA is to facilitate the development and use of the database.


A). True
B). False
Answer : Option A

Question 3 :

The size of the lock is referred to as the lock granularity.


A). True
B). False
Answer : Option A

Question 4 :

A durable transaction is one in which all committed changes are permanent.


A). True
B). False
Answer : Option A

Question 5 :

An ACID transaction is one that is atomic, consistent isolated, and durable.


A). True
B). False
Answer : Option A

Question 6 :

When one transaction reads a changed record that has not been committed to the database a filthy read occurs.


A). True
B). False
Answer : Option B

Question 7 :

The size of a lock is referred to as lock sizing.


A). True
B). False
Answer : Option B

Question 8 :

When two transactions are being processed against the database at the same time they are termed concurrent transactions.


A). True
B). False
Answer : Option A

Question 9 :

Locks placed by the DBMS are explicit locks.


A). True
B). False
Answer : Option B

Question 10 :

In optimistic locking, the assumption is made that conflict will occur.


A). True
B). False
Answer : Option B

Question 11 :

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.


A). True
B). False
Answer : Option A

Question 12 :

The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.


A). True
B). False
Answer : Option B

Question 13 :

The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.


A). True
B). False
Answer : Option B

Question 14 :

Database administration refers to a function that applies to the entire organization.


A). True
B). False
Answer : Option B

Question 15 :

Locks placed by command are implicit locks.


A). True
B). False
Answer : Option B

Question 16 :

The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.


A). True
B). False
Answer : Option A

Question 17 :

A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.


A). True
B). False
Answer : Option B

Question 18 :

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.


A). True
B). False
Answer : Option A

Question 19 :

A point of synchronization between the database and the transaction log is generally referred to as a stop point.


A). True
B). False
Answer : Option B

Question 20 :

An exclusive lock locks the item from change but not from read.


A). True
B). False
Answer : Option B