logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Introduction to SQL See What Others Are Saying!
  • Question

  • The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • More questions

    • 1. A updatable view has its own data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Well-structured relations encourage anomalies of data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Entity instances are associated by relationship classes.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Composite identifiers consist of two or more attributes.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Queries that do full table scans should be avoided.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. The World Wide Web Consortium (W3C) is the chief standards body for HTTP and HTML.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. MySQL is pronounced "my See-quel."

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. The data model produced from the reverse engineering process does not include intersection table data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Three types of triggers are: BEFORE, AFTER and EXCEPTION.

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