Physical Database Design Some advantages of partitioning include: efficiency, security, and load balancing. 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 fixed length? CHAR LONG VARCHAR2 NUMBER CHAR LONG VARCHAR2 NUMBER ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design The blocking factor is: attributes grouped together by the same secondary key. a group of fields stored in adjacent memory. attributes grouped together by the same primary key. the number of physical records per page. attributes grouped together by the same secondary key. a group of fields stored in adjacent memory. attributes grouped together by the same primary key. the number of physical records per page. 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 secondary key is which of the following? Primary key Nonunique key Determines the tablespace required Useful for denormalization decisions Primary key Nonunique key Determines the tablespace required Useful for denormalization decisions ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Selecting a data type involves which of the following? Maximize storage space Represent most values All of these Improve data integrity Maximize storage space Represent most values All of these Improve data integrity ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS