logo

CuriousTab

CuriousTab

Discussion


Home Database Physical Database Design Comments

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

  • Correct Answer
  • Improve data integrity 


  • Physical Database Design problems


    Search Results


    • 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. Which of the following statements concerning business rules is true?

    • Options
    • A. It should be complex.
    • B. It should not be convertible to computer code.
    • C. It may include restrictions.
    • D. All of the above.
    • Discuss
    • 3. Specialization is which of the following processes?

    • Options
    • A. Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
    • B. Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
    • C. Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.
    • D. Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.
    • Discuss
    • 4. A rectangle represents which of the following in an EER?

    • Options
    • A. Attribute
    • B. Entity
    • C. Optional One
    • D. Relationship
    • Discuss
    • 5. When an entity instance must be a member of only one subtype, it is which of the following?

    • Options
    • A. Disjoint with total specialization
    • B. Disjoint with partial specialization
    • C. Overlap with total specialization
    • D. Overlap with partial specialization
    • Discuss
    • 6. 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
    • 7. 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
    • 8. 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
    • 9. 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
    • 10. 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


    Comments

    There are no comments.

Enter a new Comment