Home » MCQs » Oracle MCQs » Oracle Views MCQs

To modify an Oracle VIEW definition without dropping it, use the ____ statement

6. To modify an Oracle VIEW definition without dropping it, use the ____ statement.

1. CREATE AND REPLACE VIEW
2. CREATE OR REPLACE VIEW
3. CREATE NOR REPLACE VIEW
4. CREATE XOR REPLACE VIEW

Answer: B) CREATE OR REPLACE VIEW

Explanation:

To modify an Oracle VIEW definition without dropping it, use the CREATE OR REPLACE VIEW statement.