Multiple choice technology databases

What does “REPLACE” indicate in creating procedures?

  1. An existing will be dropped and it will be replaced by the new version.

  2. An existing will be dropped and it will not be replaced by the new version.

  3. No change will occur

  4. There is no such option available in creating procedures.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL/PL-SQL DDL, the REPLACE clause (as in CREATE OR REPLACE) indicates that if a schema object with the specified name already exists, it is dropped and replaced with the new definition. If it does not exist, it is created.

Keep practicing — related questions