Question No. 1

You have configured RMAN SBT channels to write backups to media.

You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

AThe restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

BThe data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

CAll archive logs created after this backup are kept for two years.

DThe SPFILE is included in the self-contaied archival backup.

EThe control file is included in the self-contained archival backup.

FThe restore point is a label for the system change number (SCN) before the archival backup was taken.
https://docs.oracle.com/cd/E18283_01/server.112/e17118/statements_6011.htm http://devel.hotpilot.cz/ora11gR2u2-full/backup.112/e10643/rcmsubcl011.htm An example: http://www.online-database.eu/recovery-manager-rman/143-rman-backupsets-with-restore-point

Show Answer

Correct Answer: B, D, E

Question No. 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

Correct Answer: D, E

Question No. 3

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

AThe General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

BOracle DBCA templates can store only logical structure and not database files.

CNew templates can only be created by modifying an existing user-created template.

DThe Data Warehouse template is most suitable when transaction response time is the key criterion.

EOracle DBCA templates can be used to create new databases and duplicate existing databases.

Show Answer

Correct Answer: A, E

Question No. 4

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 frquently, 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

Correct Answer: E, F

Question No. 5

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

ASBT tape compression can be used even if no RMAN compression is configured.

BAny backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

CAny backup written to the SBT device in this configuration can contain a maximum of two backup sets.

DSBT tape compression and RMAN backup compression should be used in parallel.

EThe SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

Show Answer

Correct Answer: D, E

Free Oracle 1Z0-083 Exam Actual Questions

The questions for 1Z0-083 were last updated On Dec 17, 2024