Physical Database Design A rule of thumb for choosing indexes for a relational database includes which of the following? Indexes are more useful on smaller tables. 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. Do not specify a unique index for the primary key of each table. Indexes are more useful on smaller tables. 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. Do not specify a unique index for the primary key of each table. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design A bitmap index is an index on columns from two or more tables that come from the same domain of values. False True False True 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 The blocking factor is: attributes grouped together by the same secondary key. a group of fields stored in adjacent memory. the number of physical records per page. attributes grouped together by the same primary key. attributes grouped together by the same secondary key. a group of fields stored in adjacent memory. the number of physical records per page. attributes grouped together by the same primary key. ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Selecting a data type involves which of the following? All of these Improve data integrity Represent most values Maximize storage space All of these Improve data integrity Represent most values Maximize storage space ANSWER DOWNLOAD EXAMIANS APP
Physical Database Design Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS