Oracle Updated 1z0-497 Exam Questions and Answers by leonidas

COMMIT

ROLLBACK

SAVEPOINT

SELECT

CREATE

SQL> conn c##usr/pwd@pdb1

You are connected to PDB1 successfully.

SQL> conn c##usr/pwd@pdb2

You are connected to PDB2 successfully.

SQL> conn c##usr/pwd@pdb2

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;

SQL> conn c##usr/pwd@pdb2

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.

undo data

isolation level

lock mechanism

serializability