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##A_ADMIN;Which statement is true? (Choose the best answer.)

Question:

Which statement is true?

Options:

The command fails because the CONTAINER clause is not used.

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

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

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

Correct Answer

The Correct Answer for this Question is

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

You may also like...

Leave a Reply

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