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: Dec 17, 2025

Add To Cart

Question 1

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 2

Choose three. Which three are true about a container database (CDB)?

A : It can be created from a non-CDB.

B : It can contain only one PDB$SEED, which is created when the CDB is created.

C : It can have local users with the same name in different PDBs.

D : It can contain only one Application Container seed, which is created when the Application Container is created.

E : It can be created by cloning an existing CDB.

F : It can have any number of pluggable databases (PDBs) limited only by space availability.

G : It contains predefined common roles in both the root and the seed.

Answer: A,B

Question 3

Choose three. Which three are true about a whole database backup?

A :

It can be created only by using RMAN.

B :

It always includes all data files, the current control file, the server parameter file, and archived redo logs.

C :

It can be consistent.

D :

Â It is the only possible backup type for a database in NOARCHIVELOG mode.

E :

It can consist of either backup sets or image copies. F) It can be inconsistent.

Answer: C,D,E

Question 4

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 5

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

A : AWR snapshots can be created in CDB$ROOT.

B : ADDM can run in a nonroot container.

C : AWR reports can be generated while connected to any container.

D : All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E : AWR snapshots can be created in a PDB.

F : No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Answer: A,D

Page: 1 / 57

Total 285 Questions | Updated On: Dec 17, 2025

Add To Cart