Which three statements are true about performing DML operations on a view with nO INSTEAD OF triggers defined?

发布于 2021-02-23 19:26:05
【多选题】
A Insert statements can always be done on a table through a view.
B The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.
C Delete statements can always be done on a table through a 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 query rows from an underlying table if the table has aPRIMARY KEY and the primary key columns are not referenced in the defining queryof the view
F Views cannot be used to add or modify rows in an underlying table If the defining query of the view contains the DISTINCT keyword

查看更多

关注者
0
被浏览
132
  • 体验AI问答!更聪明、超智能!
  • 一款基于GPT的超级AI助手,可以对话、创作、写文案!
1 个回答

撰写答案

请登录后再发布答案,点击登录

发布
问题

手机
浏览

扫码手机浏览

分享
好友

在线
客服