wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Quiz on Normal Forms

Total questions: 35

Worksheet time: 18mins

Name
Class
Date
1.

A table is in 1NF if: It has no NULL values, It has a primary key, All attributes contain only atomic values, It has no foreign keys

a)

It has no NULL values

b)

It has a primary key

c)

All attributes contain only atomic values

d)

It has no foreign keys

2.

Which of the following violates 1NF?

a)

Storing multiple phone numbers in one column

b)

Having a primary key

c)

Having NULL values

d)

Using numeric IDs

3.

In 1NF, each cell in a table must contain:

a)

Multiple values

b)

Atomic (single) value

c)

Derived value

d)

Key value

4.

Repeating groups in a table violate which normal form?

a)

1NF

b)

2NF

c)

3NF

d)

BCNF

5.

Which of these operations helps achieve 1NF?

a)

Removing partial dependency

b)

Splitting composite fields

c)

Removing transitive dependency

d)

Adding candidate keys

6.

If a student table has a column “Subjects = {Math, Science}”, it violates:

a)

2NF

b)

3NF

c)

1NF

d)

BCNF

7.

1NF focuses on:

a)

Atomicity

b)

Dependency

c)

Transitivity

d)

Redundancy

8.

A table is in 2NF if it is in 1NF and:

a)

Has a single key

b)

Has no partial dependency

c)

Has no transitive dependency

d)

Has a foreign key

9.

Partial dependency occurs when:

a)

A non-key attribute depends on a part of a composite key

b)

A key depends on a non-key

c)

A key depends on another key

d)

Two attributes are independent

10.

2NF eliminates:

a)

Redundant data from partial dependencies

b)

Repeating groups

c)

Transitive dependencies

d)

Multivalued dependencies

11.

A relation with a single attribute key is always in:

a)

1NF

b)

2NF

c)

3NF

d)

BCNF

12.

For 2NF, the table must first satisfy:

a)

3NF

b)

BCNF

c)

1NF

d)

4NF

13.

To achieve 2NF, we remove:

a)

Transitive dependency

b)

Partial dependency

c)

Functional dependency

d)

Multivalued dependency

14.

Which normal form ensures no attribute depends only on part of a composite key?

a)

1NF

b)

2NF

c)

3NF

d)

BCNF

15.

A table is in 3NF if it is in 2NF and:

a)

Has no partial dependency

b)

Has no transitive dependency

c)

Has no multivalued dependency

d)

Has atomic values

16.

Transitive dependency means:

a)

A → B, B → C, hence A → C

b)

A → C only

c)

B depends on C

d)

All attributes depend on primary key

17.

3NF removes:

a)

Partial dependencies

b)

Multivalued dependencies

c)

Transitive dependencies

d)

Derived attributes

18.

If non-key attributes depend on other non-key attributes, it violates:

a)

2NF

b)

3NF

c)

4NF

d)

BCNF

19.

To achieve 3NF, a table must already be in:

a)

1NF

b)

2NF

c)

BCNF

d)

4NF

20.

3NF reduces which problem?

a)

Insertion, update, deletion anomalies

b)

Lossless joins

c)

Multivalued dependency

d)

Derived attributes

21.

A table where every non-prime attribute depends only on the key and not on other attributes is in:

a)

1NF

b)

2NF

c)

3NF

d)

BCNF

22.

BCNF is a stronger version of:

a)

1NF

b)

2NF

c)

3NF

d)

4NF

23.

BCNF removes anomalies that 3NF cannot handle related to:

a)

Candidate keys

b)

Foreign keys

c)

Partial dependency

d)

Transitive dependency

24.

A relation is in BCNF if:

a)

Every determinant is a candidate key

b)

It is in 2NF

c)

It has no transitive dependency

d)

It has atomic attributes

25.

BCNF may still have:

a)

Multivalued dependency

b)

Transitive dependency

c)

Partial dependency

d)

None of these

26.

BCNF handles anomalies due to:

a)

Overlapping candidate keys

b)

Non-prime attributes

c)

Foreign key constraints

d)

Multivalued attributes

27.

Every BCNF table is also:

a)

2NF

b)

3NF

c)

4NF

d)

5NF

28.

Violation of BCNF occurs when:

a)

A non-trivial functional dependency has a determinant that is not a super key

b)

There are multivalued dependencies

c)

There are partial dependencies

d)

There are transitive dependencies

29.

A relation is in 4NF if:

a)

It is in BCNF and has no multivalued dependencies

b)

It is in 3NF

c)

It has no transitive dependency

d)

It has atomic values

30.

Multivalued dependency means:

a)

One attribute determines multiple independent values of another

b)

One attribute depends on many keys

c)

Many-to-many relationship in same table

d)

None of these

31.

4NF removes:

a)

Partial dependencies

b)

Transitive dependencies

c)

Multivalued dependencies

d)

Candidate keys

32.

Which of the following is stronger than BCNF?

a)

1NF

b)

2NF

c)

4NF

d)

3NF

33.

4NF deals primarily with:

a)

Functional dependencies

b)

Multivalued dependencies

c)

Join dependencies

d)

Transitive dependencies

34.

A table with multivalued attributes can be decomposed into two tables to achieve:

a)

2NF

b)

3NF

c)

4NF

d)

BCNF

35.

To achieve 4NF, the relation must already be in:

a)

1NF

b)

3NF

c)

BCNF

d)

2NF