【Oracle 12c】最新CUUG OCP-071考试题库（58题）

发布时间：2020-12-12 13:18:21 所属栏目：百科来源：网络整理

导读：58、(16-1) 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

58、(16-1) 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)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!