Database Management Questions & Answers: part17



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

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

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

12.When converting one (1) to many (N) binary relationship into tables, the recommended solution is usually

One big table with all attributes from both entities included
Foreign key added on the Child (many side) referencing the parent
Foreign key added on the Parent (one side) referencing the child
Foreign key added on both sides (both tables)
Primary Key is added on one side.

13.A property or characteristic of an entity type that is of interest to the organization is called an

Attribute
Coexisting entity
Relationship
Cross-function
Weak entity.

14.What are the correct features of a distributed database? #270.What are the correct features of a distributed database?

Is always connected to the internet
Always requires more than three machines
Users see the data in one global schema.
Have to specify the physical location of the data when an update is done
All DBMS have to be homogenous.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Identify your problems but give your power and energy to solutions- Tony Robbins