Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle Exam 1Z0-083 Topic 6 Question 102 Discussion

Actual exam question for Oracle's 1Z0-083 exam
Question #: 102
Topic #: 6
[All 1Z0-083 Questions]

Choose two. Examine this configuration: 1. CDB1 is a container database. 2. APP1_ROOT is an application container contained in CDB1. 3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT. 4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT. 5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0. 6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0 of APP1_USER_APP was installed. You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> ALTER SESSION SET CONTAINER=app1_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> GRANT CREATE SESSION TO USER1; Grant succeeded. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE TO '2.0'; Pluggable database altered SQL> ALTER SESSION SET CONTAINER=app1_pdb1; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC; Pluggable database altered. Which two are true?

Show Suggested Answer Hide Answer
Suggested Answer: B, D

Contribute your Thoughts:

Corrina
2 months ago
I'm not sure about option C. Can USER1 really connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1?
upvoted 0 times
...
Isadora
2 months ago
Haha, I bet the exam writer had a field day coming up with all these application container and PDB names. B and C are the way to go, though. Gotta love those Oracle database shenanigans!
upvoted 0 times
...
Alonzo
2 months ago
I agree with Stephanie. Option B makes sense based on the commands executed.
upvoted 0 times
...
Leonida
3 months ago
E seems like a tempting answer, but the question states that USER1 is a common user in APP1_ROOT and all its application PDBs, so B and C are the right choices.
upvoted 0 times
...
Merrilee
3 months ago
I think the correct answers are B and C. USER1 has been granted the CREATE SESSION privilege in APP1_ROOT, so they can connect to both APP1_ROOT and APP1_PDB1.
upvoted 0 times
Daryl
2 months ago
That makes sense. The ALTER SESSION commands allow USER1 to connect to those containers.
upvoted 0 times
...
Georgeanna
2 months ago
Yes, I agree. USER1 can connect to both APP1_ROOT and APP1_PDB1.
upvoted 0 times
...
Rosalyn
2 months ago
I think the correct answers are B and C.
upvoted 0 times
...
...
Stephanie
3 months ago
I think option B is true because USER1 can connect to APP1_ROOT and APP1_PDB1.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77