Database Normalisation Quiz

Database Normalisation Quiz

11th Grade

13 Qs

quiz-placeholder

Similar activities

Disk Management and Boot Sequence Vocab

Disk Management and Boot Sequence Vocab

9th - 12th Grade

15 Qs

Quiz on Misinformation and Bias

Quiz on Misinformation and Bias

10th Grade - University

18 Qs

Windows 7 Installation

Windows 7 Installation

10th - 12th Grade

10 Qs

REVISION-Primary & Secondary Storage

REVISION-Primary & Secondary Storage

10th - 11th Grade

15 Qs

Flash 8

Flash 8

7th - 12th Grade

15 Qs

Color Theory Test Review

Color Theory Test Review

9th - 12th Grade

15 Qs

Word 2016 - Lesson 2 - Basic Editing

Word 2016 - Lesson 2 - Basic Editing

9th - 12th Grade

10 Qs

Writer - II

Writer - II

11th Grade

10 Qs

Database Normalisation Quiz

Database Normalisation Quiz

Assessment

Quiz

Computers

11th Grade

Practice Problem

Hard

Created by

Aizhan Abisheva

Used 4+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

13 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary goal of normalisation in database design?

To simplify queries

To increase data redundancy

To eliminate data anomalies

To create more tables

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does 1NF stand for?

First Normal Form

First Notable Form

First Normal Function

First Non-Functional

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a goal of the normalisation process?

Eliminating redundant data

Reducing database size

Ensuring data dependencies make sense

Increasing data storage

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a partial dependency?

When a non-key attribute depends on the primary key

When a primary key is made up of multiple attributes

When an attribute is dependent on another non-key attribute

When an attribute has no dependencies

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which normal form must a relation be in to qualify for 2NF?

1NF

3NF

BCNF

4NF

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main characteristic of 3NF?

No repeating groups

No partial dependencies

No transitive dependencies

All attributes are dependent on the primary key

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What happens to attributes that are partially dependent on a composite primary key?

They are kept in the same relation

They are removed to a new relation

They are ignored

They are merged with the primary key

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?