a) Compensation log records
b) Read log records
c) Page log records
d) Redo log records
Answer: a
Explanation: These serve the same purpose as the redo-only log records in our earlier recovery scheme
The __________________ contains a list of pages that have been updated in the database buffer.
a) Dirty page table
b) Page table
c) Dirty redo
d) All of the mentioned
Answer: a
Explanation: Dirty pages are those that have been updated in memory, and the disk version is not up-to-date.
___________ 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.
a) Analysis pass
b) Redo pass
c) Undo pass
d) None of the mentioned
Answer: a
Explanation:The analysis pass finds the last complete checkpoint log record, and reads in the DirtyPageTable from this record.
__________ 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.
a) Analysis pass
b) Redo pass
c) Undo pass
d) None of the mentioned
View Answer
Answer: b
Explanation:The redo pass repeats history by replaying every action that is not already reflected in the page on disk.
______________ rolls back all transactions that were incomplete at the time of crash.
a) Analysis pass
b) Redo pass
c) Undo pass
d) None of the mentioned
Answer: c
Explanation:It performs a single backward scan of the log, undoing all transactions in undo-list.
The silicon chips used for data processing are called
a) RAM chips
b) ROM chips
c) Micro processors
d) PROM chips
Answer: d
Explanation: PROM is Programmable Read Only Memory.
Which of the following is used for manufacturing chips?
a. Control bus
b. Control unit
c. Parity unit
d. Semiconductor
Answer: d
Explanation: A semiconductor is a material which has electrical conductivity between that of a conductor such as copper and that of an insulator such as glass.
The number of colours required to properly colour the vertices of every planer graph is
A. 2
B. 3
C. 4
D. 5
According to the Five-colour theorem, Every planar graph is 5-colourable. Any planar graph G with n vertices requires five colors for proper coloring. So the answer must be option D which is 5.
The search concept used in associative memory is
a) Sequential search b) Parallel search c) Binary search d) Selection search
Ans:B
The data on the tracks on a magnetic disks are written as
A. Up or down
B. Tiny magnetic spots
C. 0 or 1
D. High or low voltage
Ans:B
UNIX: Environment variables can be accessed by
a. System Programs
b. C Programs
c. Shell Scripts
d. NONE
Ans:C
0 comments:
Post a Comment