1Z0-497 practice question 6 of 25

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;

Answer options

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. Correct answer

Correct Answer:

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

Keep practicing

Take the free 1Z0-497 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.