DBMS-Function Dependency and Decomposition Questions and Answers
DBMS Function Dependency and Decomposition questions with answers focus on understanding the relationship between attributes in a relational database. Functional dependency plays a crucial role in normalization, ensuring data consistency and reducing redundancy. Practicing aptitude questions and answers with explanations on this topic helps you strengthen your DBMS fundamentals. These aptitude test practice questions are commonly asked in competitive exams like GATE and placement tests by TCS, Wipro, and Infosys. Learning through solved DBMS questions with solutions PDF enhances your conceptual clarity for both academic and job interviews.
DBMS-Function Dependency and Decomposition
Showing 10 of
14 questions
1. Functional dependeny allows the database designer to express facts about the enterprise that the designer is modelling with the enterprise database.
- TRUE
- FALSE
2. A functional dependency is a many-to-many relationship between two sets of attributes X and Y of a given table T.
- TRUE
- FALSE
3. The term full functional dependency (FFD) is used to indicate the maxmimum set of attributes in a determinant of a functional dependency (FD).
- TRUE
- FALSE
4. A functional dependency in the set is redundant if it can be derived from the other functional dependencies in the set.
- TRUE
- FALSE
5. A closure of a set (also called complete sets) of functional dependency defines all the FDs that can be derived from a given set of FDs.
- TRUE
- FALSE
6. A functional decomposition is the process of breaking down the functions of an organization into progressively greater (finer and finer) levels of detail.
- TRUE
- FALSE
8. The dependencies are preserved because each dependency in F represents a constraint on the database.
- TRUE
- FALSE
9. If decomposition is not dependency-preserving, some dependency is lost in the decomposition.
- TRUE
- FALSE
10. A functional dependency is a
- many-to-many relationship between two sets of attributes
- one-to-one relationship between two sets of attributes.
- many-to-one relationship between two sets of attributes
- none of these.