What happens if you execute these SQL statements?

What happens if you execute these SQL statements?
SQL> show con_name
CON_NAME
——————————–
CDB$ROOT
SQL> create user 1_freed identified by y container=current;

What happens if you execute these SQL statements?
SQL> show con_name
CON_NAME
——————————–
CDB$ROOT
SQL> create user 1_freed identified by y container=current;

A.
A common user is created in the root container.

B.
A local user is created in the root container.

C.
A local user is created in all the PDBs.

D.
The second SQL statement fails because a local user cannot be created in the root container.



Leave a Reply 0

Your email address will not be published. Required fields are marked *