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

View solution

Q. The order of log records in the stable storage ____________ as the order in which they were written to the log buffer.

View solution

Q. Before a block of data in main memory can be output to the database, all log records pertaining to data in that block must have been output to stable storage. This is

View solution

Q. Writing the buffered log to __________ is sometimes referred to as a log force.

View solution

Q. The _______________ policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.

View solution

Q. ______________ policy allows multiple updates to accumulate on a block before it is output to stable storage, which can reduce the number of output operations greatly for frequently updated blocks.

View solution

Q. The ___________ policy, allows the system to write modified blocks to disk even if the transactions thatmade those modifications have not all committed.

View solution

Q. Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing them in a non-two-phase manner does not have any implications on transaction serializability. This is

View solution

Q. The __________________ contains a list of blocks that have been updated in the database buffer.

View solution

Q. The operating system reserves space on disk for storing virtual-memory pages that are not currently in main memory; this space is called

View solution

Q. What was the name of the first commercially available microprocessor chip?

View solution

Q. The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving parts are known as

View solution

Q. Which of the following is used only for data entry and storage, and never for processing?

View solution

Q. Non-volatile storage needs to have a _________ where the loses in future can be recovered.

View solution

Q. A dump of the database contents is also referred to as an _____________ dump.

View solution

Q. ________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re-create the database.

View solution

Q. _________ dump schemes have been developed that allow transactions to be active while the dump is in progress.

View solution

Q. ARIES uses a ___________ to identify log records, and stores it in database pages.

View solution

Q. ARIES supports ___________ operations, which are physical in that the affected page is physically identified, but can be logical within the page.

View solution

Q. ______________ is used to minimize unnecessary redos during recovery.

View solution