第70题-OCP认证062考试题库2019最新考题解析
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询2018年的时候，OCP 11g考试题库大更新，052 053出现了很多新题，
2019年，11g即将停考的前期，Oracle又出现了一次大变动，12c出现了很多新题，比如062 063题库大更新
OCP解析公开课时间：【每周五晚8点】
OCP解析公开课地址：https://ke.qq.com/course/326223
OCP解析群资料分享：1015267481 验证：ocp
-------------------------------------------------------
QUESTION 70
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # #A_ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?
A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
B. It fails and reports an error because the CONTAINER=ALL clause is not used.
C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
Correct Answer: A
Section: (none)
Explanation：这道题有很多陷阱，需要注意：1、如果授权的时候用container=all，那么上面的命令会执行错误，ORA-65092: systemprivilege granted with a different scope to
'C##A_ADMIN'，那么正确答案是B;但是在授权的时候是单独的在root或者在其它pdbs上分别授权，那么答案A是正确的
