1z0-083 Free Practice Test

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

1. A. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.
2. B. Oracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB.
3. C. A new PDB is automatically created when importing a non-CDB into a CDB.
4. D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
5. E. Moving data from a PDB to anon-CDB is only possible by using transportable tablespace export and import.
6. F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Correct Answer: DE

Which three are true about opatchauto? (Choose three.)

1. A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
2. B. It must be invoked by a user with root user privileges.
3. C. Patches are appliedvia opatchauto.
4. D. Users must always input patch plans to opatchauto.
5. E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
6. F. It applies patches in nonrolling mode by default.
7. G. It is used toapply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Correct Answer: ABC

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

1. A. All metrics are instance related.
2. B. Cleared statefulalerts are displayed by querying DBA_ALERT_HISTORY.
3. C. A space usage management alert is automatically cleared after the underlying problem is resolved.
4. D. They are generated by SMON when a tablespace is 97% full.
5. E. Metrics are statistical counts for aspecific unit.
6. F. STATISTICS_LEVEL must be set to ALL to generate alerts.

Correct Answer: BCE

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 three are true about Optimizer Statistics Advisor? (Choose three.)

1. A. It can berun only manually.
2. B. It is part of the DBMS_ADVISOR package.
3. C. It can recommend changes to improve the statistics gathering process.
4. D. It always analyzes all schemas in the database.
5. E. It runs automatically every night by default.
6. F. It is part of theDBMS_STATS package.

Correct Answer: ACF
https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/ https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf