Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 51:

  Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)

  A. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.

  B. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.

  C. Flashback commands help with repairing physical errors.

  D. RMAN can always repair corrupt blocks.

  E. The ADR can store metadata in an Oracle Database repository.

  F. The Data Recovery Advisor uses the ADR.

  Correct Answer: ABF

  ABF are correct. Easier to say why the others are incorrect.

  C - Flashback is a logical tool. It cannot repair a physical error.

  D - incorrect. RMAN cannot always repair corrupt blocks, for example - a DB in noarchivelog mode....

  E - ADR is an offline, file based, utility. It does not exist within the DB itself.

  Reference: https://docs.oracle.com/database/121/ADMIN/diag.htm

• Question 52:

  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: C

• Question 53:

  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 54:

  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 55:

  Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose two.)

  A. It can be used for both Oracle Database and Oracle Grid Infrastructure installation.

  B. It can only install and configure Oracle Database software. The database has to be created separately.

  C. It does not require the setup wizard.

  D. It uses a single RPM that automatically extracts and installs the Oracle Database software.

  E. It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.

  Correct Answer: AE

• Question 56:

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

  A. They can be written only to disk.

  B. They must be written to media.

  C. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.

  D. They can be created only by using the COPIES option of a BACKUP command.

  E. They can be written to media.

  Correct Answer: CE

  CE - Correct

  A. They can be written only to disk. - not only

  B. They must be written to media. - not must

  C. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup. - true

  D. They can be created only by using the COPIES option of a BACKUP command. - not only

  E. They can be written to media. - true

• Question 57:

  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 58:

  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

• Question 59:

  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 60:

  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