A SELECT statement that includes aggregate functions is often called a$/$an $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ query.

Question $1$ options:

action

summary

none of the above

compound

Question $2(1$ point$)$

SELECT VendorName AS Vendor, InvoiceDate AS Date

FROM Vendors AS c JOIN Invoices AS i

on v$.$VendorID$=$i$.$VendorID

The name $$v$$ is known as a$?$

Question $2$ options:

table alias

both b and c

placeholder

correlation name

Question $3(1$ point$)$

A full outer join includes rows that satisfy the join condition, plus

Question $3$ options:

rows in the right table that don$$t satisfy the join condition

rows in both tables that don$$t satisfy the join condition

the Cartesian product of the two tables

rows in the left table that don$$t satisfy the join condition

Question $4(1$ point$)$

To be in third normal form,

Question $4$ options:

each non$-$key column must depend only on the primary key

all of the above

the non$-$key columns must not contain repeating values

each non$-$key column must depend of the entire primary key

Question $5(1$ point$)$

When you code a union that combines two result sets, which of the following is not true?

Question $5$ options:

Each result set must have the same number of columns.

The corresponding columns in the result sets must have compatible data types.

The result sets must be derived from different tables.

The result sets may or may not have any duplicate rows.

Question $6(1$ point$)$

A subquery is a$/$an $\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ statement that$$s coded within another SQL statement.

Question $6$ options:

ORDER BY

WHERE

FROM

SELECT

Question $7(1$ point$)$

A search condition in the $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ clause is applied before the rows are grouped while a search condition in the $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ clause isn$$t applied until after the grouping.

Question $7$ options:

HAVING, WHERE

WHERE, FROM

WHERE, HAVING

FROM, WHERE

Question $8(1$ point$)$

Expressions coded in the WHERE clause

Question $8$ options:

can use aggregate search conditions but can$$t use non$-$aggregate search conditions

must refer to columns in the SELECT clause

can use either aggregate search conditions or non$-$aggregate search conditions

can use non$-$aggregate search conditions but can$$t use aggregate search conditions

Question $9(1$ point$)$

SELECT VendorName, InvoiceNumber

FROM Invoices LEFT JOIN Vendors

ON Invoices.VendorID $=$ Vendors.VendorID;

If the LEFT keyword is replaced with the FULL keyword, the total number of rows that are returned must equal

Question $9$ options:

none of the above

the number of rows in the Invoices table plus the number of rows in the Vendors table

the number of rows in the Invoices table

the number of rows in the Vendors table

Question $10(1$ point$)$

When you use the implicit syntax for coding inner joins, the join conditions are coded in which clause?

Question $10$ options:

SELECT

FROM

ORDER BY

WHERE

Question $11(1$ point$)$

By default, all duplicate values are included in the aggregate calculation, unless you specify which keyword?

Question $11$ options:

DISTINCT

ORDER BY

AVG

GROUP BY

Question $12(1$ point$)$

SELECT VendorName AS Vendor, InvoiceDate AS Date

FROM Vendors AS c JOIN Invoices AS i

on v$.$VendorID$=$i$.$VendorID

The column name for the second column in the result set will be$?$

Question $12$ options:

VendorName

Date

VendorID

Vendor

Question $13(1$ point$)$

Subqueries can be $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ within other subqueries.

Question $13$ options:

nested

grandfathered

restated

joined

Question $14(1$ point$)$

SELECT VendorName, COUNT$(*)$ AS NumberOfInvoices,

MAX$($InvoiceTotal $-$ PaymentTotal $-$ CreditTotal$)$ AS BalanceDue

FROM Vendors JOIN Invoices ON Vendors.VendorID $=$ Invoices.VendorID

WHERE InvoiceTotal $-$ PaymentTotal $-$ CreditTotal $>$

$($SELECT AVG$($InvoiceTotal $-$ PaymentTotal $-$ CreditTotal$)$

FROM Invoices$)$

GROUP BY VendorName

ORDER BY BalanceDue DESC;

When this query is executed, the result set will contain

Question $14$ options:

one row for the invoice with the largest balance due for each vendor

one row for each vendor that shows the largest balance due for any of the vendor$$s invoices, but only if that balance due is larger than the average balance due for all invoices

one row for each invoice that has a larger balance due than the average balance due for all invoices

one row for each invoice for each vendor that has a larger balance due than the average balance due for all invoices

Question $15(1$ point$)$

When you code a union with the INTERSECT keyword to combine two result sets, the union

Question $15$ options:

excludes rows from the second result set if they also occur in the first result set

includes all rows that occur in both result sets if the primary keys are the same

excludes rows from the first result set if they also occur in the second result set

includes only rows that occur in both result sets

Question $16(1$ point$)$

In mo