Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 171:

  In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT? (Choose three).

  A. redo logs
  B. control files
  C. all data dictionary metadata
  D. user-defined PL/SQL packages
  E. temporary tablespaces
  F. mandatory Oracle-supplied PL/SQL packages
  G. undo tablespaces
  A. redo logs
  B. control files
  C. all data dictionary metadata

• Question 172:

  Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

  A. A PDB snapshot is always a full copy of the source PDB.
  B. A PDB snapshot is always a sparse copy of the source PDB.
  C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
  D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
  E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
  F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
  G. A snapshot copy PDB can be created from a stand-alone clone PDB.
  C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
  G. A snapshot copy PDB can be created from a stand-alone clone PDB.

  ---

  Explanation/Reference:

  A, B incorrects -> http://ora-srv.wlv.ac.uk/oracle19c_doc/multi/introduction-to-the-multitenant-architecture.html#GUID-47847140-8DE4-4C4E-8C93-4E9C197D1402 C correct, D,E,F incorrect -> https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-B00A0E48-C892-4DC8-8455-C6F2ABC8EF91 G -> correct -> A clone from a PDB snapshot is a full, standalone PDB. -> https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-22118625-3157-4C38-8A88-79A561A3E6ED

  http://ora-srv.wlv.ac.uk/oracle19c_doc/multi/introduction-to-the-multitenant-architecture.html#GUID-47847140-8DE4-4C4E-8C93-4E9C197D1402

• Question 173:

  A user complains about poor database performance.

  You want to verify if the user's session has waited for certain types of I/O activity.

  Which view displays all waits waited on by a session at least once?

  A. V$SESSION_EVENT
  B. V$SESSTAT
  C. V$SESSION_WAIT
  D. V$SESSION_WAIT_CLASS
  E. V$SESSION
  A. V$SESSION_EVENT

  ---

  Explanation/Reference:

  V$SESSION_EVENT, but C. V$SESSION_WAIT can displays the current or last wait for each session. https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SESSION_EVENT.html#GUID-5723D404-83F7-4C8D-8BF2-031B3FFEAAA8 https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SESSION_WAIT.html#GUID-4EDAB293-F3FC-40FE-BC75-4FEE6A4D7705

• Question 174:

  Which three actions are mandatory post database upgrade? (Choose three).

  A. Updating client scripts with the new Oracle home.
  B. Resetting passwords to enforce case-sensitivity.
  C. Run OPatch commands from the new Oracle home.
  D. Setting threshold values for table space alerts.
  E. Migration to unified auditing.
  F. Upgrading user tables that depend on Oracle-maintained abstract data types.
  A. Updating client scripts with the new Oracle home.
  C. Run OPatch commands from the new Oracle home.
  F. Upgrading user tables that depend on Oracle-maintained abstract data types.

• Question 175:

  Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

  A. A target database's persistent RMAN configuration settings are always stored in the target's control file
  B. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
  C. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
  D. The RMAN SHOW ALL command displays only settings with nondefault values.
  E. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
  F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
  G. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
  A. A target database's persistent RMAN configuration settings are always stored in the target's control file
  C. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
  F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.

  ---

  Explanation/Reference:

  Reference: https://books.google.com.pk/books?id=pUEkAAAAQBAJandpg=PA114andlpg=PA114anddq=V$RMAN_CONFIGURATION+view+displays+only+settings+with+values+that+have+been+modifiedandsource=blandots=fhC9A7ULeXandsig=ACfU3U2cGhTjmAOpCZhvlL5R4j6ixLRAwandhl=enandsa=Xandved=2ahUKEwjJzf-WmtnoAhXT8eAKHQ9uBG8Q6AEwAHoECAwQJg#v=onepageandq=V%24RMAN_CONFIGURATION%20view% 20displays%20only%20settings%20with%20values%20that %20have%20been%20modifiedandf=false

• Question 176:

  Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

  A. when the duplicate ... from active database command contains the section size clause
  B. when you perform active database duplication on a database with flashback disabled
  C. when you specify set encryption before the duplicate ... from active database command
  D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
  E. when you perform active database duplication on a database that has readonly tablespaces
  A. when the duplicate ... from active database command contains the section size clause
  C. when you specify set encryption before the duplicate ... from active database command
  D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

  ---

  Explanation/Reference:

  Starting with Oracle Database 12c Release 1 (12.1), RMAN can use backup sets to transfer the source database files that need to be duplicated. The backup sets are transferred over the network to the auxiliary database. Backup sets can be encrypted for additional security. Specify the encryption algorithm by using the SET ENCRYPTION ALGORITHM command before the DUPLICATE command. RMAN uses backup sets to perform active database duplication when the connection to the target database is established using a net service name and any one of the following conditions is satisfied: The DUPLICATE ... FROM ACTIVE DATABASE command contains either the USING BACKUPSET, USING COMPRESSED BACKUPSET, or SECTION SIZE clause. The number of auxiliary channels allocated is equal to or greater than the number of target channels allocated. http://docs.oracle.com/database/121/BRADV/ rcmdupdb.htm#BRADV298

• Question 177:

  Which three are true about Recovery Manager (RMAN) active database duplication? (Choose three)

  A. Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.
  B. Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.
  C. Pre-existing backups of the database to be duplicated are always used if they exist.
  D. Image copies can be used to duplicate the active database.
  E. The active database must be duplicated while in OPEN state.
  F. No connection to the recovery catalog is required for active database duplication.
  G. Backup sets can be used to duplicate the active database.
  D. Image copies can be used to duplicate the active database.
  F. No connection to the recovery catalog is required for active database duplication.
  G. Backup sets can be used to duplicate the active database.

• Question 178:

  Which three RMAN persistent settings can be set for a database?

  A. backup retention policy
  B. default backup device type
  C. default section size for backups
  D. default destinations for backups
  E. multiple backup device types for a single backup
  A. backup retention policy
  B. default backup device type
  D. default destinations for backups

• Question 179:

  You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

  A. Compare Period ADDM report
  B. AWR Compare Period report
  C. Active Session History (ASH) report
  D. Taking a new snapshot and comparing it with a preserved snapshot.
  A. Compare Period ADDM report

  ---

  Explanation/Reference:

  Comparing Current System Performance to a Baseline Period You may have noticed a performance change on a production system and would like to know why, or you may have implemented a change to a production system and want to know the effect of the change, such as increased concurrency waits.

  The Compare Period ADDM compares the performance of the database server in two time periods, and returns a report describing the performance changes and the root origin of the changes. https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT525

• Question 180:

  What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

  A. It will create a multitenant container database (CDB) with only the root opened.
  B. It will create a CDB with root opened and seed read only.
  C. It will create a CDB with root and seed opened and one PDB mounted.
  D. It will create a CDB that must be plugged into an existing CDB.
  E. It will create a CDB with root opened and seed mounted.
  B. It will create a CDB with root opened and seed read only.