Multiple choice technology databases

What does the REPLACE option indicate while used in creating functions?

  1. If the function exists, it will be dropped and replaced with the new version created by the statement.

  2. If the function does not exist, it will create a new one.

  3. No action will be taken

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

The REPLACE clause tells the database to drop an existing function of the same name and create the new definition instead of raising an error. This is precisely what the stored answer describes, so it is correct.

Keep practicing — related questions