Oracle Oracle Database 1Z0-083 Questions & Answers

• Question 1:

  A schema owner truncated a table in error and must recover the data.

  Which Oracle Flashback feature could be used to recover the data?

  A. FLASHBACK TRANSACTION

  B. FLASHBACK VERSION QUERY

  C. FLASHBACK DATA ARCHIVE

  D. FLASHBACK TABLE

  E. FLASHBACK DATABASE

  Correct Answer: E

  Reference: https://docs.oracle.com/cd/B12037_01/appdev.101/b10795/adfns_fl.htm

• Question 2:

  Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)

  A. The Pre-Upgrade Information Tool script is executed by DBUA.

  B. DBUA must be launched from the target Oracle Home.

  C. All pluggable databases are automatically upgraded as part of a container database upgrade.

  D. A whole database backup must exist before upgrade

  E. The database must be opened in read-only mode.

  F. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

  Correct Answer: ABC

• Question 3:

  Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c? (Choose three.)

  A. It is an Oracle Database service.

  B. It can be used to deploy Oracle Database homes.

  C. It cannot be used to provision applications.

  D. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.

  E. It cannot be used to provision middleware.

  F. It is an Oracle Grid Infrastructure service.

  Correct Answer: BDF

  Reference: https://blogs.oracle.com/db_maintenance/rapid-home-provisioning-server-minimun-requirement

• Question 4:

  Which two are true about backup set compression using RMAN default compression? (Choose two.)

  A. Compressed backups can be written only to media.

  B. Binary compression adds CPU overhead to backup operations.

  C. Unused blocks below the high water mark are backed up.

  D. Compressed backups cannot have a section size defined.

  E. Compression can be done only for locally managed tablespaces.

  Correct Answer: BE

  Reference: https://knowledge.broadcom.com/external/article/50652/rman-backup-how-does-it-treat-empty-blo.html

• Question 5:

  Which two are true about memory advisors? (Choose two.)

  A. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

  B. If Automatic Memory Management is enabled, no memory advisors are available.

  C. All memory advisors use data from Automatic Workload Repository.

  D. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

  E. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

  Correct Answer: AC

  Reference: https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1137385000346840516

• Question 6:

  PDB1 and PBD2 are pluggable databases in CDB1. Examine these commands:

  

  CDB1 is then restarted.

  Which three are true? (Choose three.)

  A. PDB2 will be MOUNTED.

  B. PDB1 will be MOUNTED.

  C. PDB$SEED will be opened READ ONLY.

  D. PDB2 will be opened READ WRITE.

  E. PDB1 will be opened READ WRITE.

  F. PDB$SEED will be MOUNTED.

  Correct Answer: ACE

• Question 7:

  Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

  A. ADDM can run in a nonroot container.

  B. AWR snapshots can be created in CDB$ROOT.

  C. AWR reports can be generated while connected to any container.

  D. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

  E. AWR snapshots can be created in a PDB.

  F. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

  Correct Answer: ABE

  The CDB-level snapshot data is stored in the SYSAUX tablespace of a CDB root. The PDB-level snapshot data is stored in the SYSAUX tablespace of a PDB.

  Starting with Oracle Database 12c, ADDM is enabled by default in the root container of a multitenant container database (CDB). Starting with Oracle Database 19c, you can also use ADDM in a pluggable database (PDB).

• Question 8:

  Which two are true about Optimizer Statistics? (Choose two.)

  A. They can be gathered by the DBMS_STATS package.

  B. They are gathered by the SQL Tuning Advisor.

  C. They provide real-time data about schema objects.

  D. They are ignored by Optimizer if they are stale.

  E. By default, they are automatically gathered by a maintenance job.

  Correct Answer: AE

  Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_stats.htm#TGSQL-GUID-E4EFD512- EAF9-4AF3-943F-FDEC7E47B23C

• Question 9:

  Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)

  A. the data dictionary in CDB$ROOT

  B. temporary tablespaces

  C. the Process Monitor Process (PMON)

  D. SYSAUX tablespaces

  E. the log writer process (LGWR)

  F. undo tablespaces

  Correct Answer: ACE

• Question 10:

  Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)

  A. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned

  B. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned

  C. creating a new empty PDB in the local database from PDB$SEED

  D. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database

  E. automatically dropping the database link to the remote database if it already exists

  F. creating a database link from CDB$ROOT in the remote database to the PDB in the local database

  G. opening the cloned PDB

  Correct Answer: BEG

  https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-13FF2CE2-532C-4816-8E88-7A5A6E16A279

  About Cloning a Remote PDB

  When the source is a PDB is in a remote CDB, you must use a database link to clone the PDB into the local CDB.

  The database link must exist in the local CDB (not the remote CDB). When you issue the CREATE PLUGGABLE DATABASE statement from the root of the local CDB, you must specify a database link to the remote CDB that contains the

  PDB being cloned in the FROM clause. The database link connects from the local CDB to either to the root of the remote CDB or to the remote source PDB.

  The following figure illustrates how this technique creates a new PDB when the source PDB is remote.

  https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-32AE49B1-13A7-4A4D-AB43-BA781ECA99D6