OCP認證071中文考試題庫原題(cuug內部資料)第63題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢本套題庫是OCP考試中的071(中文版)試題，由CUUG整理，如有報考OCP認證意向，可以聯系cuug咨詢老師。
63、請選擇兩項。
查看BRICKS表的說明:
Name Null? Type
-------- -------- --------
BRICK_ID NUMBER(38)
SHAPE VARCHAR2 (30)
COLOR VARCHAR2 (30)
WEIGHT NUMBER
查看BRICKS_STAGE 表的說明:
Name Null? Type
-------- -------- -------
WEIGHT NUMBER
SHAPE VARCHAR2 (30)
COLOR VARCHAR2 (30)
哪兩個查詢將成功執行?
A) SELECT * FROM bricks
MINUS
SELECT * FROM bricks_stage;
B) SELECT shape, color FROM bricks
MINUS
SELECT weight, color FROM bricks_stage;
C) SELECT shape, color FROM bricks
MINUS
SELECT color, shape FROM bricks_stage;
D) SELECT shape, color, weight FROM bricks
MINUS
SELECT * FROM bricks_stage;
E) SELECT brick_id, shape FROM bricks
MINUS
SELECT weight, color FROM bricks_stage;
整理：cuug
