OCP认证071中文考试题库原题(cuug内部资料)第63题

时间：2022-05-13 来源：

本套题库是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