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.
- CREATE AND REPLACE VIEW
- CREATE OR REPLACE VIEW
- CREATE NOR REPLACE VIEW
- 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.