1Z0-083 practice questions 81–90

1. Question 81 · 178 in bank

   Select 2

   Some archived log backups have been accidentally deleted from storage. Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups? (Choose two.)

   • ARESYNC CATALOG
   • BREPORT OBSOLETE
   • CLIST ARCHIVELOG ALL
   • DCROSSCHECK BACKUP OF ARCHIVELOG ALL
   • ELIST ARCHIVELOG
   • FLIST EXPIRED

   Show answer

   Answer: DF

   Explanation

   not A : Typically, you run RESYNC CATALOG in the following situations: The recovery catalog was unavailable when you executed RMAN commands that automatically perform a resynchronization. The target database is running in ARCHIVELOG mode, because the recovery catalog is not updated automatically when an online redo log switch occurs or when a redo log is archived. You made changes to the physical structure of the target database such as adding or dropping a tablespace. As with log archiving, the recovery catalog is not updated automatically when the physical schema changes. RMAN is connected as TARGET to a standby database. You want to update the recovery catalog with metadata about RMAN operations performed on this database or about a physical change on the primary database.

   Source: Adapted from community discussion — vkra

   Next question

2. Question 82 · 178 in bank

   Select 3

   Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant? (Choose three.)

   • AThe Oracle Application Express configuration should be updated after upgrading Oracle Database.
   • BTime zone files must be upgraded manually using the DBMS_DST PL/SQL package.
   • CAny Recovery Manager (RMAN) recovery catalog must be upgraded manually.
   • DThe new extended data type capability must be enabled by running the utlrp.sql script.
   • EAfter a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.

   Show answer

   Answer: ACE

   References

   • Oracle documentation

   Next question

3. Question 83 · 178 in bank

   Select 3

   Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN? (Choose three.)

   • AThe control file is backed up automatically each time the SPFILE is backed up manually.
   • BThe control file is backed up whenever an RMAN backup is successfully recorded in the catalog.
   • CIt requires the use of fast recovery area (FRA).
   • DThe control file is backed up whenever a new table is created.
   • EThe control file is backed up whenever a new tablespace is created.
   • FThe server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

   Show answer

   Answer: BEF

   Explanation

   For non-CDBs, if CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN automatically backs up the control file and the current server parameter file (if used to start the database) after a successful BACKUP command. For CDBs and standalone databases with the COMPATIBLE initialization parameter set to 12.0 or higher, by default, the control file autobackup is turned on. Chapter 8 About RMAN Control File and Server Parameter File Autobackups 8-15 If the database runs in ARCHIVELOG mode, RMAN makes control file autobackups when a structural change to the database affects the contents of the control file.

   Source: Adapted from community discussion — ilputto

   Next question

4. Question 84 · 178 in bank

   Select 3

   Which three are true about cloning databases into an existing CDB with RMAN? (Choose three.)

   • AA user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.
   • BThe target and auxiliary instance passwords must be the same.
   • CTwo or more PDBs can be cloned with the same command.
   • DA non-CDB can be cloned into a PDB.
   • EOnly one PDB can be cloned at a time.
   • FA user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

   Show answer

   Answer: BEF

   Explanation

   25.5.3.2 Restrictions on Duplicating a PDB to an Existing CDB Duplicating a PDB to an existing CDB is subject to certain restrictions. Only active database duplication is supported. Only the following clauses of the DUPLICATE command are supported: NORESUME, DB_FILE_NAME_CONVERT, SECTION SIZE, and USING COMPRESSED BACKUPSET. The following clauses of the DUPLICATE command are not supported: SPFILE, NO STANDBY, FARSYNC STANDBY, and LOG_FILE_NAME_CONVERT. Duplicating a PDB to a CDB that is a standby database is not supported. Only one PDB can be duplicated at a time. Partial PDB duplication is not supported, only complete PDB duplication is supported. For example, you cannot include or exclude specific tablespaces while duplicating a PDB. Duplicating a non-CDB as a PDB in an existing CDB is not supported. Duplicating PDBs that contain TDE-encrypted tablespaces is not supported.

   Source: Adapted from community discussion — LeandroHPN

   References

   • Oracle documentation

   Next question

5. Question 85 · 178 in bank

   Select 2

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

   • AA snapshot copy PDB can be a full copy of a source PDB.
   • BA PDB snapshot can be a sparse copy of a source PDB.
   • CA snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
   • DA PDB snapshot depends on an existing storage snapshot of the source PDB.
   • EA PDB snapshot can be a full copy of a source PDB.

   Show answer

   Answer: BE

   Explanation

   A "PDB snapshot" is a point-in-time copy of a PDB. The source PDB can be open read-only or read/write while the snapshot is created. A clone from a PDB snapshot is a full, standalone PDB. A "snapshot copy PDB" is based on a copy of the underlying storage system. Snapshot copy PDBs reduce the amount of storage required for testing purposes and reduce creation time significantly.

   Source: Adapted from community discussion — vkra

   Next question

6. Question 86 · 178 in bank

   SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

   • ACreate SQL plan directives for each of the regressed statements.
   • BUse the SQL Tuning Advisor for each of the regressed statements.
   • CUse the SQL Access Advisor for each of the regressed statements.
   • DCreate an adaptive execution plan for each of the regressed statements.

   Show answer

   Answer: B

   Explanation

   Agree with B https://docs.oracle.com/en/database/oracle/oracle-database/19/ratug/comparing-sql-trials.html#GUID-A86879DB-BB8B-4F97-91BF-12CB045932C0 In cases when only a few SQL statements have regressed, consider using one of the following tuning methods to implement a point solution for them: Creating SQL Plan Baselines Running SQL Tuning Advisor

   Source: Adapted from community discussion — dmees

   References

   • Oracle documentation
   • Oracle documentation

   Next question

7. Question 87 · 178 in bank

   Select 2

   Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup? (Choose two.)

   • ABackups can be written only if checksums are stored for each block.
   • BBinary compression cannot be applied to the backup.
   • CBackups can be written only to disk.
   • DBackups can be written only to media.
   • EBackups can be taken only if a fast recovery area is configured.
   • FBackups can be taken only for data files.

   Show answer

   Answer: BC

   References

   • Oracle documentation
   • Oracle documentation

   Next question

8. Question 88 · 178 in bank

   Select 2

   Examine this configuration: 1. CDB1 is a container database. 2. APP1_ROOT is an application container contained in CDB1. 3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT. 4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT. 5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0. 6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0 of APP1_USER_APP was installed. You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> ALTER SESSION SET CONTAINER=app1_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE '1.0' TO '2.0'; Pluggable database altered. SQL> GRANT CREATE SESSION TO USER1; Grant succeeded. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app1_pdb1; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_userl_app SYNC; Pluggable database altered. Which two are true? (Choose two.)

   • AUSER1 can connect to APP1_ROOT and APP1_PDB1.
   • BUSER1 can connect only to APP1_ROOT.
   • CUSER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.
   • DUSER1 can connect only to APP1_PDB1.
   • EUSER1 can connect to CDB1.
   • FUSER1 is defined in APP1_PDB2.

   Show answer

   Answer: AF

   Next question

9. Question 89 · 178 in bank

   Select 3

   A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three are required? (Choose three.)

   • ACDB2 must be in archivelog mode.
   • BCDB1 and CDB2 must both be in local UNDO mode.
   • CCDB2 must be in shared UNDO mode only.
   • DCDB1 must be in shared UNDO mode only.
   • ECDB1 must be in archivelog mode.
   • FCDB1 and CDB2 must be in shared UNDO mode.

   Show answer

   Answer: ABE

   Next question

10. Question 90 · 178 in bank

    Select 2

    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.)

    • Ato switch an existing Oracle Database home to a newer release of Oracle software on the same server
    • Bto switch to a read-only Oracle home
    • Cto switch back to the previous Oracle home as part of a rollback operation
    • Dto switch the Oracle Database home when using a centralized Rapid Home Provisioning server
    • Eto switch to a patched Oracle Database home

    Show answer

    Answer: CE

    Explanation

    Student Guide: 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 option A is incorrect and confusing..

    Source: Adapted from community discussion — Jatindra

    References

    • Oracle documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

1Z0-083 practice, question 81. 178 questions available.