Physical Database Design A multidimensional database model is used most often in which of the following models? Data warehouse Hierarchical Relational Network Data warehouse Hierarchical Relational Network ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A rule of thumb for choosing indexes for a relational database includes which of the following? Do not specify a unique index for the primary key of each table. Be careful indexing attributes that have null values. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries. Indexes are more useful on smaller tables. Do not specify a unique index for the primary key of each table. Be careful indexing attributes that have null values. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries. Indexes are more useful on smaller tables. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Some advantages of partitioning include: efficiency, security, and load balancing. True False True False ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A secondary key is which of the following? Determines the tablespace required Nonunique key Useful for denormalization decisions Primary key Determines the tablespace required Nonunique key Useful for denormalization decisions Primary key ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Which of the following improves a query's processing time? Use compatible data types. Query one query within another. Write complex queries. Combine a table with itself. Use compatible data types. Query one query within another. Write complex queries. Combine a table with itself. 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
EXAMIANS