DBMS - Normalization

DBMS - Normalization

University

7 Qs

quiz-placeholder

Similar activities

COMPUTER PROGRAMMING 2- SEATWORK 2- INTRO TO OBJECT OOP

COMPUTER PROGRAMMING 2- SEATWORK 2- INTRO TO OBJECT OOP

University

10 Qs

Introduction To Programming

Introduction To Programming

University

10 Qs

ICT 3 INFORMATION ASSURANCE AND SECURITY

ICT 3 INFORMATION ASSURANCE AND SECURITY

University

10 Qs

Happiness by Harvard

Happiness by Harvard

University

10 Qs

Crytopgraphy

Crytopgraphy

9th Grade - Professional Development

10 Qs

Tutorial

Tutorial

University

9 Qs

MPB Week 7

MPB Week 7

University

10 Qs

JRB2 Quiz 4

JRB2 Quiz 4

University

10 Qs

DBMS - Normalization

DBMS - Normalization

Assessment

Quiz

Computers

University

Practice Problem

Hard

Created by

Carlin CHU

Used 6+ times

FREE Resource

AI

Enhance your content in a minute

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

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Normalization works through a series of stages called normal forms. Typically ____ stages are processed.

2

3

4

5

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1NF describes the tabular format in which all of the following are true except ____.

all the key attributes are defined

there are no repeating groups in the table

all attributes are dependent on the primary key

no attributes are dependent on the primary key

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Data redundancy produces ____.

slower lookups

robust design

efficient storage use

data integrity problems

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Normalization is a process for assigning ____ to entities.

data

files

attributes

relations

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

From a structural point of view, 2NF is better than ____.

1NF

2NF

3NF

4NF

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

____ yields better performance in simple data retrieval process.

Denormalization

Normalization

Atomization

Compression

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Dependencies based on only a part of a composite primary key are called ____ dependencies.

primary

partial

incomplete

composite

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?

Discover more resources for Computers