What does the FORCE option for creating a view do?
A.
creates a view with constraints
B.
creates a view even if the underlying parent table has constraints
C.
creates a view in another schema even if you don’t have privileges
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
D