OCP 071中文考試題庫(cuug內部資料)第18題
最新學訊:近期OCP認證正在報名中,因考試人員較多請盡快報名獲取最近考試時間,報名費用請聯系在線老師,甲骨文官方認證,報名從速!
我要咨詢OCP 071中文考試題庫(cuug內部資料)第18題
本套題庫是OCP考試中的071(中文版)試題,由CUUG整理,如有報考OCP認證意向,可以聯系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;