设为首页收藏本站language→→ 语言切换

鸿鹄论坛

 找回密码
 论坛注册

QQ登录

先注册再绑定QQ

查看: 824|回复: 0
收起左侧

[求助] 帮忙看道题目

[复制链接]
发表于 2019-10-22 15:23:36 | 显示全部楼层 |阅读模式
Which three statements are true about performing Data Manipulation Language(DML)operations on a view in a Oracle Database?
A.Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains aggregating functions.

B.Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL costraints lacking default values which are not referenced in the column.

C.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 defing query.

D.Insert statements can always be done no a table through a view.

E.Views cannot be used to add or modify rows in an underlying table if the defing query of the view contains the DISTINCT keyword.

F.The WITH CHECK clauses has no effect when deleting rows from the underlying table through the view.

您需要登录后才可以回帖 登录 | 论坛注册

本版积分规则

QQ|Archiver|手机版|小黑屋|sitemap|鸿鹄论坛 ( 京ICP备14027439号 )  

GMT+8, 2024-4-19 08:17 , Processed in 0.052364 second(s), 8 queries , Redis On.  

  Powered by Discuz!

  © 2001-2024 HH010.COM

快速回复 返回顶部 返回列表