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

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

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

Choose three

Which three statements are true about views in an Orade batabase?

A) A SELECT statement cannot contain a where clause when querying a view contaning a WHERE clause in its defining query

B) Rows inserted into a table using a view are retained in the table if the view is dopped

C) Views can join tables only if they belong to the same schema.

D) Views have no segment.

E) Views have no object number.

F) A view can be created that refers to a non-existent table in its defining query.

Answer：BD?

(解析：

經(jīng)過(guò)實(shí)驗(yàn)，A 不對(duì);C 不對(duì)，視圖可以和不同模式的表進(jìn)行連接查詢;F 不對(duì)，如果子查詢中沒有表，創(chuàng)建視圖會(huì)報(bào)錯(cuò);視圖也是對(duì)象，所以答案 E 錯(cuò)誤;