Which two statements are true about views? (Choose two.)
Which two statements are true about views? (Choose two.)
The WITH CHECK clause in a view ensures that any data inserted or updated through the view adheres to certain conditions, thereby preventing certain rows from being updated or inserted in the underlying table. Views can be updated without the need to re-grant privileges on the view, meaning that once privileges are granted, they remain valid even if the view is altered. This makes both statements about the WITH CHECK clause and updating views without needing to re-grant privileges true.
AD is correct
C and E also correct?
C - Views can be indexed. FALSE Only materialised views can be indexed: https://asktom.oracle.com/pls/apex/asktom.search?tag=indexes-on-view E - Tables in the defining query of a view must always exist in order to create the view. FALSE: Usually, you create a new view based on existing tables. However, sometimes, you may want to create a view based on the tables that you will create later or the tables that you don’t have sufficient privileges to access at the time of creating the view. In these cases, you can use the FORCE option. https://www.oracletutorial.com/oracle-view/oracle-create-view/