Join our Telegram Channel

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

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]


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]

Take Mock Tests

Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Economy Mock Test 2 Unlock Test!
Economy Mock Test 3 Unlock Test!
Economy Mock Test 4 Unlock Test!
Economy Mock Test 5 Unlock Test!
Books & Authors - Test 2 Unlock Test!