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

Q. A __________ checkpoint is a checkpoint where transactions are allowed to perform updates even while buffer blocks are being written out.

View solution

Q. If the database modifications occur while the transaction is still active, the transaction is said to use the __________ modification technique

View solution

Q. The log is a sequence of _________ recording all the update activities in the database.

View solution

Q. The current copy of the database is identified by a pointer, called ____________ which is stored on disk.

View solution

Q. A special redo-only log record <Ti , Xj , V1> is written to the log, where V1 is the value being restored to data item Xj during the rollback. These log records are sometimes called

View solution

Q. In order to reduce the overhead in retrieving the records from the storage space we use

View solution