Question $8(1$ point$)$

A SELECT expression that is embedded within one of the clauses of a SELECT statement is a$($n$)\_\_\_\_\_\_\_\_\_\_\_\_.$

Question $8$ options:

subquery

embedded SELECT

sub$-$SELECT

embedded query

Question $9(1$ point$)$

How many tables may be included with a join?

Question $9$ options:

Two

All of the above

One

Three

Question $10(1$ point$)$

The SQL standard provides a set of $\_\_\_\_\_\_\_\_\_\_\_\_\_$ functions that enable you to calculate a single value from the rows in a result set or from the values returned by a value expression.

Question $10$ options:

aggregate

calculation

mathematical

summary

Question $11(1$ point$)$

Which set operation is used to find the common elements in two or more different sets?

Question $11$ options:

Intersection

Union

Difference

Question $12(1$ point$)$

What clause follows the second table in the JOIN and tells the database system how to perform the JOIN?

Question $12$ options:

WHERE

ON

ON or USING

USING

Question $13(1$ point$)$

In what clause can subqueries be used?

Question $13$ options:

SELECT

FROM

WHERE

All of these clauses