Normalization in DBMS Quiz

Normalization in DBMS Quiz

12th Grade

20 Qs

quiz-placeholder

Similar activities

Access Terms

Access Terms

9th - 12th Grade

20 Qs

DBMS

DBMS

12th Grade

20 Qs

Databases

Databases

12th Grade - University

20 Qs

011_Technical Change Management-CompTIA Security+ SY0-701-1.3

011_Technical Change Management-CompTIA Security+ SY0-701-1.3

12th Grade - University

15 Qs

Advanced Excel

Advanced Excel

KG - University

20 Qs

Unit 2 - Relationships

Unit 2 - Relationships

12th Grade

20 Qs

Introduction to Databases

Introduction to Databases

12th Grade

19 Qs

Introduction to DBMS

Introduction to DBMS

11th - 12th Grade

16 Qs

Normalization in DBMS Quiz

Normalization in DBMS Quiz

Assessment

Quiz

Computers

12th Grade

Hard

Created by

DR MURTHY

Used 5+ times

FREE Resource

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary goal of normalization in DBMS?

Minimize redundancy and anomalies

Increase data redundancy

Improve query execution speed

Convert all relations to a single table

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following anomalies does normalization help to eliminate?

Insertion anomaly

Deletion anomaly

Update anomaly

All of the above

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the process of dividing large tables into smaller tables while maintaining data consistency called?

Denormalization

Indexing

Normalization

Partitioning

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following best describes a functional dependency?

A relationship between two tables

A constraint between two attributes

A method to index data

A foreign key constraint

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not a normal form in DBMS?

1NF

3.5NF

BCNF

5NF

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A table is in First Normal Form (1NF) if it does not contain:

Repeating groups or multi-valued attributes

Foreign keys

Primary keys

Derived attributes

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following tables violates 1NF?

A table where each attribute contains atomic values

A table with composite primary keys

A table with a column storing multiple email addresses per row

A table with foreign key constraints

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?