UNIT IV Normalization

UNIT IV Normalization

University

20 Qs

quiz-placeholder

Similar activities

Data Modeling - Revision

Data Modeling - Revision

University

15 Qs

Database-Normalisation

Database-Normalisation

9th Grade - University

20 Qs

Database

Database

12th Grade - University

20 Qs

DBTHON-23 Round-1

DBTHON-23 Round-1

University

20 Qs

Database Design Quiz Week 4

Database Design Quiz Week 4

University

15 Qs

ORACLE_JR_SERIES_1

ORACLE_JR_SERIES_1

University

25 Qs

XML BASICS QUIZ

XML BASICS QUIZ

University

15 Qs

Software Engineering-Requirements Analysis

Software Engineering-Requirements Analysis

University

15 Qs

UNIT IV Normalization

UNIT IV Normalization

Assessment

Quiz

Computers

University

Hard

Created by

Gincy Abraham

Used 36+ times

FREE Resource

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Normalisation is:

Removing all necessary data from a database

Organising a database to remove repeated entries and increase the accuracy of the data

Putting fields from different tables into one big database

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is an atomic field?

A field that contains multiple items of data

A field that is repeated

A field that contains only one item of data

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a foreign key?

A unique identifier in a database

A primary key of one table that appears in another table

A field that should not be in a table and needs removing

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A table in ____ contains no transitive dependencies.

1NF

2NF

3NF

none of the above

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When is a table is said to be 3NF

Normalization improves performance by reducing redundancy.

If and only if it is in 2NF and every non key attribute is Non-transitively dependent on the primary key

It involves introduction of redundancy in data

None of the above

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Identify the types of Data Anomalies:

Add, Delete and Save anomalies

Insert, Add and Save anomalies

Update, Save and Insert anomalies

Insert, Delete and Update anomalies

7.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which is the best example of a Primary Key?

Price

Name

Address

IC No

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?