Multiple choice technology databases

Can you call a stored function in the constraint of a table ?

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Stored functions cannot be called in table constraints in most database systems including Oracle. Constraints must be deterministic and cannot rely on user-defined functions that may change or have side effects. This restriction ensures data integrity and prevents constraint violations from function changes. Check constraints can only use built-in functions and deterministic expressions.