Physical Database Design Selecting a data type involves which of the following? Represent most values All of these Maximize storage space Improve data integrity Represent most values All of these Maximize storage space Improve data integrity 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 Denormalization and clustering can work well to minimize data access time for small records. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space. False True False True ANSWER DOWNLOAD EXAMIANS APP
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 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