logo

CuriousTab

CuriousTab

Discussion


Home Database Introduction to SQL See What Others Are Saying!
  • Question
  • To define what columns should be displayed in an SQL SELECT statement:


  • Options
  • A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
  • B. use USING to name the source table(s) and list the columns to be shown after SELECT.
  • C. use SELECT to name the source table(s) and list the columns to be shown after USING.
  • D. use USING to name the source table(s) and list the columns to be shown after WHERE.

  • Correct Answer
  • use FROM to name the source table(s) and list the columns to be shown after SELECT. 


  • More questions

    • 1. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. The source of the data is sometimes called the system of record.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. All primary keys are required.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. Entities use identifiers while tables use keys.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. SOAP is now just a name, not an acronym.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. A function returns one value and has only output parameters.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Multiple and binary relationships are the same thing.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. Output reports should be included as part of an ERD.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. It is not easy to build a database correctly the first time.

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


    Comments

    There are no comments.

Enter a new Comment