Physical Database Design What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length? VARCHAR2 NUMBER LONG CHAR VARCHAR2 NUMBER LONG CHAR ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following are integrity controls that a DBMS may support? Assume a default value in a field unless a user enters a value for that field. Limit the set of permissible values that a field may assume. All of these 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. Limit the set of permissible values that a field may assume. All of these Limit the use of null values in some fields. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design The fastest read/write time and most efficient data storage of any disk array type is: RAID-3 RAID-2 RAID-0 RAID-1 RAID-3 RAID-2 RAID-0 RAID-1 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
Physical Database Design An extent is a contiguous section of disk storage space. False True False True 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
EXAMIANS