Physical Database Design What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? CHAR NUMBER VARCHAR2 LONG CHAR NUMBER VARCHAR2 LONG ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Selecting a data type involves which of the following? Improve data integrity All of these Represent most values Maximize storage space Improve data integrity All of these Represent most values Maximize storage space ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Sequential retrieval on a primary key for sequential file storage has which of the following features? Slow Impractical Moderately fast Very fast Slow Impractical Moderately fast Very fast ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A secondary key is which of the following? Determines the tablespace required Useful for denormalization decisions Primary key Nonunique key Determines the tablespace required Useful for denormalization decisions Primary key Nonunique key 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 The blocking factor is: attributes grouped together by the same secondary key. the number of physical records per page. a group of fields stored in adjacent memory. attributes grouped together by the same primary key. attributes grouped together by the same secondary key. the number of physical records per page. a group of fields stored in adjacent memory. attributes grouped together by the same primary key. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS