Question 10717 – GATE 2007-IT
May 3, 2024Question 10710 – GATE 2007-IT
May 3, 2024Database-Management-System
| Question 639 |
An Assertion is a predicate expressing a condition we wish database to always satisfy.
The correct syntax for Assertion is :
The correct syntax for Assertion is :
| CREATE ASSERTION ‘ASSERTION Name’ CHECK ‘Predicate’ | |
| CREATE ASSERTION ‘ASSERTION Name’ | |
| CREATE ASSERTION, CHECK Predicate | |
| SELECT ASSERTION |
Question 639 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
Correct Answer: A
Question 639 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
Subscribe
Login
0 Comments