Q. Rollback of transactions is normally used to :

View solution

Q. A transaction performs on the isolation level of the Read Uncommitted if :

View solution

Q. Which commands are used to control which users have which privilege over which objects ?

View solution

Q. When a deadlock is detected the recovery is normally accomplished by :

View solution

Q. Which is not a desirable property of a transaction ?

View solution

Q. A directed graph which represents the deadlock is called :

View solution

Q. Transaction Throughput is :

View solution

Q. Data encryption techniques are particularly useful for

View solution

Q. Before any changes to database structure are attempted one should first:

View solution

Q. Which of the following modifications may not succeed?

View solution

Q. Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.

View solution

Q. Which of the following can cause a transaction failure

View solution

Q. If the transaction can no longer continue with its normal execution because of some internal condition, it is called as a _________

View solution

Q. If a system has entered and undesirable state due to which it is unable to continue with normal execution, it is called as _________

View solution

Q. If there is a hardware malfunction or a bug in the database that causes the loss of content of volatile storage, it is called as ________

View solution

Q. The assumption that the hardware errors bring the system to a halt is called as ________

View solution

Q. Which of the following is not a classification of storage

View solution

Q. If a failure has occurred in the midst of a transfer, it is called as _________

View solution

Q. State true or false: The destination block has incorrect information in case of a total failure

View solution

Q. The partitions of the database into fixed length storage units are called as __________

View solution