adplus-dvertising

Welcome to the Normalization MCQs Page

Dive deep into the fascinating world of Normalization with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Normalization, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of Normalization, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

frame-decoration

Check out the MCQs below to embark on an enriching journey through Normalization. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Normalization. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Normalization MCQs | Page 8 of 12

Q71.
Functional Dependencies are the types of constraints that are based on______
Discuss
Answer: (a).Key
Q72.
Which is a bottom-up approach to database design that design by examining the relationship between attributes:
Discuss
Answer: (c).Normalization
Q73.
Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:
Discuss
Answer: (c).3NF
Q74.
Which forms has a relation that possesses data about an individual entity:
Discuss
Answer: (c).4NF
Q75.
Which forms are based on the concept of functional dependency:
Discuss
Answer: (c).3NF
Q76.
Empdt1(empcode, name, street, city, state,pincode).

For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
Discuss
Answer: (b).2 NF and hence also in 1 NF
Q77.
We can use the following three rules to find logically implied functional dependencies. This collection of rules is called
Discuss
Answer: (b).Armstrong’s axioms
Q78.
Which of the following is not a Armstrong’s Axiom ?
Discuss
Answer: (c).Pseudotransitivity rule
Q79.
The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into

employee1 (ID, name)
employee2 (name, street, city, salary)

This type of decomposition is called
Discuss
Answer: (d).None of the mentioned
Q80.
Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into

instructor (ID, name, dept name, salary)
department (dept name, building, budget)

This comes under
Discuss
Answer: (d).Both a and b

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!