SQL-Quiz

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

Return only the customers who have ER anywhere in their last name. 

• last_name LIKE "%er%"
• last_name = "%er"
• last_name = "%er%"
• last_name LIKE "%er"

To find the total dollar value of sales, use which? 

• SUM
• COUNT
• MAX
• MIN

AVG, COUNT, MAX, MIN and SUM are known as what?

• Aggregate functions
• Wildcard filters
• Subqueries
• Calculated field

Which clause allows you to SORT data?

• ORDER BY
• WHERE
• FROM
• HAVING

Use which clause to FILTER data?

• WHERE
• ORDER BY
• FROM
• HAVING

What represents no value? 

• NULL
• " "
• 0
• N/A

To return strings that match a wildcard value, use which word in your filter?

• LIKE
• EQUALS
• BETWEEN
• SEARCH

What does "SQL" stand for?

• Structured Question Language

• Structured Query Language

• Simple Query Language

• Simple Question Language

Tags

CCSS.RI.11-12.4

CCSS.RI.7.4

CCSS.RI.8.4

CCSS.RI.9-10.4

CCSS.RI.9-10.4

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

• And

• Maybe

• If

• Or