edited by
2,962 views
2 votes
2 votes

An Assertion is predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is:

  1. CREATE ASSERTION 'ASSERTION Name' CHECK 'Predicate'
  2. CREATE ASSERTION 'ASSERTION Name'
  3. CREATE ASSERTION, CHECK 'Predicate'
  4. SELECT ASSERTION
edited by

1 Answer

Best answer
2 votes
2 votes

ans is A  

CREATE ASSERTION 'ASSERTION Name' CHECK 'Predicate' is the proper syntax for applying constraints            

         for example  This SQL statement creates an assertion to demand that there's no more than a single president among the employees:

create assertion AT_MOST_ONE_PRESIDENT as CHECK

(select count(*)    from EMP e   where e.JOB = 'PRESIDENT') <= 1

)

edited by
Answer:

Related questions

1 votes
1 votes
1 answer
1
go_editor asked Jul 30, 2016
2,568 views
Drop Table cannot be used to drop a Table referenced by _______ constraintPrimary keySub keySuper keyForeign keyaa, b and cda and d
2 votes
2 votes
2 answers
3
go_editor asked Jul 30, 2016
15,502 views
For a weak entity set to be meaningful, it must be associated with another entity set in combination with some of their attribute values, is called as:Neighbour SetStrong...