Which three statements are true about views in an Oracle Database? (Choose three.)

The correct answer is B. A view can be created that refers to a non-existent table in its defining query. C. Views have no object number. E. Rows inserted into a table using a view are retained in the table if the view is dropped. https://docs.oracle.com/cd/B28359_01/server.111/b28286/ statements_8004.htm#SQLRF01504 https://community.oracle.com/thread/2178948

Creating Other Schema Objects

Question

Options

AViews can join tables only if they belong to the same schema.
BA view can be created that refers to a non-existent table in its defining query.
CViews have no object number.
DViews have no segment.
ERows inserted into a table using a view are retained in the table if the view is dropped.
FA SELECT statement cannot contain a WHERE clause when querying a view containing a

How the community answered

(42 responses)

A
14% (6)
B
76% (32)
D
5% (2)
F
5% (2)

Explanation

https://docs.oracle.com/cd/B28359_01/server.111/b28286/ statements_8004.htm#SQLRF01504 https://community.oracle.com/thread/2178948

Topics

#views#schema objects#view properties#DDL

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice