Database Management Questions & Answers: part20



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

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

6.A super key that does not contain a subset of attributes that is itself a super key is called a

Candidate key
Primary key
Super key
Secondary key
Foreign key.

7.In the context of a database table, the statement "A determines B" indicates that #315.In the context of a database table, the statement "A determines B" indicates that

Knowing the value of attribute A you can not look up the value of attribute B
You do not need to know the value of attribute A in order to look up the value of attribute
Knowing the value of attribute B you can look up the value of attribute A
Knowing the value of attribute A you can look up the value of attribute B
None of the above.

8.A table that displays data redundancies yields ____________ anomalies.

Update
Insertion
Deletion
All of the above
None of the above.

9.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.

10._______ 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.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
If you are not willing to risk the usual you will have to settle for the ordinary- Jim Rohn