Join our Telegram Channel

8000+ STATIC GK MCQs for SSC/ Railway/ PSC
1000 POLITICAL SCIENCE MCQS | EBook
Get 22 nos. GK EBooks | Combo Pack
Current Affairs Monthly Magazine -Subscribe Now!
1000 BIOLOGY MCQS AND ANSWERS | EBook
1000 ECONOMICS MCQS FOR EXAMS | EBook
Mughal Empire MCQs | EBook
ECONOMIC GEOGRAPHY MCQs | EBook
350 MCQs ON INDIAN CONSTITUTION | EBook

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]
Advertisement
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]
Advertisement

Chapters

General Knowledge

Month-wise Current Affairs 2022

Category-wise Current Affairs

Jobs by Qualification

Free Mock Test