Home / CSE / Database System 2 - CS :: Introduction to SQL

CSE :: Database System 2 - CS

  1. The result of every SQL query is a table.

  2. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

  4. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. SUM, AVG, MIN, and MAX can only be used with numeric columns.

  6. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Most companies keep at least two versions of any database they are using.

  8. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

  10. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Indexes may be created or dropped at any time.

  12. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  14. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. ORDER BY can be combined with the SELECT statements.

  16. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

  18. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

  20. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum