Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 181:

  How do you configure a CDB for local undo mode?

  A. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

  B. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.

  C. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ONin each PDB, and then restart the CDB instance.

  D. Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

  E. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

  Correct Answer: A

  Tested couple of minutes ago in practice. It was not possible to change undo mode on the PDB level:

  SQL> alter database local undo OFF; alter database local undo OFF * ERROR at line 1: ORA-65040: operation not allowed from within a pluggable database

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/administering-a-cdb-with-sql-plus.html#GUID-1AAB032F-D13A-4E06-A062-59E0487C2FC5

• Question 182:

  Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed.

  No changes have been made to the standard PDB$SEED.

  How many default temporary tablespaces can be assigned in the CDB?

  A. three

  B. eight

  C. seven

  D. six

  E. five

  Correct Answer: D

  We can verify that, by default, neither PDB$SEED nor APP SEED create temporary tablespace (at least that's how it seems to work in 19.3.0)

  SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED

  2 PDB$SEED READ ONLY NO 3 TOYS_ROOT READ WRITE NO 4 TOYS_ROOT$SEED READ WRITE NO 5 PDB1 READ WRITE NO 6 HR_ROOT READ WRITE NO 7 OPERATIONS READ WRITE NO 8 RESEARCH READ WRITE NO

  SQL> select name from v$pdbs where con_id not in (select con_id from cdb_temp_files); NAME

  PDB$SEED TOYS_ROOT$SEED

  CDB$ROOT + pdb1 + pdb2 + app_root + app_pdb1 + app_pdb2 = 6

• Question 183:

  Which three are true about Oracle Grid Infrastructure for a Standalone Server?

  A. It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

  B. It creates one disk group during installation.

  C. It requires the operating system oracle_base environment variable to be predefined before installation.

  D. It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks

  E. It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.

  F. Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.

  Correct Answer: ABF

• Question 184:

  Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.

  Examine these steps:

  1.

  Install the SALES_APP application, including the common tables, in the application root.

  2.

  Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.

  3.

  Create an application seed.

  4.

  Install the SALES_APP application in the application seed.

  5.

  Create the SALES_APP1 and SALES_APP2 application PDBs.

  6.

  Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.

  7.

  Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.

  8.

  Sync the application seed with the application root.

  Which are the minimum required steps in the correct sequence?

  A. 3,4,1,6,8

  B. 1,5,6

  C. 1,3,5,6,7

  D. 1,3,5,7

  E. 2,5,6

  Correct Answer: B

• Question 185:

  Which two are true about unplugging an application container from a container database and plugging it into a different container database?

  A. It requires local undo mode in both container databases.

  B. It requires only local undo mode in the database where the application container will be unplugged.

  C. Plugging the application root into a different CDB plugs In all its application PDBs.

  D. Application PDBs In the application container must be unplugged before the application root Is unplugged.

  E. Unplugging the application root from a CDB unplugs all its application PDBs.

  F. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.

  Correct Answer: DE

• Question 186:

  Which three are true In Oracle 19c and later releases?

  A. Tablespaces always remain In read/write mode during transportable tablespace operations.

  B. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

  C. Tablespaces never remain In read/write mode during transportable tablespace operations.

  D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

  E. A transportable data pump import can leave a plugged-in tablespace in read-only mode.

  F. A transportable data pump import can leave a plugged-in tablespace In read/write mode.

  Correct Answer: BCD

  This is a new feature in 19c and latest https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-8BAADCB7-F93A-48D0-BF24-369C4947C56B

  "You can now import tablespace files mounted on two different databases as long as the files are set as read-only." You can set read/only, so its not mandatory.

  D is also correct for MAX_DATAPUMP_JOBS_PER_PBD parameter

• Question 187:

  Which three are true about Audit policies In container databases (CDBs)?

  A. All audit records are written to the audit trail in CDB$ROOT

  B. A common unified audit policy can be created at the application root level.

  C. A common unified audit policy can be created at the CDB level.

  D. An application PDB cannot have a local audit policy.

  E. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.

  F. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.

  Correct Answer: BCE

• Question 188:

  Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

  A. Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

  B. A failure can be closed only when it has been repaired.

  C. Data Recovery Advisor can be used if a database is closed.

  D. The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.

  E. Data Recovery Advisor can proactively check for failures.

  Correct Answer: CE

  A is NOT correct - DB can be even NOT MOUNTED.

  B is NOT correct - you can close it whenever you want, eventually new check will find the failure again.

  C has to be CORRECT despite it is not fully clear, anyway Recovery Advisor can be used when database is even NOT mounted, hence it is CLOSED while instance is STARTED.

  D is NOT correct because of ONLY word. Change Failure can CLOSE or CHANGE PRIORITY.

  E is CORRECT - Data Recovery Advisor can potentially detect, analyze, and repair data failures BEFORE a database process discovers the corruption and signals an error. Early warnings help limit damage caused by corruption.

  The health assessment is known as a data integrity check and can be invoked reactively or PROACTIVELY.

• Question 189:

  Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

  A. It can be performed using an auxiliary instance managed by a DBA.

  B. It can be used to recover a truncated table.

  C. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.

  D. RMAN always includes tablespaces containing undo segments in the recovery set.

  E. It can be performed repeatedly until the correct time is found without using an RMAN catalog.

  F. flashback database must be enabled for it to work.

  G. It can be used to recover a dropped tablespace.

  H. It can be performed using an auxiliary instance managed by RMAN.

  Correct Answer: AEFH

• Question 190:

  Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

  A. cloning a remote container database in interactive mode

  B. cloning a remote pluggable database in silent mode

  C. relocating a remote pluggable database in interactive mode

  D. relocating a remote container database in silent mode

  E. cloning a remote container database in silent mode

  F. relocating a remote pluggable database in silent mode

  G. relocating a remote container database in interactive mode

  Correct Answer: BEF

  $ORACLE_HOME/bin/dbca -silent \

  -createDuplicateDB -gdbName CDB1 -sid CDB1B \

  -createAsStandby -dbUniqueName CDB1B -sysPassword oracle \

  -primaryDBConnectionString $(hostname):1521/CDB1A \

  -datafileDestination /u01/oradata -useOMF true -storageType FS \

  -recoveryAreaDestination /u01/fast_recovery_area \

  -recoveryAreaSize 10240 -enableArchive true \

  -createListener LISTENER1B:1522

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/clone-pdbs-using-dbca-silent-mode/index.html?learningpath=trueandappuser=nobodyandappsession=170971049395andcontentid=26693andactivityname=Clone%20PDBs%

  20using%20DBCA%20in%20Silent%20Modeandeventid=6352