Physical Database Design Which of the following is an advantage of partitioning? Inconsistent access speed Extra space Complexity Security Inconsistent access speed Extra space Complexity Security 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A field represents each component of a composite attribute. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A secondary key is which of the following? Primary key Useful for denormalization decisions Nonunique key Determines the tablespace required Primary key Useful for denormalization decisions Nonunique key Determines the tablespace required 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
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