Physical Database Design An extent is a contiguous section of disk storage space. False True False True ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following improves a query's processing time? Use compatible data types. Write complex queries. Query one query within another. Combine a table with itself. Use compatible data types. Write complex queries. Query one query within another. Combine a table with itself. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Some advantages of partitioning include: efficiency, security, and load balancing. False True False True ANSWER DOWNLOAD EXAMIANS APP
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 Sequential retrieval on a primary key for sequential file storage has which of the following features? Very fast Moderately fast Slow Impractical Very fast Moderately fast Slow Impractical ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Hashing algorithm converts a primary key value into a record address. False True False True ANSWER DOWNLOAD EXAMIANS APP