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
11. Decomposition helps in eliminating some of the problems of bad design such as
- redundancy
- inconsistencies
- anomalies
- all of these
12. The word loss in lossless refers to the
- loss of information.
- loss of attributes
- loss of relations
- none of these.
13. The dependency preservation decomposition is a property of decomposed relational database schema D in which each functional dependency D----->Y specified in F
- appeared directly in one of the relation schemas R1 in the deomposed D.
- could be inferred from dependencies that appear in some Ri.
- both (a) and (b)
- none of these.
14. The set of attributes X will be fully functionally dependent on the set of attributes Y if the following conditions are satisfied:
- X is functionally dependent on Y.
- X is not functionally dependent on any subset of Y.
- both (a) and (b)
- none of these