400-090-9964


专题 | 论坛

教学文章

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

版权所有@北京优技教育技术有限公司(CUUG,中国UNIX用户协会) Copyright 2017 ALL Rights Reserved 京ICP备11008061号-1

CUUG旗下网站:www.cuug.com.cn www.cuug.com oracle.cuug.com bbs.cuug.com bd.cuug.com

电话:010-59426307 010-59426319 邮政编码:100089

海淀校区:北京市海淀区紫竹院路88号紫竹花园4号楼D座703(CUUG)