Physical Database Design Distributing the columns of a table into several separate physical records is known as horizontal partitioning. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Sequential retrieval on a primary key for sequential file storage has which of the following features? Very fast Moderately fast Impractical Slow Very fast Moderately fast Impractical Slow 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? LONG CHAR VARCHAR2 NUMBER LONG CHAR VARCHAR2 NUMBER ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Hashing algorithm converts a primary key value into a record address. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A pointer is a detailed coding scheme recognized by system software for representing organizational data. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A secondary key is which of the following? Primary key Useful for denormalization decisions Determines the tablespace required Nonunique key Primary key Useful for denormalization decisions Determines the tablespace required Nonunique key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS