Search Header Logo

PRELIM PART 2

Authored by Bryan Cajurao

English

University

Used 1+ times

PRELIM PART 2
AI

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

5 mins • 2 pts

What is the main purpose of normalization in a database?

Increase data redundancy

Organize data into multiple related tables

Slow down data retrieval

Delete all data

2.

MULTIPLE CHOICE QUESTION

5 mins • 2 pts

What is data redundancy?

The repetition of similar data at multiple places

A way to speed up data retrieval

A technique of organizing data

A method to secure data

3.

MULTIPLE CHOICE QUESTION

5 mins • 2 pts

Which of the following is not a data redundancy issue/anomaly?

Data Integrity anomaly

Update/Modification anomaly

Deletion anomaly

Insertion anomaly

4.

MULTIPLE CHOICE QUESTION

5 mins • 2 pts

What is an Insertion Anomaly in a database?

Changing a particular data

Deleting pieces of information

Repeating data for every new row

Inserting data into the wrong table

5.

MULTIPLE CHOICE QUESTION

5 mins • 2 pts

What is the first step in the normalization process?

Ensuring data is easily extended and retrieved

Creating multiple unrelated tables

Increasing data redundancy

Deleting all data

6.

MULTIPLE CHOICE QUESTION

5 mins • 2 pts

What is the basic requirement for a database to be in the 1st Normal Form (1NF)?

Each column should contain multiple values

Each column should contain atomic values

Each column should have a unique name

Data order in the table matters

7.

MULTIPLE CHOICE QUESTION

5 mins • 2 pts

What is the purpose of the 2nd Normal Form (2NF) in database normalization?

Ensure data is easily extended

Remove partial dependency

Allow data to be stored in any order

Increase data redundancy

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?