If you assign a correlation name to one table in a join,

Question $26$ options:

you have to use that name for the table in the query

you have to qualify every column name in the query

you have to qualify all of the column names for that table

you have to assign them to all of the tables in the query

Question $27(1$ point$)$

A subquery can be coded in a WHERE, FROM, SELECT, or $\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ clause.

Question $27$ options:

HAVING

ORDER BY

FROM

GROUP BY

Question $28(1$ point$)$

Each of the following column attributes is a column constraint, except

Question $28$ options:

NOT NULL

DEFAULT

UNIQUE

PRIMARY KEY

Question $29(1$ point$)$

If you want to join all of the rows in the first table of a SELECT statement with just the matched rows in a second table, you use what kind of join?

Question $29$ options:

full outer

left outer

cross

right outer

Question $30(1$ point$)$

To be in first normal form, each cell in the table must contain,

Question $30$ options:

a unique value

non$-$redundant value

a non$-$unique value

a singular, scalar value

Question $31(1$ point$)$

Write an aggregate expression for the number of unique values in the VendorID column

Question $31$ options:

SUM$($VendorID$)$

COUNT$($VendorID$)$

COUNT$($DISTINCT VendorID$)$

AVG$($VendorID$)$

Question $32(1$ point$)$

Saved

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

SELECT VendorState, COUNT$(*)$ AS Column$2$

FROM Vendors

GROUP BY VendorState

HAVING COUNT$(*)>1$;

Question $32$ options:

The names of the vendors in each state

The number of vendors in each state having more than one vendor

The duplicate vendors from each state

The number of vendors in each state