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

Explore more Topics under DBMS

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

a.

Denormalization

b.

Redundant optimization

c.

Optimization

d.

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 ?

a.

Dept name, year->size

b.

Year->size

c.

Dept name->size

d.

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

a.

Fourth NF

b.

BCNF

c.

Third NF

d.

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.

a.

Instance

b.

Snapshot

c.

Both Instance and Snapshot

d.

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.

a.

Cross-tabs

b.

Snapshot

c.

Both Cross-tabs and Snapshot

d.

All of the mentioned

Discuss
Answer: (a).Cross-tabs
Q106.
Which normal form is considered adequate for normal relational database design?

a.

2NF

b.

5NF

c.

4NF

d.

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

a.

dependency preserving and lossless join

b.

lossless join but not dependency preserving

c.

dependency preserving but not lossless join

d.

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

a.

Zero

b.

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

c.

Proportional to the size of F+

d.

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

a.

1NF

b.

2NF

c.

3NF

d.

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

a.

In second normal form but not in third normal form

b.

In third normal form but not in BCNF

c.

In BCNF

d.

None of the mentioned

Discuss
Answer: (d).None of the mentioned
Page 11 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...

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Operating System

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

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

Computer Graphics

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

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....