Multiple choice technology databases

Which is valid Oracle constraint type ?

  1. CASCADE

  2. CONSTANT

  3. CHECK

  4. NONUNIQUE
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

CHECK is a valid Oracle constraint that enforces domain integrity by limiting values to a Boolean condition. CASCADE is an action (not a constraint type), CONSTANT isn't an Oracle constraint, and NONUNIQUE isn't a valid constraint (though it describes an index type). Oracle supports PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, and CHECK constraints.

Keep practicing — related questions