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、如果授權(quán)的時候用container=all，那么上面的命令會執(zhí)行錯誤，ORA-65092: systemprivilege granted with a different scope to

'C##A_ADMIN'，那么正確答案是B;但是在授權(quán)的時候是單獨的在root或者在其它pdbs上分別授權(quán)，那么答案A是正確的