DB Recovery Systems Mcqs

Our collections of Multiple choice questions and answers focuses on study of ” DB Recovery Systems “. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate knowledge on DB Recovery Systems comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. DB Recovery Systems Mcqs
  8. »
  9. Page 2

Computer MCQS

Sciences MCQS

aaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

16.
If the transaction can no longer continue with its normal execution because of some internal condition, it is called as a _________

Logical error

System error

System crash

None of the mentioned

Answer Discus (0)
baaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

17.
If a system has entered and undesirable state due to which it is unable to continue with normal execution, it is called as _________

Logical error

System error

System crash

None of the mentioned

Answer Discus (0)
caaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

18.
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 ________

Logical error

System error

System crash

None of the mentioned

Answer Discus (0)
caaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

19.
The assumption that the hardware errors bring the system to a halt is called as ________

Halter assumption

Phantom assumption

Fail-stop assumption

Disk failure

Answer Discus (0)
daaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

20.
Which of the following is not a classification of storage

Volatile storage

Nonvolatile storage

Stable storage

None of the mentioned

Answer Discus (0)
baaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

21.
If a failure has occurred in the midst of a transfer, it is called as _________

Successful completion

Partial failure

Total failure

None of the mentioned

Answer Discus (0)
aaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

22.
The partitions of the database into fixed length storage units are called as __________

Blocks

Tuples

Relations

None of the mentioned

Answer Discus (0)
aaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

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

Physical blocks

Buffer blocks

Disk blocks

Disk buffer

Answer Discus (0)
baaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

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

Block buffer

Disk buffer

Physical buffer

None of the mentioned

Answer Discus (0)
aaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

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

Log

List

Queue

Stack

Answer Discus (0)
aaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

26.
An update log record describes a ________ database write

Single

Double

Triple

Quadruple

Answer Discus (0)
daaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

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

Transaction identifier

Data-item identifier

Old value

All of the mentioned

Answer Discus (0)
aaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

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

Transaction identifier

Data-item identifier

Old value

New value

Answer Discus (0)
caaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

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

Transaction identifier

Data-item identifier

Old value

New value

Answer Discus (0)
aaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa

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

Deferred

Immediate

More than one of the mentioned

None of the mentioned

Answer Discus (0)

Engineering MCQS

General Subjects MCQS

error: You are not allowed to do so.....
0Shares
0
Scroll to Top