Which three statements are true about views in an Oracle Database?
A. Views can join tables only if they belong to the same schema.
B. A view can be created that refers to a non-existent table in its defining query.
C. Views have no object number.
D. Views have no segment.
E. Rows inserted into a table using a view are retained in the table if the view is dropped.
F. A SELECT statement cannot contain a WHERE clause when querying a view containing a WHERE clause in its defining query.
BDE is answer
BDE
ABE