1z0-083 Free Practice Test

Examine this configuration:
< > >< > >< > >>< ><>

1. A. Uncommitted transactions in PDB1 have been rolled back.
2. B. PDB1 is closed.
3. C. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
4. D. CDB1 is shut down.
5. E. CDB1 is in MOUNT state

Correct Answer: AB

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

1. A. It analyzes a period of time corresponding to the 12 hours of activity.
2. B. It runs automatically after each AWR snapshot.
3. C. A DBA can run it manually.
4. D. Results are written to the alert log.
5. E. It analyzes a period of time corresponding to the last day of activity.

Correct Answer: BC

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

Which three are true about transporting databases across platforms usingRecovery Manager (RMAN) image copies? (Choose three.)

1. A. By default, the transported database will use Oracle Managed Files (OMF)
2. B. Data files can be converted on the destination system.
3. C. Data files can be converted on the source system.
4. D. A new DBIDis automatically created for the transported database.
5. E. Databases can be transported between systems with different endian formats.
6. F. The password file is automatically converted by RMAN.

Correct Answer: BCE
Password file is automatically converted by RMAN.