Which statement is true?

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##_ADMIN;

Which statement is true?

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##_ADMIN;

Which statement is true?

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

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

C.
The command fails because the CONTAINER clause is not used.

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



Leave a Reply 3

Your email address will not be published. Required fields are marked *