logo

CuriousTab

CuriousTab

Discussion


Home Database Introduction to SQL Comments

  • Question
  • SQL is a data sublanguage.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Introduction to SQL problems


    Search Results


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

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. 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
    • 3. Most companies keep at least two versions of any database they are using.

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

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. 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
    • 6. SUM, AVG, MIN, and MAX can only be used with numeric columns.

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

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

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

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


    Comments

    There are no comments.

Enter a new Comment