Physical Database Design Which of the following are integrity controls that a DBMS may support? All of these 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. Limit the use of null values in some fields. All of these 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. Limit the use of null values in some fields. 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 Which of the following improves a query's processing time? Use compatible data types. Combine a table with itself. Query one query within another. Write complex queries. Use compatible data types. Combine a table with itself. Query one query within another. Write complex queries. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Selecting a data type involves which of the following? Improve data integrity Maximize storage space Represent most values All of these Improve data integrity Maximize storage space Represent most values All of these ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design The fastest read/write time and most efficient data storage of any disk array type is: RAID-0 RAID-2 RAID-1 RAID-3 RAID-0 RAID-2 RAID-1 RAID-3 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS