Stay organized with collections Save and categorize content based on your preferences.

Introduction to SQL

  1. Which of the following statements are true about relational databases and SQLite?

    Choose as many answers as you see fit.

  2. It is optional to end a SQL statement with a semicolon.
  3. If you want to calculate the sum of all values for a database column, what do you use?
  4. Which SELECT statement returns the number of unique email addresses for messages in the spam folder?
  5. The SQL statement SELECT * FROM contacts WHERE name LIKE '%Milton' returns all rows where the value of the name column begins with Milton.
  6. Which of the following statements are true about GROUP BY and ORDER BY?

    Choose as many answers as you see fit.

  7. The WHERE condition NOT read = false and the WHERE condition read != true are equivalent.
  8. The LIMIT clause LIMIT 30 SKIP 60 returns:
  9. An UPDATE statement uses a ___ clause to assign values for columns.
  10. UPDATE and DELETE statements can include a WHERE clause and can affect multiple rows.