Exam 1z0-060 topic 1 question 70 discussion

Actual exam question from Oracle's 1z0-060

Question #: 70
Topic #: 1

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # in root and all PDBs. You execute the following command from the root container:

A_ADMIN -
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.

Show Suggested Answer

Suggested Answer: B 🗳️
SQL> create user c##admin identified by stipsi container=all;
User created.
SQL> grant create table to c##admin container=all;
Grant succeeded.
SQL> revoke create table from c##admin;
revoke create table from c##admin
*
ERROR at line 1:
ORA-65092: system privilege granted with a different scope to 'C##ADMIN'

by [deleted] at April 4, 2025, 8:55 a.m.

Comments

Submit Cancel

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