If you want to create a view based upon a table or tables that do not yet exist,or are currently unavailable (e.g. ,off-line),what keyword can you use to avoid receiving an error message?
A) FORCE
B) NOERROR
C) OVERRIDE
D) none of the above

Question

If you want to create a view based upon a table or tables that do not yet exist,or are currently unavailable (e.g. ,off-line),what keyword can you use to avoid receiving an error message?​
A) ​FORCE
B) ​NOERROR
C) ​OVERRIDE
D) ​none of the above

Quizplus · Accepted Answer

The FORCE keyword allows the creation of a view even if the underlying base tables do not exist or are currently unavailable. This is useful in situations where the view needs to be created before the tables it depends on, or when working with tables that might be offline temporarily.

If You Want to Create a View Based Upon a Table