Register

Assertions in SQL-Self Doubt

259 views
0 votes
0 votes
Whenever Assertions are created, the predicate that the Assertion specifies must hold true at the time of assertion creation.

Now Whenever we make changes to any table in the database, do all the assertions present in the database are checked simultaneously after that change?

I mean to ask whenever there is any change in the database, then all Assertions are checked and executed (Even when some assertions are not related to the tables which have been changed)?
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
aditi19 asked Nov 25, 2018
379 views
Assertions
what is assertions in SQL?
what is assertions in SQL?
User Avatar
0 votes
0 votes
0 answers
2
kd..... asked Apr 30, 2019
688 views
Self Doubt on SQL AND operator
Here why does the 5th query select * from employees natural join works_on where PID = 'X' AND PID='Y'; is not working The queries are The output are
Here why does the 5th query select * from employees natural join works_on where PID = 'X' AND PID='Y'; is not workingThe queries are The output are
User Avatar
0 votes
0 votes
1 answer
3
Shamim Ahmed asked Nov 12, 2018
416 views
SQL self doubt
In this question:- https://gateoverflow.in/8225/gate2015-1-27 I am not understanding how the query is returning 2 . I think DISTINCT must be there to give the correct answer. Can you give some logical explanation?
In this question:-https://gateoverflow.in/8225/gate2015-1-27I am not understanding how the query is returning 2 .I think DISTINCT must be there to give the correct answer...
User Avatar
Link Copied!