PHYSICAL DATABASE DESIGN QUIZ

If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?

All fields are stored in one relation.

All fields are stored in three relations.

All fields are stored in two relations.

All fields are stored in four relations.

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

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

All of these

Limit the use of null values in some fields.

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

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

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?

NUMBER

VARCHAR2

CHAR

LONG

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

Selecting a data type involves which of the following?

All of these

Represent most values

Maximize storage space

Improve data integrity

TRUE ANSWER : ?
YOUR ANSWER : ?

If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?

All fields are stored in one relation.

All fields are stored in four relations.

All fields are stored in two relations.

All fields are stored in three relations.

TRUE ANSWER : ?
YOUR ANSWER : ?

When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An extent is a contiguous section of disk storage space.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑