logo

CuriousTab

CuriousTab

Discussion


Home Database Physical Database Design Comments

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

  • Correct Answer
  • All fields are stored in two relations. 


  • Physical Database Design problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. 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
    • 6. 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
    • 7. 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
    • 8. 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
    • 9. A rule of thumb for choosing indexes for a relational database includes which of the following?

    • Options
    • A. Indexes are more useful on smaller tables.
    • B. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
    • C. Do not specify a unique index for the primary key of each table.
    • D. Be careful indexing attributes that have null values.
    • Discuss
    • 10. What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?

    • Options
    • A. VARCHAR2
    • B. CHAR
    • C. LONG
    • D. NUMBER
    • Discuss


    Comments

    There are no comments.

Enter a new Comment