PHYSICAL DATABASE DESIGN QUIZ

Denormalization and clustering can work well to minimize data access time for small records.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Sequential retrieval on a primary key for sequential file storage has which of the following features?

Very fast

Slow

Impractical

Moderately fast

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Combine a table with itself.

Use compatible data types.

Query one query within another.

Write complex queries.

TRUE ANSWER : ?
YOUR ANSWER : ?

A rule of thumb for choosing indexes for a relational database includes which of the following?

Do not specify a unique index for the primary key of each table.

Be careful indexing attributes that have null values.

Indexes are more useful on smaller tables.

Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An extent is a contiguous section of disk storage space.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑