PHYSICAL DATABASE DESIGN QUIZ

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

Slow

Very fast

Impractical

Moderately fast

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

All fields are stored in three relations.

All fields are stored in four relations.

All fields are stored in two relations.

All fields are stored in one relation.

TRUE ANSWER : ?
YOUR ANSWER : ?

Distributing the columns of a table into several separate physical records is known as horizontal partitioning.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An extent is a contiguous section of disk storage space.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?

LONG

CHAR

VARCHAR2

NUMBER

TRUE ANSWER : ?
YOUR ANSWER : ?

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

The number of columns

Block contention

Random row access speed

The length of all of the fields in a table row

TRUE ANSWER : ?
YOUR ANSWER : ?

A pointer is a detailed coding scheme recognized by system software for representing organizational data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A field represents each component of a composite attribute.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑