
Year 12 Database Design Quiz
Authored by peter allsop
Information Technology (IT)
12th Grade
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main purpose of database normalisation?
To increase data redundancy
To reduce data redundancy and improve data integrity
To make databases larger
To decrease database performance
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which normal form eliminates repeating groups in a database table?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In an Entity-Relationship Diagram (ERD), what does a diamond shape represent?
Entity
Attribute
Relationship
Primary Key
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a primary key in a database?
A field that can have duplicate values
A field that uniquely identifies each record in a table
A field that is always left empty
A field that stores foreign data
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is an example of a foreign key?
A unique identifier for a table
A field in a table that is a primary key in another table
A field that contains only numeric data
A field that is always null
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is data redundancy?
The process of normalising data
The unnecessary duplication of data in a database
The use of primary keys
The use of foreign keys
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL command is used to retrieve data from a database?
INSERT
DELETE
SELECT
UPDATE
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
14 questions
Dispositivos de Entrada/Salida
Quiz
•
9th - 12th Grade
15 questions
Understanding Loops in C Programming
Quiz
•
1st Grade - University
10 questions
MID26022025
Quiz
•
12th Grade
15 questions
soal semester kelas 9
Quiz
•
9th - 12th Grade
10 questions
VPN - Kons 1 - XII TKJ
Quiz
•
12th Grade
10 questions
Quiz Produktif
Quiz
•
12th Grade
20 questions
BAB 5 ANALISIS DATA B. Membaca dan Menafsirkan Data KELAS 5
Quiz
•
5th Grade - University
15 questions
Testează-ți cunoștințele despre numerație
Quiz
•
11th Grade - University
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
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
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade
11 questions
Valentine's Day Trivia
Quiz
•
8th - 12th Grade
10 questions
Factor Quadratic Expressions with Various Coefficients
Quiz
•
9th - 12th Grade
18 questions
Success Strategies
Quiz
•
9th - 12th Grade
10 questions
Valentine's Day Trivia
Quiz
•
9th - 12th Grade