Physical Database Design Distributing the columns of a table into several separate physical records is known as horizontal partitioning. False True False True ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design The primary goal of physical database design is data processing efficiency. 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 Nonunique key Determines the tablespace required Useful for denormalization decisions Primary key Nonunique key Determines the tablespace required 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 Which of the following improves a query's processing time? Query one query within another. Combine a table with itself. Write complex queries. Use compatible data types. Query one query within another. Combine a table with itself. Write complex queries. Use compatible data types. 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