Chapter 6 - Homework of Chapter 6 CIS4271/CIS6274 Fall...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Homework of Chapter 6 CIS4271/CIS6274 Fall Quarter 2007 MULTIPLE CHOICE: Choose the one alternative that best completes the statement or answers the question. 1. ( A ) Database access frequencies are estimated from: A) transaction volumes. B) user logins. C) security violations. D) none of the above. 2. ( D ) 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 3. ( C ) In which data model would a code table appear? A) Conceptual B) Logical C) Physical D) Data layout 4. ( D ) 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. 5. ( B ) All of the following are common denormalization opportunities EXCEPT: A)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. 6. ( A ) In most cases the goal of _____ dominates the design process. A) efficient data processing B) security C) quick pointer updates D) shorter design times 7. ( A ) Horizontal partitioning makes sense: A) when different categories of a table's rows are processed separately. B)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Chapter 6 - Homework of Chapter 6 CIS4271/CIS6274 Fall...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online