1z0-083 Practice Test

1z0-083 Practice Test practice questions, page 6 of 8, with answer review and explanations.

Question 26

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

  1. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
  2. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
  3. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
  4. Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
  5. Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Question 27

Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)

  1. Data file 24 can be recovered while PDB2 is opened.
  2. Data file 24 must be recovered while the CDB is opened.
  3. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
  4. Data file 24 cannot be recovered while the CDB is opened.
  5. Data file 24 must be recovered while PDB2 is closed.

Question 28

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

  1. A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.
  2. A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.
  3. A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.
  4. A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.
  5. A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.
  6. A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

Question 29

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

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

Question 30

Which three are true about Optimizer Statistics Advisor? (Choose three.)

  1. It can be run only manually.
  2. It is part of the DBMS_ADVISOR package.
  3. It can recommend changes to improve the statistics gathering process.
  4. It always analyzes all schemas in the database.
  5. It runs automatically every night by default.
  6. It is part of the DBMS_STATS package.