SQL

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

• FROM
• WHERE
• SELECT
• ORDER BY

What is the purpose of  *?

• Selects ALL fields from the table
• Selects only the first field in the table
• Selects the last field in the table
• Shows only the first row in the table

You must always use _____ when using text values

• quotes
• astericks
• exclamation point
• percent signs

What is the correct order of clauses? 

• SELECT, FROM, ORDER BY, WHERE
• SELECT, FROM, WHERE, ORDER BY
• SELECT, WHERE, FROM, ORDER BY
• WHERE, FROM, SELECT, ORDER BY

Use what to separate multiple table names in the FROM clause?

• commas
• periods
• spaces
• semicolons

Which clause allows you to SORT data?

• ORDER BY
• WHERE
• FROM
• HAVING

Use which clause to FILTER data?

• WHERE
• ORDER BY
• FROM
• HAVING

Which word allows you to add more than one filter to a SQL query?

• AND
• BETWEEN
• LIKE
• EQUALS

Which SQL statement is used to update data in a database?

• MODIFY
•  SAVE AS
• UPDATE
• SAVE

Which SQL statement is used to insert new data in a database?

•  ADD NEW
•  ADD RECORD
•  INSERT NEW
•  INSERT INTO