Database Normalization Quiz

Database Normalization Quiz

11th Grade

13 Qs

quiz-placeholder

Similar activities

Computer Lab Rules

Computer Lab Rules

9th - 12th Grade

13 Qs

Impresa e siti web

Impresa e siti web

8th - 12th Grade

10 Qs

Variables and Functions

Variables and Functions

KG - University

10 Qs

Settings, plugins and themes (wordpress)

Settings, plugins and themes (wordpress)

9th - 12th Grade

10 Qs

ICT111_EXAM_ROUND2

ICT111_EXAM_ROUND2

11th Grade

10 Qs

Security and Ethics

Security and Ethics

9th - 12th Grade

17 Qs

ICT and Retail Industry

ICT and Retail Industry

8th - 12th Grade

13 Qs

EmTech Q1 Post Test 3

EmTech Q1 Post Test 3

11th Grade

10 Qs

Database Normalization Quiz

Database Normalization Quiz

Assessment

Quiz

Computers

11th Grade

Practice Problem

Easy

Created by

Martin Corbishley

Used 2+ 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 a key made up of more than one attribute called?

Composite key

Foreign key

Primary key

Candidate key

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a property of a relation in Third Normal Form (3NF)?

It depends on the key.

It depends on the whole key.

It depends on nothing but the key.

It must have a composite key.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of normalizing a database?

To make the database more visually appealing.

To ensure the database is compatible with all operating systems.

To prevent unnecessary duplication of data and maintain data integrity.

To reduce the complexity of SQL queries.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A database table contains repeating attributes. Which normal form does it violate?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Fourth Normal Form (4NF)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How are the tables Student and StudentSubject related in a database?

Through a common attribute name.

Using a linking table.

Using a primary key in Student and a foreign key in StudentSubject.

They are not related.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does 1NF state about attributes within a table?

They must be numerical.

They can be partially dependent on the primary key.

They must be atomic and contain no repeating groups.

They must be dependent on the whole primary key.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A table is in 2NF if it fulfills which conditions?

It is in 3NF and contains no non-key dependencies.

It contains no repeating attributes or groups of attributes.

It is in 1NF and contains no partial dependencies.

It has a composite primary key.

Access all questions and much more by creating a free account

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?