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. False True False True 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Sequential retrieval on a primary key for sequential file storage has which of the following features? Impractical Very fast Slow Moderately fast Impractical Very fast Slow Moderately fast 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 use of null values in some fields. Limit the set of permissible values that a field may assume. All of these 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. Limit the set of permissible values that a field may assume. All of these ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A field represents each component of a composite attribute. False True False True ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Selecting a data type involves which of the following? Improve data integrity All of these Maximize storage space Represent most values Improve data integrity All of these Maximize storage space Represent most values ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS