logo

CuriousTab

CuriousTab

Discussion


Home Technical Questions Database Comments

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

  • Correct Answer
  • Supertype entity 


  • Database problems


    Search Results


    • 1. Parenthesis is never required in Postfix or Prefix expressions

    • Options
    • A. TRUE
    • B. FALSE
    • Discuss
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

    • Options
    • A. Two
    • B. Three
    • C. Four
    • D. Six
    • Discuss
    • 6. 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.
    • Discuss
    • 7. 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
    • 8. 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
    • 9. 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
    • 10. 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


    Comments

    There are no comments.

Enter a new Comment