Oracle Database SQL — Question 160

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

Answer options

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

Correct answer: B, E, F

Explanation

The correct answers B, E, and F are true about views in Oracle Database. Option B is correct because views do not store data themselves and thus have no segments. Option E is valid as views can be defined on tables that do not exist at the time of their creation. Option F is true because the data inserted through a view remains in the underlying table even if the view is removed. The other options are incorrect as A implies a restriction that does not exist, C is incorrect because views have an object number, and D is false since views can join tables across different schemas if properly referenced.