
DBMS Normalization Quiz
Authored by David Hunt
Computers
12th Grade

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main purpose of normalization in SQL?
To decrease data consistency
To create larger tables
To eliminate redundant data and ensure logical data storage
To increase data redundancy
Answer explanation
To eliminate redundant data and ensure logical data storage
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Who proposed the theory of normalization?
Raymond F. Boyce
Edgar Codd
Marcus Allen
Donald Knuth
Answer explanation
Edgar Codd proposed the theory of normalization.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which normal form ensures that each column contains atomic values and each record is unique?
1NF
2NF
BCNF
3NF
Answer explanation
1NF ensures that each column contains atomic values and each record is unique.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a primary key?
A key that uniquely identifies a database record
A key that can be null
A key that can have duplicate values
A key that is used to connect tables
Answer explanation
A primary key is a key that uniquely identifies a database record, making it a crucial element in ensuring data integrity and uniqueness.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which normal form eliminates transitive dependency?
3NF
4NF
2NF
1NF
Answer explanation
3NF eliminates transitive dependency by ensuring that every non-prime attribute is non-transitively dependent on every candidate key.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a composite key?
A key that is used to connect tables
A key composed of multiple columns used to identify a record uniquely
A key that can be null
A key that is always unique
Answer explanation
A composite key is a key composed of multiple columns used to identify a record uniquely, making it different from a single-column key.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a foreign key?
A key that uniquely identifies a database record
A key that references the primary key of another table
A key that can be null
A key that is always unique
Answer explanation
A foreign key is a key that references the primary key of another table, establishing a relationship between the two tables.
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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
XI_осн_веб_кон
Quiz
•
9th - 12th Grade
10 questions
1° Primaria Computación
Quiz
•
KG - 12th Grade
10 questions
Bài tập Tin học lớp 4
Quiz
•
1st - 12th Grade
13 questions
Five Nights At Freddy's: Security Breach Quiz
Quiz
•
KG - Professional Dev...
10 questions
Programacion Orientada a Objetos
Quiz
•
12th Grade - University
9 questions
Test Excel
Quiz
•
10th - 12th Grade
11 questions
CAPÍTULO 1 NETWORKING ESSENTIALS
Quiz
•
1st - 12th Grade
12 questions
Wee Word Intro
Quiz
•
7th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade