QUESTION 18 Which view type is based on a subquery that references only one tabl
ID: 3899945 • Letter: Q
Question
QUESTION 18 Which view type is based on a subquery that references only one table and does not include group functions, expressions, or GROUP BY causes?
a. Simple View
b. Inline View
c. Complex View
d. Materialized View
QUESTION 19 You can nest subqueries inside all EXCEPT _______ clauses of other subqueries.
a. FROM
b. WHERE
c. HAVING
d. DISTINCT
QUESTION 20 Which of the following are not a main type of single-row functions:
a. description functions
b. conversion functions
c. numeric functions
d. regular expression functions
Explanation / Answer
Following is the answer:
Which view type is based on a subquery that references only one table and does not include group functions, expressions, or GROUP BY causes?
Ans: a. Simple View
Complex view
A view based on a subquery that retrieves or derives data from one or more tables and can contain functions or grouped data
Inline View
A subquery used in the FROM clause of a SELECT statement to create a "temporary" table that can be references by the outer query's SELECT and WHERE clauses
Materialized View
a view that replicates data by physically storing the view query's result
QUESTION 19 You can nest subqueries inside all EXCEPT _______ clauses of other subqueries.
a. FROM
QUESTION 20 Which of the following are not a main type of single-row functions:
a. description functions