logo

CuriousTab

CuriousTab

Discussion


Home Technical Questions Database Comments

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

  • Correct Answer
  • third step. 


  • Database problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. 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
    • 6. Legacy data is which of the following?

    • Options
    • A. Data contained in a newly-installed system
    • B. Data rejected during the installation of a new system
    • C. Data contained in a file system
    • D. Data contained by a system used prior to the installation of a new system
    • Discuss
    • 7. The command to eliminate a table from a database is

    • Options
    • A. REMOVE TABLE CUSTOMER;
    • B. UPDATE TABLE CUSTOMER;
    • C. DELETE TABLE CUSTOMER;
    • D. DROP TABLE CUSTOMER;
    • Discuss
    • 8. Which of the following describes a relational database?

    • Options
    • A. It retrieves data related to its queries
    • B. It provides a relationship between floats
    • C. It provides a relationship between integers
    • D. It consists of separate tables or related data
    • Discuss
    • 9. An entity is a thing in the real world with an independent existence.

    • Options
    • A. TRUE
    • B. FALSE
    • Discuss
    • 10. In the relational model, relationships between relations or tables are created by using:

    • Options
    • A. composite keys.
    • B. determinants.
    • C. candidate keys.
    • D. foreign keys.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment