Normalisation
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
Debbie Keith
Used 47+ 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
Create a free account and access millions of resources
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
15 questions
عمارة الحاسب
Quiz
•
5th - 12th Grade
10 questions
ASJ Quiz Kelas XII
Quiz
•
12th Grade
11 questions
Test evaluation word SP3S1
Quiz
•
12th Grade
11 questions
Microsoft Word Office
Quiz
•
10th Grade - University
10 questions
JavaScript 3 baco med
Quiz
•
12th Grade
10 questions
BTEC National ICT U2 - Microsoft Access
Quiz
•
12th Grade
10 questions
BTEC National U2 - Testing Tables (Paper - Part A)
Quiz
•
12th Grade
10 questions
DMI - Ke 2
Quiz
•
12th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
15 questions
Christmas Song Emoji Pictionary
Quiz
•
7th - 12th Grade
20 questions
Christmas Movies
Quiz
•
1st - 12th Grade
55 questions
CHS Holiday Trivia
Quiz
•
12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
29 questions
christmas facts
Lesson
•
5th - 12th Grade
20 questions
Christmas Trivia
Quiz
•
5th - 12th Grade
20 questions
Stages of Meiosis
Quiz
•
9th - 12th Grade
