You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;
SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##admin user that is created in all PDBs?
The c##admin user is a common user because the username is prefixed with 'C##'. Common users can manage database objects and perform administrative tasks across all PDBs. The user can create local users when logged into any PDB and can create common users only when logged into the CDB root. Therefore, it can create only local users in all the PDBs and can create common users only when logged into the CDB root.
Answer AC
Answer A,C
I agree for the A C
B: when in root database =ALL is default C: common users can be created only in cdb
sorry answer is AC
AC correct
BC is the right answer