logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Processing for BIS See What Others Are Saying!
  • Question

  • We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .


  • Options
  • A. dirty data
  • B. inconsistent data
  • C. non-integrated data
  • D. a "wrong format" problem

  • Correct Answer
  • non-integrated data 

    • More questions

    • 1. BI reporting systems summarize the current status of business activities in order to predict future activities.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:

    • Options
    • A. first step.
    • B. second step.
    • C. third step.
    • D. fourth step.
      • Discuss
    • 3. It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. The SQL keyword(s) ________ is used with wildcards.

    • Options
    • A. LIKE only
    • B. IN only
    • C. NOT IN only
    • D. IN and NOT IN
      • Discuss
    • 5. A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Denormalized tables are in BCNF.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. The purpose of timestamping is to avoid the use of locks.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. A relationship is which of the following?

    • Options
    • A. A person, place, or thing
    • B. Property or characteristic of an entity
    • C. Link between entities
    • D. Weak entity
      • Discuss
    • 9. The XML family of standards is very important in database processing today.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Which of the following is valid SQL for an Index?

    • Options
    • A. CREATE INDEX ID;
    • B. CHANGE INDEX ID;
    • C. ADD INDEX ID;
    • D. REMOVE INDEX ID;
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.