Multiple choice technology databases

reference to sysdate,nextval,currval is allowed on constraint definition

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Oracle allows reference to SYSDATE, NEXTVAL, and CURRVAL in constraint definitions. These pseudocolumns and sequence functions can be used in DEFAULT, CHECK constraints and other constraint definitions. For example, a DEFAULT SYSDATE constraint or a check constraint using CURRVAL is valid.

Keep practicing — related questions