【2019年8月版】OCP 071认证考试原题-第39题

in 编程
关注公众号【好便宜】( ID:haopianyi222 ),领红包啦~
阿里云,国内最大的云服务商,注册就送数千元优惠券:https://t.cn/AiQe5A0g
腾讯云,良心云,价格优惠: https://t.cn/AieHwwKl
搬瓦工,CN2 GIA 优质线路,搭梯子、海外建站推荐: https://t.cn/AieHwfX9

Choose two

Exanine the desatption of the BOOKS_TRANSACTIONS table

Name Null? Type

----------------------------------------------------------------------------------------------

TRANSACTION_ID     NOT NULL  VARCHAR2(6)

TRANSACTION_TYPE                    VARCHAR2(3)

BORROWED_DATE                        DATE

BOOK_ID                                      ARCHAR2(6)

MEMBER_ID                                 VARCHAR2(6)

Examine this partial SQL statement:

SELECT * FROM books_transctions;

Which two WHERE condtions give the same resut?

A) WHERE borrowed_date = SYSDATE AND (transaction_type= 'RM' OR member_id IN

('A101','A102' ) );

B) WHERE borrowed_date = SYSDATE AND transaction_type= 'RM' OR member_id IN

('A101','A102' ) ;

C) WHERE borrowed_date = SYSDATE AND (transaction_type= 'RM' AND member_id='A101' OR

member_id = 'A102') );

D) WHERE (borrowed_date = SYSDATE AND transaction_type= 'RM' ) OR member_id IN

('A101','A102' );

E) WHERE borrowed_date = SYSDATE AND (transaction_type= 'RM' AND ( member_id= 'A101' OR

member_id = 'A102' ) );

Answer::BD

(解析:考的是 and 和 or 的优先级。)

关注公众号【好便宜】( ID:haopianyi222 ),领红包啦~
阿里云,国内最大的云服务商,注册就送数千元优惠券:https://t.cn/AiQe5A0g
腾讯云,良心云,价格优惠: https://t.cn/AieHwwKl
搬瓦工,CN2 GIA 优质线路,搭梯子、海外建站推荐: https://t.cn/AieHwfX9
扫一扫关注公众号添加购物返利助手,领红包
Comments are closed.

推荐使用阿里云服务器

超多优惠券

服务器最低一折,一年不到100!

朕已阅去看看