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