 |
1 | |
A large database typically has the following number of tables: |
| | A) | Thousands |
| | B) | From 50 to 100 |
| | C) | About 40 |
| | D) | About 20 |
|
|
2 | |
Which of the following is a source of information requirements for view design? |
| | A) | Proposed forms |
| | B) | Proposed reports |
| | C) | Interviews |
| | D) | All of the above |
|
|
3 | |
Which of the following is not true about forms? |
| | A) | Forms may be designed once the database has been designed |
| | B) | Forms may be used to design a database |
| | C) | Forms are a source of requirements |
| | D) | Forms and views are not related |
|
|
4 | |
Which form structure would not be identified in the analysis of a form used by a bookstore? |
| | A) | Parent Node is Book and child node is Children-Book |
| | B) | Parent Node is Book and child node is Book-Copy-in-Store |
| | C) | Parent Node is Order and child node is Book |
| | D) | Parent Node is Customer and child node is Book-ordered |
|
|
5 | |
Which of the following lists is the correct order for processing of some elements in the form analysis process? |
| | A) | Attributes, entities, relationships |
| | B) | Entities, relationships, attributes |
| | C) | Entities, attributes, relationships |
| | D) | Relationships, entities, attributes |
|
|
6 | |
In an ERD Diagram derived from a form, at least one relationship will be: |
| | A) | 1-1 or 1-M |
| | B) | 1-M |
| | C) | M-N |
| | D) | 1-M or M-N |
|
|
7 | |
The two basic approaches to view integration are: |
| | A) | Incremental and parallel |
| | B) | Synonyms and homonyms |
| | C) | Sequential and parallel |
| | D) | Incremental and sequential |
|
|
8 | |
Which approach would be used to integrate many views of a very large database? |
| | A) | Sequential |
| | B) | Incremental |
| | C) | Parallel |
| | D) | A combination of the parallel and incremental approaches |
|
|
9 | |
Which of the following should be a subset toward view integration? |
| | A) | P, X, Y, Z |
| | B) | X, Y, Z |
| | C) | Y, Z |
| | D) | X, P |
|
|
10 | |
Which of the following should be a subset toward view integration? |
| | A) | Q, R |
| | B) | X, P, Q, R |
| | C) | P, Q, R |
| | D) | X, P |
|