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:
|