1z0-083 Free Practice Test

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

1. A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
2. B. FLASHBACK drop requires thatthe RECYCLEBIN parameter be set to ON.
3. C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
4. D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
5. E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
6. F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between twopoints in time.

Correct Answer: ABF

You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

1. A. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
2. B. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
3. C. All Oracle recovery files in the current FRA that have not been backed up already,are backed up.
4. D. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
5. E. These backups can be written to disk or SBT.

Correct Answer: DE
https://blog.toadworld.com/rman_-_using_the_flash_recovery_area

Which two are true about unplugging an application container from a container database and plugging it into a different container database?

1. A. It requires local undo mode in both container databases.
2. B. It requires only local undo mode in the database where the application container will be unplugged.
3. C. Plugging the application root into a different CDB plugs In all its application PDBs.
4. D. Application PDBs In the application container must beunplugged before the application root Is unplugged.
5. E. Unplugging the application root from a CDB unplugs all its application PDBs.
6. F. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.

Correct Answer: DE

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

1. A. ADDM can recommend shrinking the buffer cache.
2. B. ADDM can recommend extending the buffer cache.
3. C. By default, MMON creates an AWR snapshot every 30 minutes.
4. D. ADDM performs itsanalysis only when a DBA requests it.
5. E. By default, AWR snapshots are automatically purged after eight days.
6. F. AWR snapshots must be deleted when no longer required by ADDM.

Correct Answer: AEF

Which three are true about an application seed pluggable database (PDB)? (Choose three.)

1. A. It is automatically synchronized with its application root PDB when an application is upgraded.
2. B. It cannot be added to an application container after the application container has already been created.
3. C. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
4. D. It is automatically synchronized with its application root PDB when an application is installed.
5. E. It cannot be dropped from its application container.
6. F. A new application PDB created by cloning an application seed PDB canhave an up-to-date version of the application installed after cloning completes.
7. G. It is not required in an application container.

Correct Answer: DFG