Free Oracle 1Z0-083 Exam Dumps Questions & Answers

Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)

• A.  A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
• B.  A snapshot copy PDB can be a full copy of a source PDB.
• C.  A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
• D.  A PDB snapshot depends on an existing storage snapshot of the source PDB.
• E.  A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
• F.  A PDB snapshot can be a full copy of a source PDB.
• G.  A PDB snapshot can be a sparse copy of a source PDB.

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

• A.  The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
• B.  Existing Oracle Database instances must be shut down before starting the upgrade.
• C.  The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
• D.  Only the grid user can perform the upgrade.
• E.  A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
• F.  An existing Oracle base can be used.

Which four are true about RMAN backup sets? (Choose four.)

• A.  Blocks from multiple data files can be contained in one backup piece,
• B.  A backup set must be written to disk.
• C.  A data file can be split into multiple sections stored in different backup pieces in the same backup set.
• D.  A backup set must be written to media.
• E.  Blocks from multiple data files can be contained in one backup set,
• F.  A data file can be split into multiple sections stored in different backup sets.
• G.  A backup set can contain only one backup piece.
• H.  A backup piece can belong to only one backup set.

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 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.
• C.  USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.
• D.  USER1 can connect only to APP1_ROOT.
• E.  USER1 can connect to APP1_ROOT and APP1_PDB1.

You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

• A.  All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
• B.  All Oracle recovery files in the current fast recovery area (FRA) are backed up.
• C.  These backups can be written to disk or SBT.
• D.  All non-Oracle files in the current FRA that have not been backed up already, are backed up.
• E.  All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.