Please help me solve these multiple choice! Accuracy is important.

Choose a term in brackets to complete the sentence.

1. The ["SELECT", "HAVING", "WHERE", "ORDER BY", "FROM", "GROUP BY"] clause lists the fields that you want returned from your query.

2. The ["HAVING", "WHERE", "FROM", "SELECT", "ORDER BY", "GROUP BY"] clause allows you to filter results based on an aggregation function.

3.

True or False: The following statement would return all records from a hypothetical table named "Impressions".

SELECT *

FROM Impressions;

a.

True

b.

False

4.

In this class, we will focus on using SQL to extract information from a database using queries. However, it is much more powerful than that. Which of the following can SQL do? Select all that apply.

i. Update records already entered in a database.

ii. Define the database structure, including creating tables, fields, relationships, etc.

iii.	Enter new records into a database.

iv.	Change the structure of an existing database, including adding tables, deleting tables, deleting the entire database, etc.

v.	Extract information from a database.