1Z0-083 practice questions 161–170

1. Question 161 · 178 in bank

   Select 2

   The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

   • ABackups must be done incrementally.
   • BBackups must be contained in backup sets.
   • CBackups can be taken only if the database is in ARCHIVELOG mode.
   • DBackups can be done incrementally.
   • EThe database must be registered in an RMAN catalog.
   • FOnly consistent backups can be created.

   Show answer

   Answer: CD

   Explanation

   A good example of how Oracle mixes up CAN/MUST to confuse us, in tests, as all answers sound correct! A - FALSE. It CAN be done incrementally, not MUST B - FALSE. They CAN be contained in backup sets, not MUST C - TRUE. By definition, you can only take online backups in ARCHIVELOG mode D - TRUE. Yes, they CAN be done incrementally. They don't have to be. E - FALSE. You CAN register in an RMAN catalog, you don't have to F - FALSE. An online backup is INCONSISTENT. So, CD are TRUE

   Source: Adapted from community discussion — xRodge

   Next question

2. Question 162 · 178 in bank

   Select 4

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

   • AA backup piece can belong to only one backup set.
   • BA data file can be split into multiple sections stored in different backup sets.
   • CA data file can be split into multiple sections stored in different backup pieces in the same backup set.
   • DBlocks from multiple data files can be contained in one backup piece.
   • EA backup set can contain only one backup piece.
   • FA backup set must be written to media.
   • GA backup set must be written to disk.
   • HBlocks from multiple data files can be contained in one backup set.

   Show answer

   Answer: ACDH

   Explanation

   ACDH A backup set contains one or more binary files in an RMAN-specific format. Each of these files is known as a backup piece. So E is Wrong.

   Source: Adapted from community discussion — RinD

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

3. Question 163 · 178 in bank

   Select 3

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

   • Acloning a remote container database in interactive mode
   • Bcloning a remote pluggable database in silent mode
   • Crelocating a remote pluggable database in interactive mode
   • Drelocating a remote container database in silent mode
   • Ecloning a remote container database in silent mode
   • Frelocating a remote pluggable database in silent mode
   • Grelocating a remote container database in interactive mode

   Show answer

   Answer: BEF

   Explanation

   B,E,F are correct $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

   Source: Adapted from community discussion — julica

   References

   • Oracle documentation

   Next question

4. Question 164 · 178 in bank

   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?

   • AExecute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
   • BExecute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.
   • CExecute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
   • DExecute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
   • EThis cannot be done due to the lack of a clean restore point.

   Show answer

   Answer: D

   Explanation

   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 Following on the same page, the procedure is described, which suggests the right answer to be D

   Source: Adapted from community discussion — SimoneF

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

5. Question 165 · 178 in bank

   Select 2

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

   • AUsing the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.
   • BA failure can be closed only when it has been repaired.
   • CData Recovery Advisor can be used if a database is closed.
   • DThe Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.
   • EData Recovery Advisor can proactively check for failures.

   Show answer

   Answer: CE

   Explanation

   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.

   Source: Adapted from community discussion — ObserverPL

   References

   • Oracle documentation
   • Oracle documentation

   Next question

6. Question 166 · 178 in bank

   Select 2

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

   • AIt can be used for both Oracle Database and Oracle Grid Infrastructure installation.
   • BIt can only install and configure Oracle Database software. The database has to be created separately.
   • CIt does not require the setup wizard.
   • DIt uses a single RPM that automatically extracts and installs the Oracle Database software.
   • EIt can be used to install and upgrade Oracle Database for single-instance and cluster configurations.

   Show answer

   Answer: AE

   Explanation

   A is CORRECT, no doubts here B is rather not correct because you can create your own gold-image with both binaries and DB files. C is CORRECT. You just create TAR in the command line with the golden image and you are happy. D is not correct - it does not use any RPM E is not correct rather, because it can be used for install but NOT for upgrade.

   Source: Adapted from community discussion — ObserverPL

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

7. Question 167 · 178 in bank

   Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

   • ASQL statements
   • Blog writer performance
   • Cgeneral operating system health
   • Ddatabase writer performance
   • Edatabase instance memory management and sizes

   Show answer

   Answer: C

   Explanation

   A is correct Prioritized Tuning Steps: Step 1: Tune the Business Rules Step 2: Tune the Data Design Step 3: Tune the Application Design Step 4: Tune the Logical Structure of the Database Step 5: Tune Database Operations Step 6: Tune the Access Paths Step 7: Tune Memory Allocation Step 8: Tune I/O and Physical Structure Step 9: Tune Resource Contention Step 10: Tune the Underlying Platform(s) https://docs.oracle.com/cd/A87860_01/doc/server.817/a76992/ch2_meth.htm

   Source: Adapted from community discussion — RinD

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

8. Question 168 · 178 in bank

   Select 3

   Which three are located by using environment variables? (Choose three.)

   • Athe Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
   • Bthe location of Oracle Net Services configuration files
   • Cthe list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
   • Ddefault directories for temporary files used by temporary tablespaces
   • Ethe temporary disk space used by Oracle Installer during installation
   • Fthe maximum number of database files that can be opened by a database instance

   Show answer

   Answer: ABE

   Explanation

   A - ORACLE_BASE, ORACLE_HOME - correct B - TNS_ADMIN, old TWO_TASK, etc - correct C - spfile parameter ASM_DISKGROUPS, not env variable D - [s]pfile parameter DB_CREATE_FILE_DEST, not env variable E - TMP, TEMP - correct F - [s]pfile parameter DB_FILES, not env variable

   Source: Adapted from community discussion — yurijk

   Next question

9. Question 169 · 178 in bank

   Select 2

   Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c? (Choose two.)

   • AThe response file can specify the root or sudo password.
   • BThe installer will prompt for the root or sudo password.
   • CSilent install always runs operating scripts automatically.
   • DThe response file must contain the root or sudo password.
   • EThe response file can specify the path of the sudo program.

   Show answer

   Answer: BE

   Explanation

   Reference: https://oraclefact.wordpress.com/2019/08/05/1-install-oracle-database-19c-with-automatic-root-scripts-execution/

   Source: Adapted from community discussion — RinD

   Next question

10. Question 170 · 178 in bank

    Select 3

    Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)

    • Ausing the KEEP FOREVER clause with the BACKUP command
    • Busing RMAN stored scripts
    • Cusing the REPORT SCHEMA command to list a database's current data files and tablespaces
    • Dcreating customized reports about a single database's backups
    • Ecreating encrypted backups
    • Fusing the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

    Show answer

    Answer: ABF

    Explanation

    ABF are definitely correct: A is correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/keepOption.html "Specifies that the backup or copy never becomes obsolete (see Example 2-27). A recovery catalog is required when FOREVER is specified because the backup records eventually age out of the control file." B is correct: https://docs.oracle.com/database/121/RCMRF/rcmsynta013.htm "Execute CREATE SCRIPT only at the RMAN prompt. RMAN must be connected to a target database and a recovery catalog." F is correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/REPORT.html "atClause This subclause specifies a point in time as a time, SCN, or log sequence number. You must be connected to a recovery catalog when issuing a REPORT SCHEMA command with an AT clause."

    Source: Adapted from community discussion — xRodge

    References

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    Next question

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

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