logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ SQL for Database Construction See What Others Are Saying!
  • Question

  • Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:


  • Options
  • A. GROUP BY.
  • B. WHERE.
  • C. ORDER BY.
  • D. FROM.

  • Correct Answer
  • ORDER BY. 

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