Database Normalization Quiz
Authored by Rabnawaz Shaikh
Information Technology (IT)
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main purpose of normalization?
Speed up transactions
Create more tables
Eliminate data redundancy
Improve physical design
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is true about a surrogate key?
It has no business meaning
It must be unique and meaningful
It is a combination of foreign keys
It cannot be indexed
3.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
First Normal Form (1NF) requires:
Unique rows
Atomic values in columns
Foreign keys
Functional dependencies
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A table is in 2NF if it is in 1NF and:
All attributes are atomic
No partial dependency exists
Transitive dependency exists
There is a surrogate key
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which dependency is removed in 3NF?
Functional dependency
Partial dependency
Transitive dependency
All of the above
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is not a type of normal form?
1NF
2NF
5DF
BCNF
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the need for denormalization?
To normalize data further
To improve read performance
To reduce anomalies
To enforce data integrity
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
