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

Q. __________ scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk.

View solution

Q. Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the _______ field of the page.

View solution

Q. There are special redo-only log records generated during transaction rollback, called _________ in ARIES.

View solution

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

View solution

Q. ___________ determines which transactions to undo,which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.

View solution

Q. __________ starts from a position determined during analysis, and performs a redo, repeating history, to bring the database to a state it was in before the crash.

View solution

Q. ______________ rolls back all transactions that were incomplete at the time of crash.

View solution

Q. Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.

View solution

Q. The remote backup site is sometimes also called the

View solution

Q. Remote backup system must be _________ with the primary site.

View solution

Q. The backup is taken by

View solution