Database Management Questions & Answers: part5



Software Programming : Database Management QUESTIONS AND ANSWERS :: part5 : 1 to 5

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

1.Which of the following is correct?

Function dependencies are not associated with relations; they are based on the semantics of information that we are dealing with
If a relation has no redundant information its attributes must not have any function dependencies
Functional dependencies may be determined if we are given several instances of a relation
The FDs that hold for attributes of a relation need not be satisfied at all times
BCNF is a fourth normal form.

2.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 B
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.

3.Which of the following is not correct? #62.Which of the following is not correct?

Each entity must include some descriptive information
If an object only requires an identifier, it should be classified as an attribute
Each multivalued attribute should be classified as an entity even if it does not have any descriptive information
The procedure of identifying entities and attaching attributes always leads to a unique solution
Every entity is a collection of attributes.

4.Which of the following is a classical approach to database design?

Top-down approach
Left-side approach
Right-side approach
Backwards approach
Middleware.

5.A ________ attribute is an attribute that can be further subdivided to yield additional attributes.

Composite
Simple
Single-valued
Multi-valued
Derived.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Too many of us are not living our dreams because we are living our fears.- Les Brown