大數(shù)據(jù)就業(yè)實(shí)戰(zhàn)培訓(xùn) Oracle就業(yè)實(shí)戰(zhàn)培訓(xùn)
071考試題庫之前是比較穩(wěn)定的,但隨著Oracle的調(diào)整,071考試不斷的增加新的考題,增加了考試的難度,所以我們專門收集整理了這些考試,并對這些考題進(jìn)行解析,希望可以對考生有幫助。
每周五晚8點(diǎn),我們有免費(fèi)的OCP解析公開課,地址:https://ke.qq.com/course/326223 OCP題庫交流群:1015267481,驗(yàn)證ocp
-------------------------------------------------------
071考試-第18題、choose the best answer
View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS tables.
You issue the following query:
SQL>SELECT p.prod_id,prod_name,prod_list_price,
quantity_sold,cust_last_name
FROM products p NATURAL JOIN sales s NATURAL JOIN customers c
WHERE prod_id =148;
Which statement is true regarding the outcome of this query?
A) It executes successfully.
B) It produces an error because a column used in the NATURAL join cannot have a qualifier.
C) It produces an error because all columns used in the NATURAL join should have a qualifier.
D) It produces an error because the NATURAL join can be used only with two tables.
Answer:B
(解析:執(zhí)行該語句時(shí)返回錯(cuò)誤:
SELECT p.prod_id,prod_name,prod_list_price,
*
第 1 行出現(xiàn)錯(cuò)誤:
ORA-25155: NATURAL 聯(lián)接中使用的列不能有限定詞
)