DB2 - 1

Question 1

To satisfy First normal form, each column of a table must have a single value.

FALSE
TRUE

Answer 1

TRUE

Question 2

To satisfy Second Normal we don’t need to be in compliance to first normal form

FALSE
TRUE

Answer 2

FALSE

Question 3

What is one goal of the normalization process?

Eliminating redundant data
Setting up a sequential process
Creating dummy records to handle parameters
Providing supplementary redundant linkages

Answer 3

Eliminating redundant data

Question 4

DB2 is not a relational database.

TRUE
FALSE

Answer 4

FALSE

Question 5

A primary key uniquely identifies a row.

FALSE
TRUE

Answer 5

TRUE

Question 6

DB2 automatically guarantees the integrity of data by enforcing

Locking strategies
Fire and forget
Redundant array striping
Non local goto resolution

Answer 6

Locking strategies

Question 7

Pick three types of data integrity

Entity Integrity
Absolute Integrity
Domain Integrity
Referential Integrity

Answer 7

Entity Integrity,
Domain Integrity,
Referential Integrity

Question 8

The horizontal entry in a database is a column.

True or False?

True
False

Answer 8

False

Question 9

One way Domain integrity is enforced is by using Default Values.

True or False?

TRUE
FALSE

Answer 9

TRUE