Database Design Using Normalization problems
- 1. Read-only databases are ________ updated.
Options- A. always
- B. commonly
- C. seldom
- D. never Discuss
Correct Answer: never
- 2. Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Options- A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- C. Three rows have the values Brown, NULL, and Blue in the same column.
- D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column. Discuss
Correct Answer: Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- 3. Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Options- A. advantage
- B. disadvantage
- C. either an advantage or disadvantage
- D. neither an advantage nor disadvantage Discuss
Correct Answer: disadvantage
- 4. Normalization ________ data duplication.
Options- A. eliminates
- B. reduces
- C. increases
- D. maximizes Discuss
Correct Answer: eliminates
- 5. When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
Options- A. first step.
- B. second step.
- C. third step.
- D. fourth step. Discuss
Correct Answer: second step.
- 6. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
Options- A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- C. Three rows have the values Brown, NULL, and Blue in the same column.
- D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column. Discuss
Correct Answer: One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
- 7. Multivalued dependencies should ________ be eliminated.
Options- A. always
- B. commonly
- C. seldom
- D. never Discuss
Correct Answer: always
- 8. When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
Options- A. first step.
- B. second step.
- C. third step.
- D. fourth step. Discuss
Correct Answer: third step.
- 9. When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
Options- A. first step.
- B. second step.
- C. third step.
- D. fourth step. Discuss
Correct Answer: second step.
- 10. Eliminating modification anomalies is a(n) ________ of normalization.
Options- A. advantage
- B. disadvantage
- C. either an advantage or disadvantage
- D. neither an advantage nor disadvantage Discuss
Correct Answer: advantage
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.