Database - Database Design Using Normalization
Exercise :: Database Design Using Normalization - General Questions
| 16. |
Read-only databases are ________ updated. |
Answer: Option D
Explanation:
|
| 17. |
Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization. |
| A. |
advantage | | B. |
disadvantage | | C. |
either an advantage or disadvantage | | D. |
neither an advantage nor disadvantage |
Answer: Option D
Explanation:
|
| 18. |
When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the: |
| A. |
first step. | | B. |
second step. | | C. |
third step. | | D. |
fourth step. |
Answer: Option B
Explanation:
|
| 19. |
Normalization ________ data duplication. |
| A. |
eliminates | | B. |
reduces | | C. |
increases | | D. |
maximizes |
Answer: Option A
Explanation:
|
| 20. |
Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem? |
| 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. |
Answer: Option B
Explanation:
|
