Search Header Logo

Midterm Quiz2 - Information Management

Authored by Marilou Bartolome

Computers

12th Grade

Used 1+ times

Midterm Quiz2 - Information Management
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is an unnormalized data?

Data with redundant data

Data with only one table

Data with no anomalies

Data with no primary key

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main objective of normalization?

To increase data redundancy

To eliminate data anomalies

To store data in multiple tables

To have nonprime attributes independent of the primary key

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which normal form ensures that each table represents a single subject?

Boyce-Codd normal form

First normal form

Second normal form

Third normal form

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the highest level of normalization considered necessary for most applications?

First normal form

Second normal form

Third normal form

Fourth normal form

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the example of an unnormalized table provided in the text?

STU_NUM STU_NAME

ADV_ID SUBJ_CODE STU_NUM

ADV_ID ADV_NAME

ADV_NAME SUBJ_CODE SUBJECT STU_NUM STU_NAME

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which normal form ensures that there are no non-key attributes determined by another non-key attribute?

Boyce-Codd normal form

Third normal form

Second normal form

First normal form

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the reference book mentioned in the text for database systems?

Introduction to Programming

Fundamentals of database systems

Database systems: design, implementation, and management

Data Structures and Algorithms

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?