logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Introduction to SQL Comments
  • Question

  • Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • Introduction to SQL problems

    Search Results

    • 1. The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Most companies keep at least two versions of any database they are using.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. You may specify an object identifier with only one unique tag name.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Specifying a key ensures that no two objects belonging to a class have the same value for the key attribute(s).

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. An ordered collection of elements of the same type are called sets.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. SQL is a data sublanguage.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. SUM, AVG, MIN, and MAX can only be used with numeric columns.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. 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
    • 9. The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Indexes can usually be created for both primary and secondary keys.

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