Physical Database Design A secondary key is which of the following? Nonunique key Useful for denormalization decisions Determines the tablespace required Primary key Nonunique key Useful for denormalization decisions Determines the tablespace required Primary key ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Selecting a data type involves which of the following? Represent most values All of these Maximize storage space Improve data integrity Represent most values All of these Maximize storage space Improve data integrity ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design The three newest database architectures in use today are relational, multidimensional and hierarchical. False True False True ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Sequential retrieval on a primary key for sequential file storage has which of the following features? Moderately fast Very fast Impractical Slow Moderately fast Very fast Impractical Slow ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design An extent is a contiguous section of disk storage space. True False True False ANSWER DOWNLOAD EXAMIANS APP