Database Management Questions & Answers: part4



Software Programming : Database Management QUESTIONS AND ANSWERS :: part4 : 11 to 15

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

11.A table is in the Fourth Normal Form (4NF) if

All attributes must be dependent on the primary key, and must be dependent on each other
All attributes must be dependent on the primary key, but must be independent of each other
No row can contain two or more multivalued facts about an entity
A and C
B and C.

12.A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in

1NF
2NF
3NF
4NF
BCNF.

13._______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

Serializability
Atomicity
Isolation
Time stamping
Durability.

14.Which of the following is not true about B+ trees?

B+ tree index takes the form of balanced tree
Performance of B+ tree degrades as the file grows
Look-up in B+ tree is straightforward and efficient
Insertion and deletion in B+ tree is complicated but efficient
None of the above.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
If your ship doesn’t come in, swim out to meet it!-Jonathan Winters