Q159 Which two statements are true about views?
- A) Views can be updated without the need to re-grant privileges on the view
- B) Views can be indexed
- C) A view must only refer to tables in its defining query
- D) The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view
- E) The WITH CHECK clause prevents certain rows from being displayed when querying the view
Answer: A,D