Exam 1z0-071 topic 1 question 94 discussion

Actual exam question from Oracle's 1z0-071

Question #: 94
Topic #: 1

[All 1z0-071 Questions]

Which two statements are true about views? (Choose two.)

A. The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view.
B. The WITH CHECK clause prevents certain rows from being displayed when querying the view.
C. Views can be indexed.
D. Views can be updated without the need to re-grant privileges on the view.
E. Tables in the defining query of a view must always exist in order to create the view.

Show Suggested Answer

Suggested Answer: AD 🗳️

by ESZ at March 27, 2023, 1:22 p.m.

Comments

Submit Cancel

826cb95

2 months ago

Selected Answer: AD

Why E is wrong? Because - * Per official Oracle documentation, you can use 'FORCE' keyword to create view over table that doesn't exists when needed. https://www.oracletutorial.com/oracle-view/oracle-create-view/

upvoted 1 times

...

lucemqy

7 months, 2 weeks ago

Selected Answer: AD

AD is correct

upvoted 1 times

...

ESZ

1 year, 3 months ago

C and E also correct?

upvoted 1 times

CMjer

1 year, 1 month ago

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/

upvoted 1 times

...