Modern Database Management, 12e (Hoffer) Chapter 5 Physical Database Design and Performance 1) A requirement to begin designing physical files and databases is: A) normalized relations. B) physical tables created. C) implementation complete. D) all datatypes determined. Answer: A LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Easy Classification: Concept AACSB: Information Technology 2) A key decision in the physical design process is: A) ignoring the size of the database. B) selecting structures. C) deciding on the monitor. D) deciding the e-r diagrams. Answer: B LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Easy Classification: Concept AACSB: Information Technology 3) Designing physical files requires ________ of where and when data are used in various ways. A) maps B) descriptions C) keys D) hints Answer: B LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Moderate Classification: Concept AACSB: Information Technology 4) Database access frequencies are estimated from: A) transaction volumes. B) user logins. C) security violations. D) random number generation. Answer: A LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Moderate Classification: Concept AACSB: Information Technology 5) 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. Answer: B LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Easy Classification: Concept AACSB: Information Technology 6) 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. Answer: D LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Easy Classification: Concept AACSB: Information Technology 7) All of the following are valid datatypes in Oracle 11g EXCEPT: A) varchar2. B) boolean. C) blob. D) number. Answer: B LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Moderate Classification: Concept AACSB: Information Technology 8) The smallest unit of application data recognized by system software is a: A) field. B) row. C) data type. D) column. Answer: A LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Moderate Classification: Concept AACSB: Information Technology 9) An appropriate datatype for one wanting a fixed-length type for last name would include: A) VarChar. B) Char. C) Blob. D) Date. Answer: B LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Moderate Classification: Application AACSB: Information Technology 10) An appropriate datatype for adding a sound clip would be: A) VarChar. B) Char. C) Blob. D) Date. Answer: C LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Moderate Classification: Application AACSB: Information Technology 11) 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 Answer: D LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Moderate Classification: Concept AACSB: Information Technology 12) In which data model would a code table appear? A) Conceptual B) Logical C) Physical D) Data layout Answer: C LO: 5.2: Describe the physical database design process, its objectives, and its deliverables. Difficulty: Easy Classification: Concept AACSB: Information Technology