Physical Database Design Which of the following is an advantage of partitioning? Inconsistent access speed Extra space Complexity Security Inconsistent access speed Extra space Complexity Security ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A secondary key is which of the following? Primary key Determines the tablespace required Useful for denormalization decisions Nonunique key Primary key Determines the tablespace required Useful for denormalization decisions Nonunique key ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Sequential retrieval on a primary key for sequential file storage has which of the following features? Impractical Slow Very fast Moderately fast Impractical Slow Very fast Moderately fast 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 CHAR LONG VARCHAR2 NUMBER CHAR LONG VARCHAR2 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 Hashing algorithm converts a primary key value into a record address. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS