Ch5. Physical Database Design and Performance

13) The value a field will assume unless the user enters an explicit value for an instance of that field is called a(n): A) default value. B) null value. C) range control. D) gurand.

A) default value.

20) An advantage of partitioning is: A) efficiency. B) remote optimization. C) extra space and update time. D) both A and B.

A) efficiency.

17) In most cases, the goal of ________ dominates the design process. A) efficient data processing B) security C) quick pointer updates D) shorter design times

A) efficient data processing

9) The smallest unit of application data recognized by system software is a: A) field. B) row. C) data type. D) column.

A) field.

5) Database access frequencies are estimated from: A) transaction volumes. B) user logins. C) security violations. D) none of the above.

A) transaction volumes.

16) All of the following are common denormalization opportunities EXCEPT: A) two entities with a one-to-one relationship. B) a one-to-many relationship. C) a many-to-many relationship with nonkey attributes. D) reference data.

A) two entities with a one-to-one relationship.

19) Horizontal partitioning makes sense: A) when different categories of a table's rows are processed separately. B) when less security is needed. C) when partitions must be organized the same. D) when all of the above are true.

A) when different categories of a table's rows are processed separately.

8) All of the following are valid datatypes in Oracle 11g EXCEPT: A) varchar2. B) boolean. C) blob. D) number.

B) boolean.

24) A form of denormalization where the same data are stored in multiple places in the database is called: A) data duplication. B) data replication. C) advanced placement. D) horizontal partitioning.

B) data replication.

6) A detailed coding scheme recognized by system software for representing organizational data is called a(n): A) DBMS code. B) data type. C) SQL. D) DB layout.

B) data type.

3) Designing physical files requires ________ of where and when data are used in various ways. A) maps B) descriptions C) keys D) hints

B) descriptions

18) Distributing the rows of data into separate files is called: A) normalization. B) horizontal partitioning. C) vertical partitioning. D) file allocation.

B) horizontal partitioning.

2) A key decision in the physical design process is: A) knowing the user base. B) selecting structures. C) deciding on the monitor. D) all of the above.

B) selecting structures.

11) In which data model would a code table appear? A) Conceptual B) Logical C) Physical D) Data layout

C) Physical

23) ________ partitioning distributes the columns of a table into several separate physical records. A) Horizontal B) Crossways C) Vertical D) Final

C) Vertical

15) Sensitivity testing involves: A) checking to see if your teeth hurt when you brush. B) seeing how accurate data are. C) checking to see if missing data will greatly impact results. D) none of the above.

C) checking to see if missing data will greatly impact results.

4) The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space. A) query design B) programmer productivity C) data integrity D) data integration

C) data integrity

27) A contiguous section of disk storage space is called a(n): A) track. B) sector. C) extent. D) tablespace.

C) extent.

21) A disadvantage of partitioning is: A) simplicity. B) remote optimization. C) extra space and update time. D) shorter technology spans.

C) extra space and update time.

29) A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices. A) physical pointer B) retrieval program C) file organization D) update program

C) file organization

22) All of the following are horizontal partitioning methods in Oracle EXCEPT: A) key range partitioning. B) hash partitioning. C) multivalued partitioning. D) composite partitioning.

C) multivalued partitioning.

12) An integrity control supported by a DBMS is: A) substitute estimates. B) security. C) range control. D) GUI guards.

C) range control.

25) Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n): A) extent. B) table. C) tablespace. D) partition.

C) tablespace.

10) Which of the following is an objective of selecting a data type? A) Represent a small number of possible values B) Maximize storage space C) Limit security D) Improve data integrity

D) Improve data integrity

1) A requirement to begin designing physical files and databases is: A) normalized relations. B) definitions of each attribute. C) technology descriptions. D) all of the above.

D) all of the above.

14) A method for handling missing data is to: A) substitute and estimate for the missing data. B) track missing data with special reports. C) perform sensitivity testing. D) all of the above.

D) all of the above.

30) A factor to consider when choosing a file organization is: A) fast data retrieval. B) security. C) efficient storage. D) all of the above.

D) all of the above.

26) While Oracle has responsibility for managing data inside a tablespace, the tablespace as a whole is managed by the: A) user. B) database administrator. C) application developer. D) operating system.

D) operating system.

28) A(n) ________ is a field of data used to locate a related field or record. A) key B) index C) lock D) pointer

D) pointer

7) All of the following are objectives when selecting a data type EXCEPT: A) represent all possible values. B) improve data integrity. C) support all data manipulations. D) use a lot of storage space.

D) use a lot of storage space.