【優技教育】Oracle 19c OCP 082題庫(第7題)- 2024年修正版
考試科目：1Z0-082
考試題量：90
通過分數：60%
考試時間：150min
本文為(CUUG 原創)整理并解析，轉發請注明出處，禁止抄襲及未經注明出處的轉載。
原文地址：https://www.cuug.com.cn/ocp/082kaoshitiku/38159072308.html
第7題：
7、Choose two.
Examine these statements which execute successfully:
CREATE USER finance IDENTIFIED BY pwfin;
CREATE USER fin_manager IDENTIFIED BY pwmgr;
CREATE USER fin_clerk IDENTIFIED BY pwclerk;
GRANT CREATE SESSION TO finance, fin_clerk;
GRANT SELECT ON scott.emp TO finance WITH GRANT OPTION;
CONNECT finance/pwfin
GRANT SELECT ON scott.emp TO fin_clerk;
Which two are true?
A) Dropping user FINANCE will automatically revoke SELECT on SCOTT.EMP from user FIN_CLERK.
B) Revoking SELECT on SCOTT.EMP from user FINANCE will also revoke the privilege from user FIN_CLERK.
C) User FINANCE is unable to grant ALL on SCOTT.EMP to FIN_MANAGER.
D) User FIN_CLERK can grant SELECT on SCOTT.EMP to user FIN_MANAGER.
E) User FINANCE can grant CREATE SESSION to user FIN_MANAGER.
Answer：AB
(解析：由于對象權限有級聯關系，所以上層沒了，下層也隨即沒有。經過實驗發現 C 答案是錯的，比較出乎意料。)
Oracle 19c OCP認證需要到Oracle指定的WDP機構，有了培訓記錄之后才能考試，考試需要考2科，分別是082(60%及格)和083(57%及格)，兩科都通過之后才能拿到證書。證書如下：
CUUG是甲骨文的金牌WDP合作機構，30多年品牌，培養了數萬名數據庫人才。想快速通過19c OCP考試的同學可以掃碼聯系老師咨詢。
