Free Oracle 1Z0-083 Exam Questions

Become Oracle Certified with updated 1Z0-083 exam questions and correct answers

Page: 1 / 57

Total 285 Questions | Updated On: Apr 09, 2021

Add To Cart

Question 1

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

A : Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.

B : Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

C : Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

D : 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.

E : Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Answer: A,C

Question 2

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

A : It analyzes a period of time corresponding to the 12 hours of activity.

B : It runs automatically after each AWR snapshot.

C : A DBA can run it manually.

D : Results are written to the alert log.

E : It analyzes a period of time corresponding to the last day of activity.

Answer: B,C

Question 3

Which two are true about common objects? (Choose two.)

A : They can be created only in CDB$ROOT.

B : They can be only metadata-linked in an application container.

C : They can exist in user-defined schemas only in application containers.

D : They can exist in CDB$ROOT and an application root.

E : They can be extended data-linked in CDB$ROOT. F. They can be created only in an application root.

Answer: D

Question 4

Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?

A : A PDB snapshot depends on an existing storage snapshot of the source PDB.

B : APDB snapshot can be a full copy of a source PDB.

C : A PDB snapshot can be a sparse copy of a source PDB

D : A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

E : A snapshot copy PDB can be a full copy of a source PDB

Answer: B,C

Question 5

You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have different endian formats.
Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4. Copy the UNIVERSITY tablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

A : 1,2,4,5,7,8

B : 1,2,4,6,7,8

C : 1,2,3,4,5,7,8

D : 1,2,3,4,5,6,7,8

E : 2,4,5,6,7

Answer: C

Page: 1 / 57

Total 285 Questions | Updated On: Apr 09, 2021

Add To Cart