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 11 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

Q101.

Designers use which of the following to tune performance of systems to support time-critical operations?

Denormalization

Redundant optimization

Optimization

Realization

Discuss

Answer: (a).Denormalization

Q102.

In the schema (dept name, size) we have relations total inst 2007, total inst 2008 . Which dependency have lead to this relation ?

Dept name, year->size

Year->size

Dept name->size

Size->year

Discuss

Answer: (a).Dept name, year->size

Q103.

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009) .Here the only functional dependencies are from dept name to the other attributes .This relation is in

Fourth NF

BCNF

Third NF

Second NF

Discuss

Answer: (b).BCNF

Q104.

Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.

Instance

Snapshot

Both Instance and Snapshot

All of the mentioned

Discuss

Answer: (b).Snapshot

Q105.

Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.

Cross-tabs

Snapshot

Both Cross-tabs and Snapshot

All of the mentioned

Discuss

Answer: (a).Cross-tabs

Q106.

Which normal form is considered adequate for normal relational database design?

2NF

5NF

4NF

3NF

Discuss

Answer: (d).3NF

Q107.

Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is

dependency preserving and lossless join

lossless join but not dependency preserving

dependency preserving but not lossless join

not dependency preserving and not lossless join

Discuss

Answer: (d).not dependency preserving and not lossless join

Q108.

Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

Zero

More than zero but less than that of an equivalent 3NF decomposition

Proportional to the size of F+

Indeterminate

Discuss

Answer: (b).More than zero but less than that of an equivalent 3NF decomposition

Q109.

A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies:

F1->F3
F2->F4
(F1,F2)->F5

in terms of normalization, this table is in

1NF

2NF

3NF

None of the mentioned

Discuss

Answer: (a).1NF

Q110.

Consider the following functional dependencies in a database.

Date_of_Birth->Age Age->Eligibility

Name->Roll_number Roll_number->Name

Course_number->Course_name Course_number->Instructor

(Roll_number, Course_number)->Grade

The relation (Roll_number, Name, Date_of_birth, Age) is

In second normal form but not in third normal form

In third normal form but not in BCNF

In BCNF

None of the mentioned

Discuss

Answer: (d).None of the mentioned

Page 11 of 12

Welcome to the Normalization MCQs Page

Normalization MCQs | Page 11 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

Neural Networks

Python

Data Science

IT Fundamentals

MongoDB

SQL Server

Software Engineering

C# programming

Internet of Things (IoT)