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

Q. The blocks residing on the disk are referred to as ___________

View solution

Q. The area of memory where blocks temporarily reside is called as ________

View solution

Q. The most widely used structure for recording database modification is called as _______

View solution

Q. An update log record describes a ________ database write

View solution

Q. Which of the following fields does the update log record have?

View solution

Q. The unique identifier of the transaction that performed the write operation is called as _______

View solution

Q. The value of the data item prior to the write is called as _________

View solution

Q. If a transaction does not modify the database until it has committed it is said to use a _______ modification technique

View solution

Q. We say that a transaction has been ________ when its commit log record has been output to stable storage.

View solution

Q. State true or false: Using checkpoints reduces overhead

View solution