Oracle 1z0-497 Question Answer
Which two statements are true about this common user?
SQL> conn c##usr/pwd@pdb1
You are connected to PDB1 successfully.
SQL> conn c##usr/pwd@pdb2
You are connected to PDB2 successfully.
You are unable to create a connection. You first need to sync PDB2 by executing:
SQL> conn / as sysdba
SQL>exec DBMS_PDB.SYNC_PDB;
You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing:
SQL>conn system/pwd@pdb2
SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT;
Now you are able to connect as common user c##usr to PDB2.
TESTED 11 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved