logo

CuriousTab

CuriousTab

Discussion


Home Database Physical Database Design Comments

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

  • Correct Answer
  • The number of columns 


  • Physical Database Design problems


    Search Results


    • 1. 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
    • 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. 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
    • 4. 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
    • 5. 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
    • 6. 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
    • 7. 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
    • 8. 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
    • 9. 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
    • 10. 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


    Comments

    There are no comments.

Enter a new Comment