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

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

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?

VARCHAR2

NUMBER

CHAR

LONG

TRUE ANSWER : ?
YOUR ANSWER : ?

The blocking factor is:

a group of fields stored in adjacent memory.

attributes grouped together by the same secondary key.

the number of physical records per page.

attributes grouped together by the same primary key.

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-3

RAID-1

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A bitmap index is an index on columns from two or more tables that come from the same domain of values.

False

True

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

The number of columns

Random row access speed

TRUE ANSWER : ?
YOUR ANSWER : ?

It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑