PHYSICAL DATABASE DESIGN QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

RAID-2

RAID-1

RAID-0

RAID-3

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.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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

All of these

Limit the use of null values in some fields.

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

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An extent is a contiguous section of disk storage space.

False

True

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.

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

LONG

CHAR

NUMBER

TRUE ANSWER : ?
YOUR ANSWER : ?

↑