EXAMIANS
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
YOUR ANSWER : ?
YOUR ANSWER : ?
When two transactions are being processed against the database at the same time they are termed concurrent transactions.
YOUR ANSWER : ?
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
YOUR ANSWER : ?
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.
YOUR ANSWER : ?
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.
YOUR ANSWER : ?
A durable transaction is one in which all committed changes are permanent.
YOUR ANSWER : ?
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
YOUR ANSWER : ?
An exclusive lock locks the item from change but not from read.
YOUR ANSWER : ?
What is the overall responsibility of the DBA?
YOUR ANSWER : ?
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
YOUR ANSWER : ?