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 7 of 12

Explore more Topics under DBMS

Q61.
Considering the functional dependency, the one in which removal from some attributes must affect dependency is called

a.

full functional dependency

b.

partial dependency

c.

prime functional dependency

d.

transitive dependency

Discuss
Answer: (a).full functional dependency
Q62.
The normal form which only includes indivisible values or single atomic values is classified as

a.

third normal form

b.

first normal form

c.

second normal form

d.

fourth normal form

Discuss
Answer: (b).first normal form
Q63.
The concept in normalization of relations which is based on the full functional dependency is classified as

a.

fourth normal form

b.

third normal form

c.

first normal form

d.

second normal form

Discuss
Answer: (d).second normal form
Q64.
In the tuples, the interpretation of the values of the attribute is considered as

a.

commands of relation

b.

clauses of relation

c.

schemas of relation

d.

semantics of relation

Discuss
Answer: (d).semantics of relation
Q65.
The rule which states that set of attributes determines any of its subset is classified as

a.

closure rule

b.

reflexive rule

c.

referential rule

d.

inferential rule

Discuss
Answer: (b).reflexive rule
Q66.
The rule that always generate true dependencies is called

a.

referential rule

b.

inferential rule

c.

closure rule

d.

reflexive rule

Discuss
Answer: (d).reflexive rule
Q67.
In the __________ normal form, a composite attribute is converted to individual attributes.

a.

First

b.

Second

c.

Third

d.

Fourth

Discuss
Answer: (a).First
Q68.
A table on the many side of a one to many or many to many relationship must:

a.

Be in Second Normal Form (2NF)

b.

Be in Third Normal Form (3NF)

c.

Have a single attribute key

d.

Have a composite key

Discuss
Answer: (d).Have a composite key
Q69.
Tables in second normal form (2NF):

a.

Eliminate all hidden dependencies

b.

Eliminate the possibility of a insertion anomalies

c.

Have a composite key

d.

Have all non key fields depend on the whole primary key

Discuss
Answer: (a).Eliminate all hidden dependencies
Q70.
Which-one ofthe following statements about normal forms is FALSE?

a.

BCNF is stricter than 3 NF

b.

Lossless, dependency -preserving decomposition into 3 NF is always possible

c.

Loss less, dependency – preserving decomposition into BCNF is always possible

d.

Any relation with two attributes is BCNF

Discuss
Answer: (c).Loss less, dependency – preserving decomposition into BCNF is always possible
Page 7 of 12

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!

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....