logo

CuriousTab

CuriousTab

Discussion


Home Technical Questions Database Comments

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

  • Correct Answer
  • Data contained by a system used prior to the installation of a new system 


  • Database problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. 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
    • 6. 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
    • 7. 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
    • 8. An entity is a thing in the real world with an independent existence.

    • Options
    • A. TRUE
    • B. FALSE
    • Discuss
    • 9. 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
    • 10. A transaction for which all committed changes are permanent is called:

    • Options
    • A. atomic.
    • B. consistent.
    • C. isolated.
    • D. durable.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment