
Normalization in DBMS Quiz

Quiz
•
Computers
•
12th Grade
•
Hard
DR MURTHY
Used 5+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary goal of normalization in DBMS?
Minimize redundancy and anomalies
Increase data redundancy
Improve query execution speed
Convert all relations to a single table
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following anomalies does normalization help to eliminate?
Insertion anomaly
Deletion anomaly
Update anomaly
All of the above
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the process of dividing large tables into smaller tables while maintaining data consistency called?
Denormalization
Indexing
Normalization
Partitioning
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following best describes a functional dependency?
A relationship between two tables
A constraint between two attributes
A method to index data
A foreign key constraint
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is not a normal form in DBMS?
1NF
3.5NF
BCNF
5NF
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A table is in First Normal Form (1NF) if it does not contain:
Repeating groups or multi-valued attributes
Foreign keys
Primary keys
Derived attributes
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following tables violates 1NF?
A table where each attribute contains atomic values
A table with composite primary keys
A table with a column storing multiple email addresses per row
A table with foreign key constraints
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
Microsoft Excel - Rows, Columns & Cells

Quiz
•
9th - 12th Grade
16 questions
A2 Computer Science 4.10 Databases

Quiz
•
10th - 12th Grade
20 questions
1.3.1 Databases & SQL

Quiz
•
12th Grade
20 questions
Access Quiz

Quiz
•
9th - 12th Grade
20 questions
CompTIA ITF+ - Database Vocabulary

Quiz
•
9th - 12th Grade
20 questions
SLR23 | Databases

Quiz
•
12th Grade
20 questions
Database Glossary

Quiz
•
12th Grade
20 questions
Semester 1 - Microsoft Word

Quiz
•
9th - 12th Grade
Popular Resources on Wayground
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns

Quiz
•
3rd Grade
10 questions
Appointment Passes Review

Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
11 questions
All about me

Quiz
•
Professional Development
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
Grammar Review

Quiz
•
6th - 9th Grade