CLIENT SERVER DATABASE 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 : ?

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

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

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

An extent is a contiguous section of disk storage space.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an advantage of partitioning?

Inconsistent access speed

Extra space

Complexity

Security

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following improves a query's processing time?

Query one query within another.

Use compatible data types.

Combine a table with itself.

Write complex queries.

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?

CHAR

LONG

VARCHAR2

NUMBER

TRUE ANSWER : ?
YOUR ANSWER : ?

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

CHAR

NUMBER

LONG

VARCHAR2

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

↑