Which three statements are true about views in an Oracle Database? (Choose three.)
Posted: Sun Jun 11, 2023 3:55 pm
Which three statements are true about views in an Oracle Database? (Choose three.)
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.
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.