Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 1:

  Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

  A. Media Management messages for SBT devices are always written to sbtio.log.
  B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
  C. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
  D. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
  E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
  F. Media Management messages for SBT devices are written to an Oracle trace file.
  B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
  E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

  ---

  Explanation/Reference:

  [oracle@rac1 admin]$ rman target / log '/tmp/log.txt'

  RMAN> list backup summary;

  RMAN> exit

  [oracle@rac1 admin]$ cat /tmp/log.txt

  Recovery Manager: Release 19.0.0.0.0 - Production on Mon Jun 22 15:48:39 2020

  Version 19.6.0.0.0

  Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

  connected to target database: TST193 (DBID=1785824688)

  RMAN>

  using target database control file instead of recovery catalog

  List of Backups

  ===============

  Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

  1 B F A DISK 15-JUN-20 1 1 NO TAG20200615T165352 2 B F A DISK 15-JUN-20 1 1 NO TAG20200615T174406 3 B F A DISK 22-JUN-20 1 1 NO TAG20200622T095655 4 B F A DISK 22-JUN-20 1 1 NO TAG20200622T095942 5 B F A DISK 22-JUN-20 1 1 NO TAG20200622T154703

  RMAN>

  Recovery Manager complete.

• Question 2:

  Examine these queries and their output:

  

  An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created.

  You want to recover PDB1 to Restore Point R1.

  How do you achieve this?

  A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
  B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.
  C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
  D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
  E. This cannot be done due to the lack of a clean restore point.
  D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

  ---

  Explanation/Reference:

  In 19c, you can actually flashback a PDB from a restore point even if it's not clean:

  When using restore points, you can perform a flashback database operation either to a CDB restore point, PDB restore point, PDB clean restore point, or PDB guaranteed restore point.

  https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing-flashback-dbpitr.html#GUID-C1215E86-9A7B-4EC9-9777-2A18BD627394

• Question 3:

  Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

  A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
  B. In a PDB plan, subplans may be used with up to eight consumer groups.
  C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
  D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
  E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
  A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
  B. In a PDB plan, subplans may be used with up to eight consumer groups.
  C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
  D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
  E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

• Question 4:

  Which three are true about a container database (CDB)? (Choose three).

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

  ---

  Explanation/Reference:

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-05702CEB-A43C-452C-8081-4CA68DDA8007

• Question 5:

  Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

  A. defining primary keys for all tables to speed up all queries
  B. using check constraints to speed up updates
  C. defining foreign keys for all tables to speed up joins
  D. the physical data model
  E. the configuration of storage arrays
  D. the physical data model
  E. the configuration of storage arrays

  ---

  Explanation/Reference:

  A. defining primary keys for all tables to speed up all queries

  B. using check constraints to speed up updates

  C. defining foreign keys for all tables to speed up joins

  D. the physical data model

  E. the configuration of storage arrays

  D - is to do with design the tablespace, partitions etc..

  E - is to do with storage layout, that RAID levels e.g. 5 to keep data with high read IO. 1+0 for better write.

• Question 6:

  Which two are true about backup encryption? (Choose two).

  A. The Transparent Data Encryption (TDE) keystore is backed up using RMAN.
  B. Vendor-specific media management software can be used for making encrypted RMAN backups to media.
  C. The BACKUP BACKUPSET command can encrypt and decrypt backup sets.
  D. Image copies can be encrypted.
  E. Keystore-based encryption is the default mode for RMAN backup encryption.
  F. Backup encryption can be enabled selectively for specific tablespaces.
  C. The BACKUP BACKUPSET command can encrypt and decrypt backup sets.
  E. Keystore-based encryption is the default mode for RMAN backup encryption.

• Question 7:

  Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

  A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the dataabse be in the MOUNT state.
  B. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
  C. An Oracle database can be restored from backup files copied using O/S utilities.
  D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
  E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
  F. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
  G. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.
  C. An Oracle database can be restored from backup files copied using O/S utilities.
  D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
  E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.

  ---

  Explanation/Reference:

  Backing up a database with OS utilites can be performed only when the database is shut down, so... A, B, G are incorrect

  OS copies are not backupsets, so again F is incorrect.

• Question 8:

  You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded.

  Sometimes you are not able to connect to the instance because it hangs.

  You do not want to restart the database instance. How can you detect the cause of the degraded performance?

  A. Enable Memory Access Mode, which reads performance data from SGA.
  B. Use emergency monitoring to fetch data directly from SGA for analysis.
  C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
  D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
  E. Run ADDM in diagnostic mode.
  B. Use emergency monitoring to fetch data directly from SGA for analysis.

  ---

  Explanation/Reference:

  The Emergency Monitoring feature of Enterprise Manager Cloud Control 12c is an evolution of Memory Access Mode from Grid Control 11g, allowing you to access in-memory statistics. In EM12c you no longer need to explicitly enable memory access mode. Just navigate to the page and wait while it makes a diagnostic connection to the database and performs lightweight analysis. The screen contains information that will help analyze performance issues, even if the database is hung and you can't connect to the normal performance pages.

• Question 9:

  Examine this command:

  $ rhpctl move database –sourcehome Oracle_home_path –destinationhome Oracle_home_path

  For which two purposes can you use this command? (Choose two.)

  A. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
  B. to switch to a read-only Oracle home
  C. to switch back to the previous Oracle home as part of a rollback operation
  D. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
  E. to switch to a patched Oracle Database home
  C. to switch back to the previous Oracle home as part of a rollback operation
  E. to switch to a patched Oracle Database home

  ---

  Explanation/Reference:

  You can use rhpctl move gihome command with the same syntax to switch from the current Oracle Grid Infrastructure home to a patched home.

  The rhpctl command enables you to switch from your current Oracle Grid Infrastructure or Oracle Database home to patched Oracle home so that you can provision the new Oracle home as gold image.

  You can also use the rhpctl command to switch back to the old Oracle home, if you want to roll back the operation.

  Correct Answer: CE

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/cwadd/rapid-home-provisioning.html#GUID-856C7378-2510-4B3E-8BE1-B4D79DF4FE8B

• Question 10:

  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.
  C. Data Recovery Advisor can be used if a database is closed.
  E. Data Recovery Advisor can proactively check for failures.

  ---

  Explanation/Reference:

  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.