Oracle Database Administration I — Question 161

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

Answer options

• A. Rows inserted into a table using a view are retained in the table if the view is dropped.
• B. Views can join tables only if they belong to the same schema.
• C. Views have no object number.
• D. Views have no segment.
• E. A SELECT statement cannot contain a WHERE clause when querying a view containing a WHERE clause in its defining query.
• F. A view can be created that refers to a non-existent table in its defining query.

Correct answer: A, D, F

Explanation

Option A is correct because rows inserted via a view remain in the underlying table even if the view is dropped. Option D is accurate since views do not consume storage like segments do; they are simply stored queries. Option F is also correct because Oracle allows the creation of views that reference non-existent tables, which can be useful in certain scenarios like defining a view for future use. Options B, C, and E are incorrect as they misrepresent the capabilities and characteristics of views in Oracle Database.