PHYSICAL DATABASE DESIGN QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A secondary key is which of the following?

Useful for denormalization decisions

Determines the tablespace required

Primary key

Nonunique key

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

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

False

True

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 one relation.

All fields are stored in two relations.

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

The length of all of the fields in a table row

Random row access speed

TRUE ANSWER : ?
YOUR ANSWER : ?

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

RAID-3

RAID-0

RAID-2

RAID-1

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

VARCHAR2

NUMBER

CHAR

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑