| 11. | Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values? |
| a. | A domain constraint |
| b. | A range constraint |
| c. | An intrarelation constraint |
| d. | An interrelation constraint |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (a).A domain constraint
|
| 12. | In a 1:N relationship, the foreign key is placed in: |
| a. | either table without specifying parent and child tables. |
| b. | the parent table. |
| c. | the child table. |
| d. | either the parent table or the child table. |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (c).the child table.
|
| 13. | Which of the following column properties specifies whether or not cells in a column must contain a data value? |
| a. | Null status |
| b. | Data type |
| c. | Default value |
| d. | Data constraints |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (a).Null status
|
| 14. | A primary key should be defined as: |
| a. | NULL |
| b. | NOT NULL |
| c. | Either of the above can be used |
| d. | None of the above are correct |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).NOT NULL
|
| 15. | Which of the following column properties would be used to specify that cells in a column must contain a monetary value? |
| a. | Null status |
| b. | Data type |
| c. | Default value |
| d. | Data constraints |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).Data type
|
| 16. | If a denormalization situation exists with a one-to-one binary relationship, which of the following is true? |
| a. | All fields are stored in one relation. |
| b. | All fields are stored in two relations. |
| c. | All fields are stored in three relations. |
| d. | All fields are stored in four relations. |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (a).All fields are stored in one relation.
|
| 17. | Selecting a data type involves which of the following? |
| a. | Maximize storage space |
| b. | Represent most values |
| c. | Improve data integrity |
| d. | All of the above |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (c).Improve data integrity
|
| 18. | What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? |
| a. | VARCHAR2 |
| b. | CHAR |
| c. | LONG |
| d. | NUMBER |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (a).VARCHAR2
|
| 19. | A multidimensional database model is used most often in which of the following models? |
| a. | Data warehouse |
| b. | Relational |
| c. | Hierarchical |
| d. | Network |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (a).Data warehouse
|
| 20. | Which of the following is not a factor to consider when switching from small to large block size? |
| a. | The length of all of the fields in a table row. |
| b. | The number of columns |
| c. | Block contention |
| d. | Random row access speed |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).The number of columns
|
