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