The OR REPLACE clause is not required if ____.
A) another view does not exist with the same name
B) the view is not based on a group function
C) the view does not contain data from more than one table
D) the CREATE command does not specify the WITH CHECK OPTION option

Question

The OR REPLACE clause is not required if ____.​
A) ​another view does not exist with the same name
B) ​the view is not based on a group function
C) ​the view does not contain data from more than one table
D) ​the CREATE command does not specify the WITH CHECK OPTION option

Quizplus · Accepted Answer

The OR REPLACE clause is used in the CREATE VIEW statement to replace an existing view with the same name. Therefore, if another view does not exist with the same name, the OR REPLACE clause is not required.

The OR REPLACE Clause Is Not Required If ____