FREE ADC Database Management & Normalization Questions and Answers

Question 1

What is the primary purpose of database normalization?

Accepted Answer

To eliminate data redundancy.

Answer

To speed up all queries.

Answer

To simplify user interfaces.

Answer

To add more fields to a table.

Question 2

What does the First Normal Form (1NF) require?

Accepted Answer

Each column contains only atomic values.

Answer

All data is in uppercase.

Answer

There are foreign keys in every table.

Answer

Each row has more than one primary key.

Question 3

Which key uniquely identifies a record in a table?

Accepted Answer

Primary key

Answer

Foreign key

Answer

Composite key

Answer

Candidate key

Question 4

What is a foreign key used for?

Accepted Answer

To reference a primary key in another table.

Answer

To make queries faster.

Answer

To delete records automatically.

Answer

To create indexes.

Question 5

Which normal form removes partial dependencies?

Accepted Answer

Second Normal Form (2NF)

Answer

First Normal Form (1NF)

Answer

Third Normal Form (3NF)

Answer

Boyce-Codd Normal Form (BCNF)

Question 6

Which statement is true about denormalization?

Accepted Answer

It can improve read performance by reducing joins.

Answer

It eliminates all indexes.

Answer

It is mandatory for database design.

Answer

It removes all data types.

Question 7

What is a composite key?

Accepted Answer

A combination of two or more columns to form a unique key.

Answer

A key for security encryption.

Answer

A temporary key for sorting.

Answer

A key made from numbers only.

Question 8

What happens if a table lacks a primary key?

Accepted Answer

It may contain duplicate records.

Answer

It runs faster queries.

Answer

It creates automatic indexes.

Answer

It enforces stronger security.

Question 9

Which command is used to define a primary key in SQL?

Accepted Answer

PRIMARY KEY

Answer

FOREIGN KEY

Answer

DEFAULT

Answer

UNIQUE INDEX