PHYSICAL DATABASE DESIGN QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

RAID-1

RAID-0

RAID-2

RAID-3

TRUE ANSWER : ?
YOUR ANSWER : ?

The primary goal of physical database design is data processing efficiency.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an advantage of partitioning?

Complexity

Extra space

Security

Inconsistent access speed

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Moderately fast

Very fast

Impractical

Slow

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?

CHAR

NUMBER

LONG

VARCHAR2

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are integrity controls that a DBMS may support?

All of these

Limit the set of permissible values that a field may assume.

Limit the use of null values in some fields.

Assume a default value in a field unless a user enters a value for that field.

TRUE ANSWER : ?
YOUR ANSWER : ?

The three newest database architectures in use today are relational, multidimensional and hierarchical.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A rule of thumb for choosing indexes for a relational database includes which of the following?

Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.

Do not specify a unique index for the primary key of each table.

Be careful indexing attributes that have null values.

Indexes are more useful on smaller tables.

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 : ?