Multiple choice technology databases

which is correct regarding CHECK CONSTRAINT?

  1. check (salary>(select salary from emp where uid=10))

  2. check (salary >(select salary from emp where rowid=10 ))

  3. check (salary >2568)

  4. check (salary >select salary from emp where dno=10)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

CHECK constraints cannot contain subqueries or references to other rows - they must evaluate to a boolean condition using only the current row's values. Option C uses a literal value (2568), making it valid. Options A, B, and D use subqueries, which are not allowed.

Keep practicing — related questions