PHYSICAL DATABASE DESIGN QUIZ

Selecting a data type involves which of the following?

Improve data integrity

Represent most values

Maximize storage space

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

A field represents each component of a composite attribute.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Sequential retrieval on a primary key for sequential file storage has which of the following features?

Impractical

Slow

Very fast

Moderately fast

TRUE ANSWER : ?
YOUR ANSWER : ?

Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an advantage of partitioning?

Complexity

Security

Inconsistent access speed

Extra space

TRUE ANSWER : ?
YOUR ANSWER : ?

Some advantages of partitioning include: efficiency, security, and load balancing.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not a factor to consider when switching from small to large block size?

The length of all of the fields in a table row

Block contention

Random row access speed

The number of columns

TRUE ANSWER : ?
YOUR ANSWER : ?

If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?

All fields are stored in four relations.

All fields are stored in two relations.

All fields are stored in one relation.

All fields are stored in three relations.

TRUE ANSWER : ?
YOUR ANSWER : ?

The blocking factor is:

the number of physical records per page.

attributes grouped together by the same secondary key.

a group of fields stored in adjacent memory.

attributes grouped together by the same primary key.

TRUE ANSWER : ?
YOUR ANSWER : ?

Hashing algorithm converts a primary key value into a record address.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑