Multiple choice technology databases

Explicit Defaults can be used in

  1. INSERT statement

  2. UPDATE statement

  3. Both of the Above

  4. None of the Above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Explicit DEFAULT values can be specified in both INSERT and UPDATE statements to force a column to use its defined default when the supplied value is omitted or set to DEFAULT. Therefore the option indicating both statements is correct; the others omit one context.

Keep practicing — related questions