Database - Normalization for Relational Databases
- Option : A
- Explanation : Sets of functional dependencies may have redundant dependencies that can be inferred from the other functional dependencies.
A canonical cover of F is a “minimal” set of functional dependencies equivalent to F, having no redundant dependencies or redundant parts of dependencies.
As we can infer all FD's from option A, so A is the right answer.
You must be logged in to post a comment.
7. Which normal form is considered adequate for relational database design?
- Option : B
- Explanation :
You must be logged in to post a comment.
You must be logged in to post a comment.
8. A functional dependency of the form x —> y is trivial if
- Option : A
- Explanation :
You must be logged in to post a comment.
You must be logged in to post a comment.
9. If every non-key attribute is a functionally dependent primary key, then the relation will be in
- Option : B
- Explanation :
You must be logged in to post a comment.
You must be logged in to post a comment.
10. If a relation is in BCNF, then it is also in
- Option : D
- Explanation :
You must be logged in to post a comment.
You must be logged in to post a comment.
- Normalisation in DBMS Questions can be used by any candidate who is preparing for UGC NET Computer Science
- This Normalisation MCQ section will help you test your analytical skills in a tricky method, thereby giving you an edge over other students
- Any student who wants to prepare for DOEACC A Level, DOEACC B Level, and DOEACC C level can also use these Objective Type Questions Answer.
- All candidates who have to appear for the Kendriya Vidyalaya Entrance exam can also refer to this Normalisation quiz questions with answers
- You can also get access to the Normalisation in DBMS MCQ ebook.
- Normalisation Questions can be used in the preparation of JRF, CSIR, and various other exams.
- You can also download pdf for this Normalisation multiple-choice questions Answers.
- This Normalisation in ai Multiple Choice Questions Answers section can also be used for the preparation of various competitive exams like UGC NET, GATE, PSU, IES, and many more.
- Normalisation Objective Type Questions Answer can be used to gain a credit score in various undergraduate and postgraduate courses like BSc, MSc and MCA
You must be logged in to post a comment.