Database

107 Questions | Total Attempts: 535

SettingsSettingsSettings
Database Quizzes & Trivia

.


Questions and Answers
  • 1. 
    A database language enables the user to perform complex queries designed to transform the raw data into useful information.
    • A. 

      True

    • B. 

      False

  • 2. 
    SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words
    • A. 

      True

    • B. 

      False

  • 3. 
    The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.
    • A. 

      True

    • B. 

      False

  • 4. 
    All SQL commands must be issued on a single line.
    • A. 

      True

    • B. 

      False

  • 5. 
    Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command’s components.
    • A. 

      True

    • B. 

      False

  • 6. 
    An alias cannot be used when a table is required to be joined to itself in a recursive query.
    • A. 

      True

    • B. 

      False

  • 7. 
     Comparison operators cannot be used to place restrictions on character-based attributes.
    • A. 

      True

    • B. 

      False

  • 8. 
    11. String comparisons are made from left to right.
    • A. 

      True

    • B. 

      False

  • 9. 
    13. SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
    • A. 

      True

    • B. 

      False

  • 10. 
    14. You cannot insert a row containing a null attribute value using SQL.
    • A. 

      True

    • B. 

      False

  • 11. 
    16. The conditional LIKE must be used in conjunction with wildcard characters.
    • A. 

      True

    • B. 

      False

    • C. 

      Option 3

    • D. 

      Option 4

  • 12. 
    19. The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.
    • A. 

      True

    • B. 

      False

    • C. 

      Option 3

    • D. 

      Option 4

  • 13. 
    21. The SQL data manipulation command HAVING:
    • A. 

      restricts the selection of rows based on a conditional expression.

    • B. 

      restricts the selection of grouped rows based on a condition.

    • C. 

      modifies an attribute’s values in one or more table’s rows.

    • D. 

      groups the selected rows based on one or more attributes.

  • 14. 
    22. The SQL command that allows a user to permanently save data changes is _____.
    • A. 

      INSERT

    • B. 

      SELECT

    • C. 

      COMMIT

    • D. 

      UPDATE

  • 15. 
    23. The _____ command defines a default value for a column when no value is given.
    • A. 

      CHECK

    • B. 

      UNIQUE

    • C. 

      NOT NULL

    • D. 

      DEFAULT

  • 16. 
    24. The _____ command restricts the selection of grouped rows based on a condition.
    • A. 

      DISPLAY

    • B. 

      HAVING

    • C. 

      FROM

    • D. 

      CONVERT

  • 17. 
    25. A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.
    • A. 

      INSERT

    • B. 

      SELECT

    • C. 

      COMMIT

    • D. 

      UPDATE

  • 18. 
    26. A(n) _____ is an alternate name given to a column or table in any SQL statement.
    • A. 

      alias

    • B. 

      data type

    • C. 

      stored function

    • D. 

      trigger

  • 19. 
    30. A(n) _____ join will select only the rows with matching values in the common attribute(s).
    • A. 

      Natural

    • B. 

      Outer

    • C. 

      Full

    • D. 

      Cross

  • 20. 
    36. Which comparison operator indicates a value is not equal?
    • A. 

      <

    • B. 

      <=

    • C. 

      >=

    • D. 

      <>

  • 21. 
    38. The special operator used to check whether an attribute value is within a range of values is _____.
    • A. 

      BETWEEN

    • B. 

      IS NULL

    • C. 

      LIKE 

    • D. 

      IN

  • 22. 
    39. The special operator used to check whether an attribute value ro string pattern is _____.
    • A. 

      BETWEEN

    • B. 

      IS NULL

    • C. 

      LIKE

    • D. 

      IN

  • 23. 
    40. The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____.
    • A. 

      COUNT

    • B. 

      MIN

    • C. 

      MAX

    • D. 

      SUM

  • 24. 
    41. A(n) _____ is a query that is embedded (or nested) inside another query.
    • A. 

      Alias

    • B. 

      operator

    • C. 

      Subquery

    • D. 

      View

  • 25. 
    43. The special operator used to check whether a subquery returns any rows is _____.
    • A. 

      BETWEEN

    • B. 

      EXISTS

    • C. 

      LIKE

    • D. 

      IN

Related Topics
Back to Top Back to top