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
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 Sequential retrieval on a primary key for sequential file storage has which of the following features? Very fast Impractical Slow Moderately fast Very fast Impractical Slow Moderately fast ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Selecting a data type involves which of the following? Maximize storage space Improve data integrity All of these Represent most values Maximize storage space Improve data integrity All of these Represent most values ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following improves a query's processing time? Query one query within another. Write complex queries. Use compatible data types. Combine a table with itself. Query one query within another. Write complex queries. Use compatible data types. Combine a table with itself. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length? NUMBER VARCHAR2 CHAR LONG NUMBER VARCHAR2 CHAR LONG ANSWER DOWNLOAD EXAMIANS APP