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. All of these Limit the use of null values in some fields. 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. All of these Limit the use of null values in some fields. Limit the set of permissible values that a field may assume. 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 It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems. False True False True ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A secondary key is which of the following? Useful for denormalization decisions Primary key Determines the tablespace required Nonunique key Useful for denormalization decisions Primary key Determines the tablespace required Nonunique key 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
Physical Database Design In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system. True False True False ANSWER DOWNLOAD EXAMIANS APP