Multiple choice technology databases

If the value is null in order to place a value in it the function used is

  1. Substitute( )

  2. Place value ( )

  3. NVL ( )

  4. Place( )
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

NVL is a standard SQL function (Oracle, DB2, PostgreSQL COALESCE similar) that replaces NULL values with a specified substitute value. Syntax is NVL(column, replacement_value) - if column is NULL, it returns replacement_value. Substitute, Place value, and Place are not standard SQL functions for NULL handling.

Keep practicing — related questions