Physical Database Design What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? VARCHAR2 CHAR NUMBER LONG VARCHAR2 CHAR NUMBER LONG ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following is an advantage of partitioning? Security Inconsistent access speed Complexity Extra space Security Inconsistent access speed Complexity Extra space ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design The three newest database architectures in use today are relational, multidimensional and hierarchical. 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? CHAR LONG NUMBER VARCHAR2 CHAR LONG NUMBER VARCHAR2 ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design The blocking factor is: 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. attributes grouped together by the same secondary key. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Some advantages of partitioning include: efficiency, security, and load balancing. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS