1z0-083 Free Practice Test

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

1. A. after losing a SYSAUX tablespace data file
2. B. after losing all members of an INACTIVE online redo log group
3. C. after losing all members of the CURRENT onlineredo log group
4. D. after losing all copies of the control file
5. E. after losing an UNDO tablespace that is in use

Correct Answer: BD

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

1. A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
2. B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMPwhen plugging in a PDB
3. C. to include specific user tablespaces only when relocating a PDB
4. D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
5. E. to exclude a temp tablespace when plugging in a PDB
6. F. to specify the list oftablespaces to include when creating a PDB from the CDB seed

Correct Answer: BD

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

1. A. Media Management messages for SBT devices are always written to sbtio.log.
2. B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
3. C. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
4. D. The RMAN LOG command line clause causes output issued during RMAN commandcompilation to bewritten to a log file and to standard output.
5. E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
6. F. Media Management messages for SBT devices are written to an Oracletrace file.

Correct Answer: EF

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

1. A. Recovery begins from the beginning of the CURRENT redo log group.
2. B. Recovery begins from the last checkpoint position that wascalculated by the Database Writer before instance failure.
3. C. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
4. D. Recovery reads redo until the end of the redo threa
5. E. SMON rollsback any dead transactions, and then the datanase is opened.
6. F. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
7. G. Recovery reads redo until the end of the redo thread, and then opens the databas
8. H. SMON then rolls back any dead transactions.

Correct Answer: BDF

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

1. A. A target database’s persistent RMAN configuration settings are always stored in the target’s control file
2. B. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
3. C. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
4. D. The RMAN SHOW ALL command displays only settings with nondefault values.
5. E. A target database’s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
6. F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
7. G. A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Correct Answer: ABF