Oracle Exam 1Z0-060 Topic 3 Question 54 Discussion

Actual exam question for Oracle's 1Z0-060 exam

Question #: 54
Topic #: 3

In your multitenant container database (CDB) that contains pluggable databases (PDBs), you grant the CREATE TABLE privilege to the common user C##A_ADMIN in root and all PDBs, with one command. You then execute the following command from the root container:

SQL> REVOKE create table FROM C##A_ADMIN;

What is the result?

AIt executes successfully and the CREATE TABLE privilege is revoked from C##A_ADMIN in root only.

BIt fails and reports an error because the CONTAINER=ALL clause is not used.

CIt executes successfully and the CREATE TABLE privilege is revoked from C##A_ADMIN in root and all the PDBs.

DIt fails and reports an error because the CONTAINER=CURRENT clause is not used.

EIt executes successfully and the CREATE TABLE privilege is revoked from C##A_ADMIN in all the PDBs.

Show Suggested Answer

Suggested Answer: C, D

by Felicidad at Feb 08, 2023, 09:09 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-060 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!