Database Backup and Recovery Multiple Choice Questions Answers | Database Management System

Questions
1 A deadlock exists in the system if and only if the wait for graph :
A has a cycle in it
B has a path from first node to last node
C is a tree
D none of the above

Answer: Option [A]
2 Data processing cycle consists of :
A Input cycle and output cycle
B Input cycle, output cycle, storage and processing cycle
C Output cycle and processing cycle
D None of these

Answer: Option [B]

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
3 Which of the following is not a proper state of transaction ?
A Partially aborted
B Partially committed
C Aborted
D Committed

Answer: Option [A]
4 Which of the following concurrency-control schemes is not based on the serializability Property ?
A Two-phase locking
B Graph-based locking
C Timestamp-based locking
D None of the above

Answer: Option [D]
5 Rollback of transactions is normally used to :
A recover from transaction failure
B update the transaction
C retrieve old records
D repeat a transaction

Answer: Option [A]

Chapters

ADRE 3.0 Complete Study Material