PHYSICAL DATABASE DESIGN QUIZ

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

NUMBER

VARCHAR2

LONG

CHAR

TRUE ANSWER : ?
YOUR ANSWER : ?

A field represents each component of a composite attribute.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an advantage of partitioning?

Security

Complexity

Inconsistent access speed

Extra space

TRUE ANSWER : ?
YOUR ANSWER : ?

The fastest read/write time and most efficient data storage of any disk array type is:

RAID-2

RAID-0

RAID-1

RAID-3

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Very fast

Slow

Moderately fast

Impractical

TRUE ANSWER : ?
YOUR ANSWER : ?

An extent is a contiguous section of disk storage space.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Selecting a data type involves which of the following?

Represent most values

All of these

Improve data integrity

Maximize storage space

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 not a factor to consider when switching from small to large block size?

Block contention

Random row access speed

The number of columns

The length of all of the fields in a table row

TRUE ANSWER : ?
YOUR ANSWER : ?

↑