Physical Database Design The fastest read/write time and most efficient data storage of any disk array type is: RAID-3 RAID-2 RAID-1 RAID-0 RAID-3 RAID-2 RAID-1 RAID-0 ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design The blocking factor is: a group of fields stored in adjacent memory. attributes grouped together by the same secondary key. attributes grouped together by the same primary key. the number of physical records per page. a group of fields stored in adjacent memory. attributes grouped together by the same secondary key. attributes grouped together by the same primary key. the number of physical records per page. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers. 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 NUMBER LONG VARCHAR2 CHAR NUMBER LONG VARCHAR2 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 Which of the following is an advantage of partitioning? Extra space Security Complexity Inconsistent access speed Extra space Security Complexity Inconsistent access speed ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS