When you code a DELETE statement for one or more rows, the _________________ clause specifies which row or rows are to be deleted.
To retrieve or update the data in a database, the client sen…
To retrieve or update the data in a database, the client sends a/an ________________ to the database.
If two tables have a many-to-many relationship, you need to…
If two tables have a many-to-many relationship, you need to define a/an _____________ table that relates their records.
When you use the CREATE TABLE statement to create a table, y…
When you use the CREATE TABLE statement to create a table, you can also define the attributes and _________________________ for the columns of the table.
The ____________________ data types are used to store whole…
The ____________________ data types are used to store whole numbers.
Write an aggregate expression to calculate the average value…
Write an aggregate expression to calculate the average value of the InvoiceTotal column, excluding null values:_________________________.
The ________________ clause of the SELECT statement names th…
The ________________ clause of the SELECT statement names the table that contains the data to be retrieved.
When coding a query with two columns in the GROUP BY clause,…
When coding a query with two columns in the GROUP BY clause, you can insert a summary row for each major group by coding the ___________________________ operator.
SQL statements that define the tables in a database are refe…
SQL statements that define the tables in a database are referred to as _______________ statements.
A database __________________ is a schematic drawing that sh…
A database __________________ is a schematic drawing that shows you the relationships between the tables you’re working with.