PHYSICAL DATABASE DESIGN QUIZ

Which of the following is not a factor to consider when switching from small to large block size?

Block contention

The number of columns

Random row access speed

The length of all of the fields in a table row

TRUE ANSWER : ?
YOUR ANSWER : ?

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.

True

False

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

A multidimensional database model is used most often in which of the following models?

Relational

Network

Data warehouse

Hierarchical

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

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 two relations.

All fields are stored in three relations.

All fields are stored in one relation.

All fields are stored in four relations.

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 three newest database architectures in use today are relational, multidimensional and hierarchical.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?

LONG

VARCHAR2

NUMBER

CHAR

TRUE ANSWER : ?
YOUR ANSWER : ?

↑