Which of the following is not a factor to consider when switching from small to large block size?
A. The length of all of the fields in a table row
B. The number of columns
C. Block contention
D. Random row access speed
Answer: Option B
Related Questions on Physical Database Design
A. All fields are stored in one relation.
B. All fields are stored in two relations.
C. All fields are stored in three relations.
D. All fields are stored in four relations.
Selecting a data type involves which of the following?
A. Maximize storage space
B. Represent most values
C. Improve data integrity
D. All of the above.
A. VARCHAR2
B. CHAR
C. LONG
D. NUMBER
A. All fields are stored in one relation.
B. All fields are stored in two relations.
C. All fields are stored in three relations.
D. All fields are stored in four relations.
Join The Discussion