近两年来,OCP的考试题库频率变化,不断的增加新考题,071考试就是其中一个,给很多考071的考生造成困扰,对此,我们专门整理了OCP考试里关于071考试的原题,并带上答案,分享给大家。
--------------------------------------------
071题库汇总-第58题、choose the best answer:
Examine the structure of the BOORSTRANSACTIONS table:
Examine the SQL statement:
SQL> SELECT FROM books_transactions WHERE borrowed_date
MEMBER_ID IN ('A101', 'A102');
Which statement is true about the outcome?
A) It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.
B) It displays details for members who have borrowed before today's date with either RM as TRANSACTION_TYPE or MEMBER_ID as A101 and A102.
C) It displays details for members who have borrowed before today with RM as TRANSACTION_TYPE and the details for members A101 or A102.
D) It displays details for only members A101 and A102 who have borrowed before today with RM as TRANSACTION_TYPE.
Answer:C
(解析:该题的核心是考查大家对 and 与 or 两个逻辑操作符同时存在时的优先级顺序。其优先级顺序依次是: 所有比较操作符、 NO 、 AND 、 OR)
-----------------------------------------------
OCP解析公开课时间:【每周五晚8点】
OCP解析公开课地址:https://ke.qq.com/course/326223
OCP解析群资料分享:1015267481 验证:ocp
另外,除了OCP公开课,OCM题库直播也同步进行中,OCM最新题库大爆料-【每周四晚8点】,【微信群直播】,可以联系咨询老师进群参与