Which three statements are true about performing DML operations on a view with no INSTEAD OF triggers defined? (Choose three.)
A.
Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.
B.
Delete statements can always be done on a table through a view.
C.
The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.
D.
Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.
E.
Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword,
F.
Insert statements can always be done on a table through a view.
According to some forums I have checked, they suggest: C D F
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
salander71
3 months, 1 week agoArslanAltaf
8 months, 2 weeks agoydisconzi
10 months agoCMjer
1 year, 7 months agoSathitest071
1 year, 9 months agoOrakol
1 year, 10 months ago