Database Design Using Normalization problems
- 1. When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
Options- A. first step.
- B. second step.
- C. third step.
- D. fourth step. Discuss
Correct Answer: second step.
- 2. Needing to assess the validity of assumed referential integrity constraints on foreign keys 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: neither an advantage nor disadvantage
- 3. Creating a read-only database is a task that is ________ assigned to beginning database professionals.
Options- A. always
- B. commonly
- C. seldom
- D. never Discuss
Correct Answer: commonly
- 4. Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn 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 columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- 5. For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
Options- A. read-only
- B. updateable
- C. either a read-only or an updateable
- D. None of the above is correct. Discuss
Correct Answer: read-only
- 6. Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
Options- A. The multivalue, multicolumn problem
- B. The inconsistent values problem
- C. The missing values problem
- D. The general-purpose remarks column problem Discuss
Correct Answer: The inconsistent values problem
- 7. Most of the time, modification anomalies are serious enough that tables should be normalized into:
Options- A. 1NF.
- B. 2NF.
- C. 3NF.
- D. BCNF. Discuss
Correct Answer: BCNF.
- 8. If a table has been normalized so that all determinants are candidate keys, then that table is in:
Options- A. 1NF.
- B. 2NF.
- C. 3NF.
- D. BCNF. Discuss
Correct Answer: BCNF.
- 9. When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
Options- A. first step.
- B. second step.
- C. third step.
- D. fourth step. Discuss
Correct Answer: first step.
- 10. Each answer below shows example data from a table. Which answer is an example of the missing 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, NULL, and Blue in the same column.
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.