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: Mar 27, 2025

Add To Cart

Question 1

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

A : The number of table rows is considered when evaluating the cost of accessing a table using an index.

B : dex balanced B*Tree height is considered when evaluating the cost of using an index.

C : Statistics Advisor can help recommend the best way to gather statistics.

D : atistics collected using DBMS_STATS always yield the best optimizer result.

E : Statistics Advisor generates actions for all recommendations.

Answer: B,C

Question 2

Choose three. Which three are true about cloning databases into an existing CDB with RMAN?

A :

A non-CDB can be cloned into a PDB.

B :

A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

C :

Only one PDB can be cloned at a time.

D :

Two or more PDBs can be cloned with the same command.

E :

A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.

F :

The target and auxiliary instance passwords must be the same.

Answer: A,B,C

Question 3

Choose two. Which two are true about memory advisors?

A : Automatic Memory Management is enabled, no memory advisors are available.

B : Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

C : l memory advisors use data from Automatic Workload Repository

D : Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

E : Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

Answer: C,D

Question 4

Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

A : data dictionary in CDB$ROOT

B : log writer process (LGWR)

C : SYSAUX tablespaces

D : mporary tablespaces

E : Process Monitor Process (PMON)

F : do tablespaces

Answer: A,B

Question 5

Choose two. Which two are true about RMAN backups when using a media manager?

A : A media manager always writes RMAN requested backups to tape.

B : A media manager is required to create RMAN image copies.

C : media manager is required to create RMAN proxy copies.

D : media manager layer (MML) routines provided by Oracle support any vendors' media management products.

E : default, a request for a proxy copy may result in a backup set being created.

Answer: A

Page: 1 / 57

Total 285 Questions | Updated On: Mar 27, 2025

Add To Cart