In most cases, the join condition of an inner join compares the primary key of one table to the $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ key of another table.

Question $16$ options:

primary

foreign

SELECT

unique

Question $17(1$ point$)$

Expressions coded in the HAVING clause

Question $17$ options:

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

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

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

can refer to any column in the base tables

Question $18(1$ point$)$

What kind of constraint enforces referential integrity between tables?

Question $18$ options:

none of the above

both a and b

reference constraint

foreign key constraint

Question $19(1$ point$)$

If you omit both NULL and NOT NULL from the list of column attributes in a CREATE TABLE statement, which is the default setting?

Question $19$ options:

This will throw an error

NOT NULL

none of the above

NULL

Question $20(1$ point$)$

In a join, column names only need to be qualified where?

Question $20$ options:

when the code is confusing

in outer joins

in inner joins

when the same names are used in both tables

Question $21(1$ point$)$

What kind of constraint limits the values that can be stored in a column?

Question $21$ options:

values constraint

integrity constraint

size constraint

check constraint

Question $22(1$ point$)$

The six clauses of the SELECT statement must be coded in the following order:

Question $22$ options:

SELECT, FROM, GROUP BY$,$ HAVING, WHERE, ORDER BY

SELECT, FROM, WHERE, GROUP BY$,$ HAVING, ORDER BY

SELECT, FROM, WHERE, ORDER BY$,$ GROUP BY$,$ HAVING

SELECT, FROM, ORDER BY$,$ WHERE, GROUP BY$,$ HAVING

Question $23(1$ point$)$

SELECT VendorName, InvoiceNumber

FROM Invoices LEFT JOIN Vendors

ON Invoices.VendorID $=$ Vendors.VendorID;

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

Question $23$ options:

the number of rows in the Invoices table

the number of rows in the Vendors table

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

none of the above

Question $24(1$ point$)$

Which of the statements below best describes the result set returned by this SELECT statement?

SELECT VendorID,

SUM$($InvoiceTotal $-$ PaymentTotal $-$ CreditTotal$)$ AS Column$2$

FROM Invoices

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

GROUP BY VendorID;

Question $24$ options:

The total of paid invoices for each VendorID

The total amount invoiced by each VendorID

The unpaid balance for each invoice

The total unpaid balance due for each VendorID

Question $25(1$ point$)$

Write an aggregate expression to find the latest date in the InvoiceDate column

Question $25$ options:

SUM$($InvoiceDate$)$

COUNT$($InvoiceDate$)$

MIN$($InvoiceDate$)$

MAX$($InvoiceDate$)$