Physical Database Design A secondary key is which of the following? Determines the tablespace required Nonunique key Primary key Useful for denormalization decisions Determines the tablespace required Nonunique key Primary key Useful for denormalization decisions ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process. False True False True ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design An extent is a contiguous section of disk storage space. False True False True ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? NUMBER VARCHAR2 LONG CHAR NUMBER VARCHAR2 LONG CHAR ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A field represents each component of a composite attribute. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length? VARCHAR2 NUMBER CHAR LONG VARCHAR2 NUMBER CHAR LONG ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS