PDF File

Latest Oracle 1Z0-083 Practice Questions BY Cantu

Question 1

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

  • A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
  • B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
  • C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
  • D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
  • E. Re-createthepasswordfileintheOracleDatabase12cformat. Correct
Question 2

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?

  • A. USER1 can connect to CDB1.
  • B. USER1 can connect to APP1_ROOT and APP1_PDB1.
  • C. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.
  • D. USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.
  • E. USER1 can connect only to APP1_ROOT.