Which three statements are true about views in an Oracle Database? (Choose three.)
Which three statements are true about views in an Oracle Database? (Choose three.)
Views in an Oracle Database have no segment as they do not occupy physical storage; they are simply stored queries. A view can be created that refers to a non-existent table using the FORCE option in the CREATE VIEW statement; this means the view will be created but will throw an error when queried. Rows inserted into a table using a view are retained in the table even if the view is subsequently dropped, as views are just a way to look at the data and not a data storage mechanism themselves.
I don't understand the answer E. How can views refers to non-existent table ?
You can create view to non-existent table or table with invalid columns by using FORCE option in the CREATE VIEW command. When you query the data from the view you will get an error
select object_id, object_name from user_objects In this table you will also find views so they do have an object number. Views have no segment since they don't take up physical space
what that is mean no segment about view
segment mean physical storage ...