题库
  • 题库
  • 考试

移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

首页 / 其他类/ CMS专题/ / 当前试题

单选题

分享题目

A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?（）

发布日期：2020-04-10

A view is created with the following statement:CRE...
A

Any row inserted or updated through view V1 must meet the condition that col4 > 1000.

B

From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked.

C

At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected.

D

Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.

标签： view created statement create view

查看答案

题王网让考试变得更简单

扫码关注题王，更多免费功能准备上线！

此试题出现在

CMS专题

CMS专题

去刷题

其他考试

环保气象安全技能考试 微生物检验技术中级职称 儿科主治医师 卫生检验技术（技师） 网络设备调试员 环保知识生态建设知识竞赛 思科认证考试 神经电生理脑电图技术(师) 中级审计师 大学生村官考试
热门试题热门资讯 相关试题

膨胀土的工程特性有（）

顶浪航行时影响船舶纵摇与垂荡的幅度取决于：（） Ⅰ波长与船长之比Ⅱ船速的大小Ⅲ自摇荡周期与遭遇周期之比

《贞观政要》中的“以铜为镜，可以正衣冠；以古为镜，可以知兴替；以人为镜，可以明得失。”这段富含哲理的名言给我们的启示是（  ）。①善于听取他人意见，是促进认识发展的重要途径②避免重犯他人错误，才能使自己在生活中不犯错误③人们历史活动的思想动机决定人类社会历史发展④自觉总结历史经验教训，有利于把握社会发展规律

草坪建植前，对于PH>8.5的土壤进行改良不能使用（　）

患者，男，65岁，小便不通或点滴不爽月余，兼排出无力，面色白，神气怯弱，畏寒肢冷，舌淡，苔腻白，脉沉细弱。本病选用方剂为（）。

注册商标有效期满，需要继续使用的，应当最迟在期满后（  ）申请续展注册，否则将注销其注册商标。*

检验教学效果时，通过受训者在训练中所提出的作品或成果进行分析来评价受训者掌握情况的方法称为（）。

改善是指不满足于（），充分发挥聪明才智和创造力，不断追求更高的附加价值，发现问题、解决问题的过程。

王某因不服区公安分局行政拘留10天的处罚申请复议，市公安局认为处罚过轻，遂改为行政拘留15天的处罚，王某以市公安局为被告提起行政诉讼。对王某的诉讼请求，法院应当如何处理？（　　）

在系统提示符号输入vi及文件名称后，就进入vi全屏幕编辑画面，进入vi之后，是处于（）模式，要切换到（）模式才能够输入文字。

暂无相关推荐~

A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, co...

A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, co...

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES,D...

Derek has created a view in the products.nsf database. Derek wants the markup co...

You created a view called EMP_DEPT_VU that contains three columns from the EMPLO...

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, ...

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, ...

 Derek has created a view in the sales.nsf db. Derek wants the sales value colum...

You created a view called EMP_DEPT_VU that contains three columns from the EMPLO...

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, ...