Oracle Exam 1Z0-497 Topic 1 Question 74 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 74
Topic #: 1

Which two statements are true about this common user?

ASQL> conn c##usr/pwd@pdb1
You are connected to PDB1 successfully.

BSQL> conn c##usr/pwd@pdb2
You are connected to PDB2 successfully.

CSQL> 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;

DSQL> 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.

Show Suggested Answer

Suggested Answer: D

https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

by Ettie at Apr 21, 2023, 09:41 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF