logo

CuriousTab

CuriousTab

Discussion


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

  • Correct Answer
  • All fields are stored in one relation. 


  • More questions

    • 1. With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.

    • Options
    • A. Nonclustered
    • B. Clustered
    • C. Primary
    • D. Secondary
    • Discuss
    • 2. Which of the following statements is not true about XML Schemas:

    • Options
    • A. They are used to define the content and structure of data.
    • B. They define a set of symbols and the relationships of those symbols.
    • C. They are themselves XML documents.
    • D. They have their own syntax.
    • Discuss
    • 3. Dirty read, nonrepeatable, and phantom reads are not possible in this instance.

    • Options
    • A. Read committed
    • B. Read uncommitted
    • C. Repeatable read
    • D. Serializable
    • Discuss
    • 4. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

    • Options
    • A. A ? B.
    • B. A ? C.
    • C. A ? (B,C).
    • D. (B,C) ? A.
    • Discuss
    • 5. A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. With an enterprise data model, it is much easier to build applications because you know exactly what data exist and what needs to be added.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. What is not true of a Java bean?

    • Options
    • A. There are no public instance variables.
    • B. All persistent values are accessed using getxxx and setxxx methods.
    • C. It may have many constructors as necessary.
    • D. All of the above are true of a Java bean.
    • Discuss
    • 8. With which type of SQL Server recovery model are all database changes logged?

    • Options
    • A. Differential recovery
    • B. Full recovery
    • C. Simple recovery
    • D. Bulk-logged recovery
    • Discuss
    • 9. The DBMS acts as an interface between what two components of an enterprise-class database system?

    • Options
    • A. Database application and the database
    • B. Data and the database
    • C. The user and the database application
    • D. Database application and SQL
    • Discuss
    • 10. A binary relationship cannot be which of the following?

    • Options
    • A. One-to-One
    • B. One-to-Many
    • C. Many-to-Many
    • D. Zero-to-Zero
    • Discuss


    Comments

    There are no comments.

Enter a new Comment