What does the FORCE option for creating a view do?

What does the FORCE option for creating a view do?

What does the FORCE option for creating a view do?

A.
creates a view with constraints

B.
creates a view in another schema even if you don’t have privileges

C.
creates a view even if the underlying parent table has constraints

D.
creates a view regardless of whether or not the base tables exist

Explanation:

:
create a view regardless of whether or not the base tables exist.
Incorrect answer :
A the option is not valid
B the option is not valid
C the option is not valid
Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 11-3



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Aye Chan Aung Thwin

Aye Chan Aung Thwin

The answer is D.