CC 105

Front

Physical database design focuses on converting the logical model into technical storage specifications.

Back

TRUE

Front

Volume estimates help determine how fast data will grow in the database.

Back

TRUE

Front

VARCHAR2 is a fixed-length character data type. 

Back

FALSE

Front

Range control ensures that foreign key values match primary key values in related tables.

Back

FALSE

Front

BLOB is used to store binary large objects such as images and audio files.

Back

TRUE

Front

Denormalization always reduces redundancy and improves data integrity.

Back

FALSE

Front

A physical record is retrieved as a unit from adjacent memory locations.

Back

TRUE

Front

Partitioning a table may help improve performance for users who need access to different data subsets.

Back

TRUE

Front

Data replication decreases data integrity because of multiple copies of the same data.

Back

TRUE

Front

Hashed file organization stores records in random order based on a hashing algorithm.

Back

TRUE