Oracle
1Z0-067 · Question #194
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?…
The correct answer is B. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only. See the full explanation below for the reasoning.
Question
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.)
Options
- 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
- CThe command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the
- DThe command fails because system privileges cannot be granted to a common user.
How the community answered
(16 responses)- A6% (1)
- B75% (12)
- C13% (2)
- D6% (1)
Community Discussion
No community discussion yet for this question.