Exam 8: Physical Database Design

File structures,data placement,data formatting,and denormalization are all ____________ of the physical database design process.

Which of the following is true about access plan execution?

Which one of the following is true about B-trees (including B-tree variations)?

A dominant RAID architecture which uses both data and error-correcting pages to improve reliability is ____________.

A physical record:

In selecting an index,a column that has almost unique values is a good choice for a clustering index if it is used in equality conditions.

A(n)_____________ file is a specialized file structure that transforms a key value into a physical record address to provide fast access to the data.

One of the dominant RAID architectures,___________ involves a full mirror or redundant array of disks,on which each physical record is written to both arrays in parallel.

The table EMPLOYEE with primary key = empno uses as hash function empno Mod 100, which gives the physical record number when applied to Empno. The linear probe procedure is used for collision handling. The physical records are created in the order of logical records (= rows) in the table, one physical record for one logical record EMPLOYEE Empno 2011 2012 2211 2311 2312 2313 2317 -Which logical record (identified by empno)is stored at physical address 13?

A Sequential File is a simple file organization in which records are stored in insertion order or by key value.

Bitmap indexes are a good alternative to Btree index nodes when the columns to be indexed contain only a few values.

The B+tree structure improves the performance of sequential searches over Btree because the leaf nodes are connected together so that the search does not have to move up and down the tree.

In hash files,if a collision occurs because two keys hash to the same physical address,one method for locating a physical record with free space is a linear probe.

A logical record may be split across several physical records.

Which of the following contributes to the difficulty of physical database design?

INSERT and DELETE statements affect only the indexes of the records being added or deleted.

In a ____________ index,the order of the data records is close to the index order.

A(n)________________ is a situation that occurs when a hash function assigns the same physical record address to more than one key in a file.

You should avoid creating too many indexes on tables which will have many insertion and/or deletion operations.

A(n)______________ is a collection of bytes that are transferred between volatile storage in main memory and stable storage on a disk.