logo

CuriousTab

CuriousTab

Discussion


Home Technical Questions Database Comments

  • Question
  • To eliminate definition duplication, XML Schemas define:


  • Options
  • A. an intersection table.
  • B. global elements.
  • C. a normalized definition table.
  • D. None of the above is correct.

  • Correct Answer
  • global elements. 


  • Database problems


    Search Results


    • 1. Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

    • Options
    • A. Supertype entity
    • B. Subtype entity
    • C. Archetype entity
    • D. Instance entity
    • Discuss
    • 2. Parenthesis is never required in Postfix or Prefix expressions

    • Options
    • A. TRUE
    • B. FALSE
    • Discuss
    • 3. It is necessary to sort a file before searching a particular item

    • Options
    • A. True
    • B. False
    • C. May or may not be true
    • D. None of the above
    • Discuss
    • 4. A transitive dependency is which of the following?

    • Options
    • A. A functional dependency between two or more key attributes.
    • B. A functional dependency between two or more nonkey attributes.
    • C. A relation that is in first normal form.
    • D. A relation that is in second normal form.
    • Discuss
    • 5. A shared database should:

    • Options
    • A. be accurate and available.
    • B. provide for backup and recovery.
    • C. be secure.
    • D. All of the above.
    • Discuss
    • 6. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a 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
    • 7. The HAVING clause does which of the following?

    • Options
    • A. Acts like a WHERE clause but is used for groups rather than rows.
    • B. Acts like a WHERE clause but is used for rows rather than columns.
    • C. Acts like a WHERE clause but is used for columns rather than groups.
    • D. Acts EXACTLY like a WHERE clause.
    • Discuss
    • 8. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

    • Options
    • A. LIKE only.
    • B. IN only.
    • C. NOT IN only.
    • D. Both IN and NOT IN.
    • Discuss
    • 9. If a table has been normalized so that all determinants are candidate keys, then that table is in:

    • Options
    • A. 1NF
    • B. 2NF
    • C. 3NF
    • D. BCNF
    • Discuss
    • 10. When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

    • Options
    • A. first step.
    • B. second step.
    • C. third step.
    • D. fourth step.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment