1Z0-083 practice questions 171–178

1. Question 171 · 178 in bank

   Select 3

   Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)

   • AThe ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.
   • BThe Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.
   • CFlashback commands help with repairing physical errors.
   • DRMAN can always repair corrupt blocks.
   • EThe ADR can store metadata in an Oracle Database repository.
   • FThe Data Recovery Advisor uses the ADR.

   Show answer

   Answer: ABF

   Explanation

   ABF are correct. Easier to say why the others are incorrect. C - Flashback is a logical tool. It cannot repair a physical error. D - incorrect. RMAN cannot always repair corrupt blocks, for example - a DB in noarchivelog mode.... E - ADR is an offline, file based, utility. It does not exist within the DB itself.

   Source: Adapted from community discussion — xRodge

   References

   • Oracle documentation
   • Oracle documentation

   Next question

2. Question 172 · 178 in bank

   Select 3

   The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true? (Choose three.)

   • AA proxy PDB must exist in the application root in the remote CDB.
   • BA database link must exist in the local CDB root referring to the remote CDB.
   • CPDB3's application root replica must exist in the local CDB.
   • DA database link must exist in the remote CDB referring to the local CDB.
   • EThe HR_ROOT replica must exist in the remote CDB.
   • FA proxy PDB must exist in the application root in the local CDB.

   Show answer

   Answer: BEF

   Explanation

   OK BEF: Database link must be created in master application root (local CDB) referring to replica application root (remote CDB). Option B Proxy PDB must be created in master application root (local CDB) using this database link. Option F Replica application root must exist in remote CDB (created or upgraded using SYNC in local Proxy PDB). Option E With this, we can make a SELECT that will show data from local and remote PDB applications (Query in local master application root using CONTAINERS clause).

   Source: Adapted from community discussion — Rogazan

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

3. Question 173 · 178 in bank

   Select 2

   Which two are true about poorly performing SQL statements and their tuning in Oracle database instances? (Choose two.)

   • ASQL statements performing many physical I/Os can always have their performance improved by creating indexes.
   • BSQL statements doing only logical reads never require tuning because they do no physical I/O.
   • CThe solution that best optimizes one SQL statement can degrade the performance of others.
   • DSQL statements doing joins always do more physical I/O than single table queries.
   • EPoorly performing SQL statements can be tuned automatically by the Oracle server.

   Show answer

   Answer: CE

   Next question

4. Question 174 · 178 in bank

   Select 2

   Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

   • AIt can be used for applications and middleware.
   • BIt can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.
   • CIt can be used only for Oracle Grid Infrastructure, including Oracle Restart.
   • DIt can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.
   • EIt can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.

   Show answer

   Answer: AD

   Explanation

   Reference - https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwadd/rapid-home-provisioning.html#GUID-CCEC5960-EDA4-4A3F-9643- 0CA308EA49AA

   Source: Adapted from community discussion — waev

   References

   • Oracle documentation

   Next question

5. Question 175 · 178 in bank

   Select 2

   Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area? (Choose two.)

   • Athe archived log deletion policy
   • Bthe backup optimization policy
   • Cthe backup retention policy
   • Dusing guaranteed UNDO retention
   • Ethe DB_CREATE_ONLINE_LOG_DEST_n parameter setting
   • Fthe DB_RECOVERY_FILE_DEST parameter setting

   Show answer

   Answer: AC

   Explanation

   AC correct RMAN automatically manages files in the fast recovery area by deleting obsolete backups and archiving files no longer required for recovery. https://docs.oracle.com/en/database/oracle/oracle-database/18/ssdbi/about-the-fast-recovery-area-and-the-fast-recovery-area-disk-group.html#GUID-05343E2B-24CF-427E-A068-9AC2104BEF81

   Source: Adapted from community discussion — RinD

   References

   • Oracle documentation
   • Oracle documentation

   Next question

6. Question 176 · 178 in bank

   Select 2

   Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)

   • AIt can be launched from both the command line and the Universal Installer (OUI) interfaces.
   • BIt can be used to change the character set of an existing database.
   • CIt can be used to convert a non-container database to a container database.
   • DIt can be used to create container databases and non-container databases.
   • EIt can only be launched from the command line interface.

   Show answer

   Answer: AD

   Explanation

   A and D are both correct. An interesting aside is that Oracle have specified that, in the future, non-CDBs will not be possible. But, this option is still available in 19c - which is what this exam is based upon. From Oracle 20c onwards, it is not meant to be possible to create non-CDBs with the DBCA. (not tested, only going from documentation)

   Source: Adapted from community discussion — xRodge

   References

   • Oracle documentation

   Next question

7. Question 177 · 178 in bank

   Select 3

   Which three are performed by Oracle Automatic Storage Management (ASM) instances? (Choose three.)

   • Amounting disk groups
   • Bmanaging Allocation Units (AUs) for disk group content
   • Cmanaging extent allocation for Oracle database segments
   • Dacting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)
   • Emanaging space allocation for Oracle ASM files
   • Facting as an I/O server to read data file blocks from ASM disks on behalf of database server processes

   Show answer

   Answer: ABE

   Explanation

   Reference: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmcon.htm#OSTMG94057

   References

   • Oracle documentation
   • Oracle documentation

   Next question

8. Question 178 · 178 in bank

   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?

   • Asix
   • Bseven
   • Cfive
   • Deight
   • Ethree

   Show answer

   Answer: D

   Explanation

   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 I think A is correct (CDB$ROOT + pdb1 + pdb2 + app_root + app_pdb1 + app_pdb2 = 6)

   Source: Adapted from community discussion — Rogazan

   References

   • Oracle documentation

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

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