ocp考试资料群:569933648 验证码:ocp ocp 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(486)
分类: oracle
2021-04-08 13:47:15
本套题库是ocp考试中的071(中文版)试题,由cuug整理。
18、请选择最佳答案。
查看以下成功执行的语句:
create view emp80 as
select *
from employees
where department_id = 80
with check option;
哪条语句将违反check约束条件?
a) select *
from emp80
where department_id = 90;
b) select
from emp80
where department_id = 80;
c) delete from emp80
where department_id = 90;
d) update emp80
set department_id = 90
where department_id = 80;
上一篇:
下一篇: