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]

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!