Physical Database Design problems
- 1. A secondary key is which of the following?
Options- A. Nonunique key
- B. Primary key
- C. Useful for denormalization decisions
- D. Determines the tablespace required Discuss
Correct Answer: Nonunique key
- 2. Selecting a data type involves which of the following?
Options- A. Maximize storage space
- B. Represent most values
- C. Improve data integrity
- D. All of the above. Discuss
Correct Answer: Improve data integrity
- 3. The blocking factor is:
Options- A. a group of fields stored in adjacent memory.
- B. the number of physical records per page.
- C. attributes grouped together by the same primary key.
- D. attributes grouped together by the same secondary key. Discuss
Correct Answer: the number of physical records per page.
- 4. Which of the following is not a factor to consider when switching from small to large block size?
Options- 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 Discuss
Correct Answer: The number of columns
- 5. If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
Options- 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. Discuss
Correct Answer: All fields are stored in one relation.
- 6. Which of the following improves a query's processing time?
Options- A. Write complex queries.
- B. Combine a table with itself.
- C. Query one query within another.
- D. Use compatible data types. Discuss
Correct Answer: Use compatible data types.
- 7. If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
Options- 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. Discuss
Correct Answer: All fields are stored in two relations.
- 8. What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
Options- A. VARCHAR2
- B. CHAR
- C. LONG
- D. NUMBER Discuss
Correct Answer: CHAR
- 9. Which of the following are integrity controls that a DBMS may support?
Options- A. Assume a default value in a field unless a user enters a value for that field.
- B. Limit the set of permissible values that a field may assume.
- C. Limit the use of null values in some fields.
- D. All of the above. Discuss
Correct Answer: All of the above.
- 10. The fastest read/write time and most efficient data storage of any disk array type is:
Options- A. RAID-0.
- B. RAID-1.
- C. RAID-2.
- D. RAID-3. Discuss
Correct Answer: RAID-0.
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.