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 Defaults feature in Oracle allows you to explicitly specify default column values. You can use explicit defaults in INSERT statements (to use default value instead of NULL or specified value) and in UPDATE statements (to reset a column to its default using DEFAULT keyword). This provides explicit control over default value application in both INSERT and UPDATE operations.

Keep practicing — related questions