Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
When you use this option to create a view with a where
condition, the system wont allow to perform any action which
will invalidate the definition of the view.
ex:
create view test
as
select firstname,lastname from Employees where sal<10000
with Check option
If this returns 10 rows when you are updating the view if
any action is being done which updates the sal so that the
view returns lesser number of records is not allowed.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are locks in sql?
Distinguish between nested subquery and correlated subquery?
How are the unique and primary key constraints different?
What is view in sql?
 Explain what is sql override for a source taLle in a mapping?
What are sql server functions?
Define right outer join in sql server joins?
What are views used for?
What are the properties and different types of sub-queries?
How to get the definition of a user defined function back?
What are data files?
What is the stuff and how does it differ from the replace function?
What is the parse query button used for?
What the different topologies in which replication can be configured?
How we can compare two database data?
