logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Physical Database Design See What Others Are Saying!
  • 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. 

    • More questions

    • 1. The benefits of object-oriented modeling are which of the following?

    • Options
    • A. The ability to tackle more challenging problems
    • B. Reusability of analysis, design, and programming results
    • C. Improved communication between users, analysts, etc.
    • D. All of the above.
      • Discuss
    • 2. A heterogeneous distributed database is which of the following?

    • Options
    • A. The same DBMS is used at each location and data are not distributed across all nodes.
    • B. The same DBMS is used at each location and data are distributed across all nodes.
    • C. A different DBMS is used at each location and data are not distributed across all nodes.
    • D. A different DBMS is used at each location and data are distributed across all nodes.
      • Discuss
    • 3. Which SQL-92 standard SQL command can be used to change a table name?

    • Options
    • A. RENAME TABLE
    • B. CHANGE TABLE
    • C. ALTER TABLE
    • D. None of the above is correct.
      • Discuss
    • 4. The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Market basket analysis primarily uses the technique of conditional probabilities.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. A stored procedure is a program that performs some common action on database data and is stored in the database.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Which of the following columns is(are) are required in a table?

    • Options
    • A. A foreign key
    • B. An alternate key
    • C. A primary key
    • D. A surrogate key.
      • Discuss
    • 9. Packaged data models are meant to be exactly right straight out of the box.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

    • Options
    • A. the primary key
    • B. any alternate key
    • C. a surrogate key
    • D. a foreign key
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.