logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Redesign See What Others Are Saying!
  • Question

  • The NOT EXISTS keyword will be true if:


  • Options
  • A. any row in the subquery meets the condition.
  • B. all rows in the subquery fail the condition.
  • C. both of these two conditions are met.
  • D. neither of these two conditions is met.

  • Correct Answer
  • all rows in the subquery fail the condition. 

    • More questions

    • 1. The purpose of timestamping is to avoid the use of locks.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. 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
    • 3. The XML family of standards is very important in database processing today.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. 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
    • 5. Data replication is favored where most process requests are read-only and where the data are relatively static.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. A logical representation of the data for an organization or for a business area is known as an entity-relationship model.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Java and C/C++ are so close that there are no incompatibilities between them. Therefore, a driver is not necessary.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.