Database Management Questions & Answers: part2

Software Programming : Database Management QUESTIONS AND ANSWERS :: part2 : 6 to 10

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2015 examinations :

6.When a regular entity type contains a multivalued attribute, one must

Create a single relation with multiple lines for each instance of the multivalued attribute
Create two new relations, one containing the multivalued attribute
Create two new relations, both containing the multivalued attribute
Crate three new relations
None of the above.

7.Which protocol ensures conflict serializability?

Value based protocol
Read based protocol
Timestamp based protocol
Validation based protocol
All (opt1), (opt2), (opt3) and (opt4) above.

8.DBMS periodically suspends all processing and synchronizes its files and journals through the use of

Checkpoint facility
Backup facility
Recovery manager
Database change log
Shadow paging.

9.A type of query that is placed within a WHERE or HAVING clause of another query is called

Master query

10.Which of the following technique is an alternative to log based recovery?

Check points
Page based
Recovery with current transactions
Shadow paging.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha