Selecting a data type involves which of the following? All of these Represent most values Maximize storage space Improve data integrity TRUE ANSWER : ? YOUR ANSWER : ?
If a denormalization situation exists with a one-to-one binary relationship, which of the following is true? All fields are stored in three relations. All fields are stored in two relations. All fields are stored in four relations. All fields are stored in one relation. TRUE ANSWER : ? YOUR ANSWER : ?
Sequential retrieval on a primary key for sequential file storage has which of the following features? Slow Very fast Impractical Moderately fast TRUE ANSWER : ? YOUR ANSWER : ?
A multidimensional database model is used most often in which of the following models? Hierarchical Relational Network Data warehouse TRUE ANSWER : ? YOUR ANSWER : ?
A rule of thumb for choosing indexes for a relational database includes which of the following? Indexes are more useful on smaller tables. 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. Be careful indexing attributes that have null values. TRUE ANSWER : ? YOUR ANSWER : ?
The fastest read/write time and most efficient data storage of any disk array type is: RAID-0 RAID-2 RAID-1 RAID-3 TRUE ANSWER : ? YOUR ANSWER : ?
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process. False True TRUE ANSWER : ? YOUR ANSWER : ?
Distributing the columns of a table into several separate physical records is known as horizontal partitioning. True False TRUE ANSWER : ? YOUR ANSWER : ?
Some advantages of partitioning include: efficiency, security, and load balancing. False True TRUE ANSWER : ? YOUR ANSWER : ?
A secondary key is which of the following? Determines the tablespace required Nonunique key Primary key Useful for denormalization decisions TRUE ANSWER : ? YOUR ANSWER : ?