logo

CuriousTab

CuriousTab

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

First 2