Which two statements are true regarding views? (Choose two.)
A.
A simple view in which column aliases have been used cannot be updated.
B.
Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.
C.
Rows added through a view are deleted from the table automatically when the view is dropped.
D.
The OR REPLACE option is used to change the definition of an existing view without dropping and re-creating it.
E.
The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.
why option E is wrong??/
Note on WITH CHECK OPTION:
For tables, WITH CHECK OPTION guarantees that inserts and updates result in tables that the defining table subquery can select. For views, WITH CHECK OPTION cannot make this guarantee if:
There is a subquery within the defining query of this view or any view on which this view is based or
INSERT, UPDATE, or DELETE operations are performed using INSTEAD OF triggers.
WITH CHECK OPTION restricts rows that can be displayed not columns.
WITH CHECK OPTION Specify WITH CHECK OPTION to indicate that Oracle Database prohibits any changes to the table or view that would produce rows that are not included in the subquery. When used in the subquery of a DML statement, you can specify this clause in a subquery in the FROM clause but not in subquery in the WHERE clause.
Just beneath, are numerous totally not related websites to ours, nevertheless, they may be certainly worth going over.
always a major fan of linking to bloggers that I adore but dont get a whole lot of link appreciate from
check below, are some completely unrelated web-sites to ours, on the other hand, they’re most trustworthy sources that we use
Wonderful story, reckoned we could combine some unrelated data, nonetheless actually worth taking a look, whoa did one particular understand about Mid East has got a lot more problerms also
one of our visitors recently recommended the following website
please go to the sites we stick to, which includes this a single, because it represents our picks through the web
Here is a great Weblog You might Locate Exciting that we Encourage You
we came across a cool web-site which you could appreciate. Take a appear when you want
Wonderful story, reckoned we could combine some unrelated information, nevertheless genuinely really worth taking a search, whoa did 1 study about Mid East has got additional problerms as well
very few web-sites that come about to be comprehensive below, from our point of view are undoubtedly very well really worth checking out
one of our visitors not long ago suggested the following website
one of our guests a short while ago recommended the following website
very couple of web-sites that take place to become in depth beneath, from our point of view are undoubtedly very well really worth checking out
just beneath, are many absolutely not related sites to ours, nonetheless, they may be certainly really worth going over
I am so grateful for your blog.Much thanks again. Really Cool.