Normalisation
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
Debbie Keith
Used 48+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
1.Which of the following is TRUE about normalisation?
It is the process of dividing larger tables into smaller interlinked tables.
Increases data redundancy.
It is the process of dividing larger tables into smaller independent tables.
It is the process of removing duplicate entries in a table.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In which stage of normalisation are the grouped attributes converted to individual attributes?
1st
2nd
3rd
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A table in 1NF and with ……………….. is automatically in second Normal Form.
Composite primary key
Single primary key
Multiple foreign keys
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT necessarily an attribute of a table in 2nd Normal Form?
No partial dependencies
No non-key dependencies
No repeated attributes
No grouped attributes
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What type of entity relationships always require a link table?
One-to-one
One-to-many
Many-to-many
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT necessarily an attribute of a table in 1st Normal Form?
No partial dependencies
No non-key dependencies
No repeated attributes
Both A and B
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the main motive of normalisation?
Join many smaller tables
Reduce data redundancy while merging smaller tables
Creating a larger table with all entities
None of the above
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
13 questions
IT-sikkerhed
Quiz
•
11th - 12th Grade
14 questions
KT HKI TIN 4
Quiz
•
3rd Grade - University
15 questions
SIMKOM
Quiz
•
12th Grade - Professi...
13 questions
Stepwise Refinement
Quiz
•
11th - 12th Grade
10 questions
BTEC National ICT U2 - Database Theory Lesson 1-3
Quiz
•
12th Grade
10 questions
Binary Logic
Quiz
•
8th - 12th Grade
15 questions
REMIDI SUBNETTING IPV4
Quiz
•
12th Grade
12 questions
2ND QUARTER REVIEW 2
Quiz
•
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
