logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Introduction to SQL Comments
  • Question

  • The keyword LIKE can be used in a WHERE clause to refer to a range of values.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • Introduction to SQL problems

    Search Results

    • 1. SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. The condition in a WHERE clause can refer to only one value.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. A dynamic view is one whose contents materialize when referenced.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Indexes may be created or dropped at any time.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. SQL is a programming language.

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