Question

Which of the following is the right syntax for the assertion?

(a) Create assertion ‘assertion-name’ check ‘predicate’;

(b) Create assertion check ‘predicate’ ‘assertion-name’;

(c) Create assertions ‘predicates’;

(d) All of the mentioned

The question was asked in an international level competition.

My question is from Integrity Constraints in chapter SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Right option is (a) Create assertion ‘assertion-name’ check ‘predicate’;

The best I can explain: None.