【2019年8月版本】OCP 071認(rèn)證考試最新版本的考試原題-32-CUUG整理

OCP的071考試，在8月份左右全部換了新題，近期考試的題也全部不包括之前的題庫了，這次oracle更新071考試題庫，雖然全都是新題，但跟之前的相比也有關(guān)聯(lián)，比如把之前的考題稍微變換一下數(shù)字、更新一下日期、或者再加一個錯誤選項(xiàng)等等。

對于2019年8月份的更新，我們CUUG已經(jīng)進(jìn)行了收集整理，并給出初步的答案和講解，僅供參考，希望對考OCP 071認(rèn)證的同學(xué)有幫助。

choose three

Examine this SQL statement:

SELECT cust_id, cus_ last_name "Last Name"

FROM customers

WHERE country_id = 10

UNION

SELECT cust_id CUST_NO, cust_last_name

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully.

A) ORDERBY 2, 1

B) ORDER BY "CUST_NO"

C) ORDER BY 2,cust_id

D) ORDER BY CUST_NO

E) ORDER BY "Last Name"

Answer：ACE

(解析：此題的解析跟下面的解析一樣，答案就是按照解析的總結(jié)規(guī)律找出來的。)

071-140 題目：

SELECT department_id "DEPT_ID", department_name, 'b' FROM departments

WHERE department_id=90 UNION

SELECT department_id, department_name DEPT_NAME, 'a' FROM departments

WHERE department_id=10

Which two ORDER BY clauses can be used to sort output?

A. ORDER BY DEPT_NAME;

B. ORDER BY DEPT_ID;

C. ORDER BY 'b';

D. ORDER BY 3;

Correct Answer: BD

(解析：通過實(shí)驗(yàn)發(fā)現(xiàn)別名必須是用雙引號概括起來的才可以用來排序;而且發(fā)現(xiàn)取了別名(別名用雙引號概括)的列的名字也不能用來排序;沒有用雙引號概括起來的別名的列名可以用來排序;order by 3，可以根據(jù)顯示的列的順序進(jìn)行排序。

注意 union 排序的的時候 order by 要寫在語句的最后;發(fā)現(xiàn)只能在第一條 select 語句中的列進(jìn)行排序。)

SQL> select empno "CUST_NO",ename "LAST NAME",'a' FROM emp

2 UNION

3 SELECT EMPNO ,ENAME,'b' FROM emp

4 ORDER BY empno;

ORDER BY empno

*

第 4 行出現(xiàn)錯誤:

ORA-00904: "EMPNO": 標(biāo)識符無效