Oracle Exam 1Z0-067 Topic 5 Question 49 Discussion

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

Question #: 49
Topic #: 5

In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command:

SQL> GRANT create tablespace to C##A_ADMIN;

Which statement is true? (Choose the best answer.)

AThe command fails because the CONTAINER clause is not used.

BThe command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.

CThe command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the plugging databases (PDBs).

DThe command fails because system privileges cannot be granted to a common user.

Show Suggested Answer

Suggested Answer: B

by Nelida at May 03, 2022, 07:00 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-067 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!