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 use of null values in some fields. All of these Limit the set of permissible values that a field may assume. Assume a default value in a field unless a user enters a value for that field. Limit the use of null values in some fields. All of these Limit the set of permissible values that a field may assume. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A bitmap index is an index on columns from two or more tables that come from the same domain of values. True False True False 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 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. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A secondary key is which of the following? Nonunique key Determines the tablespace required Useful for denormalization decisions Primary key Nonunique key Determines the tablespace required Useful for denormalization decisions Primary key ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Denormalization and clustering can work well to minimize data access time for small records. False True False True 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
EXAMIANS