Physical Database Design Some advantages of partitioning include: efficiency, security, and load balancing. 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 length that can vary? CHAR NUMBER LONG VARCHAR2 CHAR NUMBER LONG VARCHAR2 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. the number of physical records per page. attributes grouped together by the same primary key. attributes grouped together by the same secondary key. a group of fields stored in adjacent memory. the number of physical records per page. attributes grouped together by the same primary key. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A field represents each component of a composite attribute. False True False True ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following are integrity controls that a DBMS may support? Limit the use of null values in some fields. Assume a default value in a field unless a user enters a value for that field. All of these Limit the set of permissible values that a field may assume. Limit the use of null values in some fields. Assume a default value in a field unless a user enters a value for that field. All of these Limit the set of permissible values that a field may assume. 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