Database - Database Design Using Normalization
Exercise :: Database Design Using Normalization - General Questions
| 6. |
When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the: |
| A. |
first step. | | B. |
second step. | | C. |
third step. | | D. |
fourth step. |
Answer: Option B
Explanation:
|
| 7. |
Creating a read-only database is a task that is ________ assigned to beginning database professionals. |
Answer: Option B
Explanation:
|
| 8. |
Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column 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 D
Explanation:
|
| 9. |
For a number of reasons, normalizations is not often an advantage for a(n) ________ database. |
| A. |
read-only | | B. |
updateable | | C. |
either a read-only or an updateable | | D. |
None of the above is correct. |
Answer: Option A
Explanation:
|
| 10. |
Most of the time, modification anomalies are serious enough that tables should be normalized into: |
Answer: Option D
Explanation:
|
