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.

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

01

DBMS Basics

02

Data Models

03

The Entity Relationship Approach

04

Relational Databases

05

Data Storage and Querying

06

Relational Algebra

07

Storage and File Structures

08

Indexing and Hashing

09

Transactions

10

Concurrency Control

11

Recovery System

12

Distributed Databases

13

SQL

14

Data Warehousing and Data Mining

15

RDBMS

16

Advanced SQL

17

SQL Queries,Constraints and Triggers

Q61.

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

full functional dependency

partial dependency

prime functional dependency

transitive dependency

Discuss

Answer: (a).full functional dependency

Q62.

The normal form which only includes indivisible values or single atomic values is classified as

third normal form

first normal form

second normal form

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

fourth normal form

third normal form

first normal form

second normal form

Discuss

Answer: (d).second normal form

Q64.

In the tuples, the interpretation of the values of the attribute is considered as

commands of relation

clauses of relation

schemas of relation

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

closure rule

reflexive rule

referential rule

inferential rule

Discuss

Answer: (b).reflexive rule

Q66.

The rule that always generate true dependencies is called

referential rule

inferential rule

closure rule

reflexive rule

Discuss

Answer: (d).reflexive rule

Q67.

In the __________ normal form, a composite attribute is converted to individual attributes.

First

Second

Third

Fourth

Discuss

Answer: (a).First

Q68.

A table on the many side of a one to many or many to many relationship must:

Be in Second Normal Form (2NF)

Be in Third Normal Form (3NF)

Have a single attribute key

Have a composite key

Discuss

Answer: (d).Have a composite key

Q69.

Tables in second normal form (2NF):

Eliminate all hidden dependencies

Eliminate the possibility of a insertion anomalies

Have a composite key

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?

BCNF is stricter than 3 NF

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

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

Any relation with two attributes is BCNF

Discuss

Answer: (c).Loss less, dependency – preserving decomposition into BCNF is always possible

Page 7 of 12

Welcome to the Normalization MCQs Page

Normalization MCQs | Page 7 of 12

Explore more Topics under DBMS

DBMS Basics

Data Models

The Entity Relationship Approach

Relational Databases

Data Storage and Querying

Relational Algebra

Storage and File Structures

Indexing and Hashing

Transactions

Concurrency Control

Recovery System

Distributed Databases

SQL

Data Warehousing and Data Mining

RDBMS

Advanced SQL

SQL Queries,Constraints and Triggers

Suggested Topics

Software Engineering

Computer Architecture

SQL Server

Management Information Systems

Big Data Computing

Wireless and Mobile Communications

Web Technologies

Object Oriented Programming

Visual Basic