which one is default one while creating a view...?
-
force
-
no force
-
with read only
-
with check option
B
Correct answer
Explanation
When creating a view, the default behavior is NO FORCE - Oracle validates that the view definition is correct and all referenced objects exist. FORCE would create the view even if base tables don't exist (creating a invalid view). WITH READ ONLY and WITH CHECK OPTION are optional constraints, not defaults.