🎴 Flashcard Mode
Oracle Database Fundamentals and SQL
Card1 / 20
Mastered0
Review0
QuestionClick to flip
You are managing constraints on a table in Oracle. Which of the following choices correctly identifies the limitations on check constraints?
AnswerClick to flip back
A
Values must be part of a fixed set defined by create or alter table.
💡 Explanation:
A check constraint restricts the values that can be entered into a column. It must be defined as a fixed condition during table creation or alteration. Check constraints cannot reference external lookup tables, pseudo-columns like SYSDATE, or enforce non-null values directly without specific syntax.