Search Header Logo

Quiz on Database Normalization

Authored by Rhayz Bautista

Computers

12th Grade

Used 4+ times

Quiz on Database Normalization
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

What is the main objective of normalization?

To increase data redundancy

To eliminate data anomalies

To create multiple subjects in one table

To store data in multiple tables

2.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

Which normal form requires that there are no repeating groups?

First Normal Form (1NF)

Boyce-Codd Normal Form (BCNF)

Second Normal Form (2NF)

Third Normal Form (3NF)

3.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

In which normal form are all columns dependent on the table's primary key?

Second Normal Form (2NF)

First Normal Form (1NF)

Fourth Normal Form (4NF)

Third Normal Form (3NF)

4.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

What is a characteristic of the Third Normal Form (3NF)?

All columns must be unique

Every determinant is a candidate key

No non-key attributes determined by another non-key attribute

No independent multivalued dependencies

5.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

Which of the following is NOT a characteristic of normalization?

All nonprime attributes depend on the primary key

Each row/column intersection contains multiple values

Each table represents a single subject

No data item is unnecessarily stored in more than one table

6.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

What does BCNF stand for?

Boyce-Codd Normal Form

Basic Candidate Normal Form

Binary Candidate Normal Form

Base Column Normal Form

7.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

Which normal form is considered the highest level necessary for most applications?

Third Normal Form (3NF)

Second Normal Form (2NF)

Fourth Normal Form (4NF)

First Normal Form (1NF)

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?