Oracle Exam 1Z0-497 Topic 11 Question 112 Discussion

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

Question #: 112
Topic #: 11

[All 1Z0-497 Questions]

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;

AA common user is created in the root container.

BA local user is created in the root container.

CA local user is created in all the PDBs.

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

Show Suggested Answer

Suggested Answer: A, B, C, D

by Gilma at Feb 06, 2025, 11:26 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Malika

6 days ago

Haha, I bet the developers who came up with this question were having a field day. 'Let's see if they can keep up with our SQL shenanigans!'

upvoted 0 times

...

Mari

7 days ago

I'm pretty sure it's Option A. A common user is created in the root container. It's the only option that makes sense to me.

upvoted 0 times

...

Tori

17 days ago

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

upvoted 0 times

...

Kayleigh

23 days ago

Hmm, that makes sense. I see your point now.

upvoted 0 times

...

Sherman

26 days ago

I disagree, I believe the answer is D) The second SQL statement fails because a local user cannot be created in the root container.

upvoted 0 times

...

Kayleigh

27 days ago

I think the answer is B) A local user is created in the root container.

upvoted 0 times

...