1Z0-083 practice questions 141–150

1. Question 141 · 178 in bank

   Select 2

   A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required? (Choose two.)

   • Aafter losing a SYSAUX tablespace data file
   • Bafter losing all members of an INACTIVE online redo log group
   • Cafter losing all members of the CURRENT online redo log group
   • Dafter losing all copies of the control file
   • Eafter losing an UNDO tablespace that is in use

   Show answer

   Answer: CD

   Explanation

   C & D is correct. C & D is correct because if you lose all control the required incomplete recovery. if incomplete recovery then db must be open in resetlog option. E: undo tablespace. >> (Incorrect) http://oracle-help.com/backup-and-recovery/recovery-recover-loss-system-critical-undo-tablespace-original-location/ D: (correct see the details) http://oracle-help.com/backup-and-recovery/recovery-restore-loss-current-control-files-default-location/

   Source: Adapted from community discussion — you1234

   References

   • Oracle documentation

   Next question

2. Question 142 · 178 in bank

   Select 2

   Which two are true about instance recovery? (Choose two.)

   • AIt is not possible if an archived log is missing.
   • BIt is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
   • CSetting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
   • DIt is performed by the Recovery Writer (RVWR) background process.
   • ESetting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.
   • FIt is performed automatically while the database remains in MOUNT state. Then the database is opened.

   Show answer

   Answer: CF

   Explanation

   well i'm not so sure about it: You are right about the instance recovery begins after "alter database open" is executed but that doesn't mean that the database is already open when the recovery starts. The instance recovery is executed in 2 steps, rollforward and rollback and the database is open just after the rollforward is completed. So i think that is not accuracy to tell that the instance recovery is performed after the database is open. What do you thik? Here is a good diagram to understand it. https://www.orskl.com/how-oracle-database-does-instance-recovery-after-failures/

   Source: Adapted from community discussion — veginha

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

3. Question 143 · 178 in bank

   Select 2

   Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

   • AThe number of table rows is considered when evaluating the cost of accessing a table using an index.
   • BIndex balanced B*Tree height is considered when evaluating the cost of using an index.
   • CThe Statistics Advisor can help recommend the best way to gather statistics.
   • DStatistics collected using DBMS_STATS always yield the best optimizer result.
   • EThe Statistics Advisor generates actions for all recommendations.

   Show answer

   Answer: BC

   Explanation

   Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statistics-advisor.html#GUID-D81A7708-FDA0-45BB-A6E2- 103858B047AE

   Source: Adapted from community discussion — janw

   References

   • Oracle documentation
   • Oracle documentation

   Next question

4. Question 144 · 178 in bank

   Select 3

   A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it. The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT. Which three are true? (Choose three.)

   • AData file 24 can be recovered only while connected to PDB2.
   • BData file 24 can be restored and recovered while connected to CDB$ROOT.
   • CData file 24 can be restored only while connected to CDB$ROOT.
   • DData file 24 can be restored only while connected to PDB2.
   • EData file 24 can be recovered while connected to PDB2.
   • FData file 24 can be recovered while connected to CDB$ROOT.

   Show answer

   Answer: BEF

   Explanation

   -- connect with RMAN directly to PDB: [oracle@rac1 admin]$ rman target sys/oracle_4YOU@PDB1931 ... Version 19.6.0.0.0 ... RMAN> restore datafile 21; Starting restore at 06-AUG-20 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=259 instance=tst1932 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00021 to /u01/app/oracle/test_pdb1.dbf channel ORA_DISK_1: reading from backup piece +FRA/TST193/A82132332AEF5FE9E0538044AB0AB63C/BACKUPSET/2020_08_06/nnndf0_tag20200806t154747_0.335.1047743269 channel ORA_DISK_1: piece handle=+FRA/TST193/A82132332AEF5FE9E0538044AB0AB63C/BACKUPSET/2020_08_06/nnndf0_tag20200806t154747_0.335.1047743269 tag=TAG20200806T154747 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 06-AUG-20 ....

   Source: Adapted from community discussion — julica

   References

   • Oracle documentation

   Next question

5. Question 145 · 178 in bank

   Select 2

   Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

   • ATablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB.
   • BOracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
   • CA new PDB is automatically created when importing a non-CDB into a CDB.
   • DOracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
   • EMoving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
   • FMoving data from a non-CDB to a PDB is only possible by using conventional export and import.

   Show answer

   Answer: BD

   Explanation

   BD E,F ->Incorrect -> tablespace export/import can be conventional or transportable A,C -> Nothing is created automatically you must create what you need.

   Source: Adapted from community discussion — ald85

   References

   • Oracle documentation
   • Oracle documentation

   Next question

6. Question 146 · 178 in bank

   Select 3

   Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

   • Ausing Database Replay
   • Busing SQL Developer
   • Cusing Oracle Data Pump
   • Dusing operating system file copy utilities
   • Eusing Database Upgrade Assistant
   • Fusing the CREATE TABLE AS SELECT SQL statement

   Show answer

   Answer: BCF

   Explanation

   C,E and F are correct Oracle provides features and products to automate the upgrade process and ensure the most efficient use of time. Oracle Database supports the following methods for upgrading a database to the new release: Database Upgrade Assistant (DBUA) Manual upgrade using SQL scripts and utilities Oracle Data Pump CREATE TABLE AS SQL statement https://docs.oracle.com/database/121/UPGRD/intro.htm#UPGRD60026

   Source: Adapted from community discussion — veginha

   References

   • Oracle documentation
   • Oracle documentation

   Next question

7. Question 147 · 178 in bank

   Select 2

   Which two are true about Oracle instance recovery? (Choose two.)

   • ARecovery begins from the beginning of the CURRENT redo log group.
   • BRecovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
   • CRecovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
   • DRecovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the database is opened.
   • ERecovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
   • FRecovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

   Show answer

   Answer: EF

   Explanation

   I think E - F are correct. E: Instance recovery is the process of applying records in the online redo log to data files to reconstruct changes made after the most recent checkpoint. Instance recovery occurs automatically when an administrator attempts to open a database that was previously shut down inconsistently. .. The checkpoint process (CKPT) is responsible for writing checkpoints to the data file headers and control file. F: Oracle Database can roll back multiple transactions simultaneously as needed. All transactions that were active at the time of failure are marked as terminated. Instead of waiting for the SMON process to roll back terminated transactions, new transactions can roll back individual blocks themselves to obtain the required data. https://docs.oracle.com/cd/E25178_01/server.1111/e25789/startup.htm

   Source: Adapted from community discussion — Marco_M

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

8. Question 148 · 178 in bank

   Examine this configuration: 1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. 2. ORCL uses disk group +FRA for the Fast Recovery Area. 3. LISTENER is the listener for ORCL. 4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5. All components are currently shut down. You execute this command:

   

   What is the outcome?

   • AThe ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
   • BOnly the ORCL database instance is started.
   • COnly the ORCL database and the ASM instances are started.
   • DOnly the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
   • EOnly the ORCL database instance and the +DATA and +FRA disk groups are started.

   Show answer

   Answer: A

   Explanation

   it depends by dependencies. but in this case is the default LISTENER and is necessary also for ASM. in a default configuration also LISTENER is started. So, the right answer is A.

   Source: Adapted from community discussion — julica

   References

   • Oracle documentation

   Next question

9. Question 149 · 178 in bank

   Select 2

   Which two are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

   • AIt analyzes a period of time corresponding to the 12 hours of activity.
   • BIt runs automatically after each AWR snapshot.
   • CA DBA can run it manually.
   • DResults are written to the alert log.
   • EIt analyzes a period of time corresponding to the last day of activity.

   Show answer

   Answer: BC

   Explanation

   Correct:B,C A. False. The time period analyzed by ADDM is defined by the last two snapshots (the last hour by default). B. True. An ADDM analysis task is performed and its findings and recommendations stored in the database every time an AWR snapshot is taken provided the STATISTICS_LEVEL parameter is set to TYPICAL or ALL C. True. DBA can run manual ADDM , for example in order to increase de period analyzed (default is time beetween two last AWR snaps) D. False. stores in AWR not in alert logfile.Data is stored both in memory and in the database E. False. The time period analyzed by ADDM is defined by the last two snapshots (the last hour by default).

   Source: Adapted from community discussion — raferen10

   Next question

10. Question 150 · 178 in bank

    Select 4

    Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

    • AThe NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
    • BThe UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
    • CRMAN ג€pushesג€ the backups of the database to be duplicated over the network to the auxiliary instance.
    • DThe NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
    • ERMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
    • FThe UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
    • GThe UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
    • HRMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

    Show answer

    Answer: AEFH

    Explanation

    Correct answers are: A,D,E,H wrong: B,F,H: not "always" are required wrong: C: RMAN doesn't pushes the backup, but read from the backup.

    Source: Adapted from community discussion — proact

    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 141. 178 questions available.