What does the FORCE option for creating a view do?

The correct answer is D. creates a view regardless of whether or not the base tables exist. 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

Creating and Managing Schema Objects

Question

Options

Acreates a view with constraints
Bcreates a view even if the underlying parent table has constraints
Ccreates a view in another schema even if you don't have privileges
Dcreates a view regardless of whether or not the base tables exist

How the community answered

(33 responses)

A
3% (1)
B
9% (3)
C
15% (5)
D
73% (24)

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

Topics

#CREATE VIEW#FORCE option#views#DDL

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice