Question 10717 – GATE 2007-IT
May 3, 2024Question 10710 – GATE 2007-IT
May 3, 2024Question 3819 – SQL
An Assertion is a predicate expressing a condition we wish database to always satisfy.
The correct syntax for Assertion is :
Correct Answer: A
Question 86 Explanation:
An Assertion is a condition that we wish the database to always satisfy. Domain constraints, functional dependency and referential integrity are special forms of assertion.
The syntax of Assertion in SQL is:
create assertion assertion-name check predicate
The syntax of Assertion in SQL is:
create assertion assertion-name check predicate
CREATE ASSERTION ‘ASSERTION Name’ CHECK ‘Predicate’
CREATE ASSERTION ‘ASSERTION Name’
CREATE ASSERTION, CHECK Predicate
SELECT ASSERTION
Subscribe
Login
0 Comments