Concepts and Architecture Question:

Download Job Interview Questions and Answers PDF

Explain what are the Limitations of a CHECK Constraint?

Oracle Architecture and Concepts Interview Question
Oracle Architecture and Concepts Interview Question

Answer:

A check constraint allows you to specify a condition on each row in a table. Note: A check constraint can NOT be defined on a VIEW. The check constraint defined on a table must refer to only columns in that table. It can not refer to columns in other tables. A check constraint can NOT include a SUBQUERY. A check constraint can be defined in either a CREATE TABLE statement or an ALTER TABLE statement.

Download Oracle Architecture and Concepts Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what is difference between UNIQUE constraint and PRIMARY KEY constraint?Explain what is a Synonym?