database:

1.

2.

3.

4.

5.

A(n) is a query that is embedded (or nested) inside another query. Select one: a. view O b. alias C. operator O d. subquery If a subquery returns list of values, which operator can be used in the outer query predicate? Select one: a. = b. > C. = (SELECT AVG(P_PRICE) FROM PRODUCT) GROUP BY P_CODE; O b. SELECT P_CODE, P_PRICE FROM PRODUCT WHERE P_PRICE >= AVG(P_PRICE); O c. SELECT P_CODE, P_PRICE FROM PRODUCT WHERE P_PRICE >= (SELECT AVG(P_PRICE) FROM PRODUCT); O d. SELECT P_CODE,MAX(AVG(P_PRICE) FROM PRODUCT GROUP BY P_CODE; Rows can be grouped into smaller collections quickly and easily using the clause within the SELECT statement. Select one: O a. GROUP BY O b. WHERE C. FROM O d. JOIN SELECT statement may use subqueries within clauses Select one or more: a. WHERE b. IN c. FROM d. HAVING