Which best describes an inline view?

Which best describes an inline view?

Which best describes an inline view?

A.
a schema object

B.
a sub query that can contain an ORDER BY clause

C.
another name for a view that contains group functions

D.
a sub query that is part of the FROM clause of another query

Explanation:
a sub query that is part of the FROM clause of another queryIncorrect answer:
A:
is not a schema object
B:
sub query can contain GROUP BY clause as well.
C:
does not necessary contains group functions
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 11-21



Leave a Reply 1

Your email address will not be published. Required fields are marked *


the tuk

the tuk

An inline view is a SELECT statement in the FROM-clause of another SELECT statement. In-line views are commonly used to simplify complex queries by removing join operations and condensing several separate queries into a single query.