quiz 5

Question 1

Which of the following is the normal form that removes all repeating groups and arrays?

Answer 1

First normal form

Question 2

Which of the following is the term for an anomaly in which removing data unintentionally causes the loss of other data?

Answer 2

Deletion anomaly

Question 3

An insertion anomaly occurs:

Answer 3

When you cannot enter data because other data is required

Question 4

When should you denormalize a database?

Answer 4

When performance is an issue and there is no other way to achieve the performance goals

Question 5

What are the risks of denormalizing a database?

Answer 5

You open the database up to the anomalies and errors normalization was meant to fix

Question 6

Which of the following best defines the term normalization?

Answer 6

The process of removing anomalies and redundancies from database design

Question 7

Which of the following is the normal form that removes all transient dependencies?

Answer 7

Third Normal Form

Question 8

An deletion anomaly occurs:

Answer 8

When removing data accidentally causes the loss of other data

Question 9

Which of the following is the best definition for a functional dependency?

Answer 9

A set of related attributes that form a sub theme in the entity

Question 10

Which term best describes the process of removing anomalies and redundancies from a database?

Answer 10

Normalization