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 06, 2025

Add To Cart

Question 1

Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?

A :

It has the same common users defined as does CDB1.

B :

It has only local roles.

C :

It has the same number of roles as CDB1.

D :

Service PDB1 is created for remote logins to PDB1.

E :

It is in mount state after creation.

F :

It has no local users.

Answer: A,B,D

Question 2

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

A : The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B : RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C : The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D : The UNDO TABLESPACE clause is never required.

E : RMAN 'pushes' the backups of the database to be duplicated over the network to the auxiliary instance.

Answer: A,B

Question 3

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

A : CDB1, PDB$SEED, PDB1, and PDB2

B : PDB$SEED, PDB1, and PDB2 only

C : CDB1 and PDB$SEED only

D : CDB1, PDB1, and PDB2 only

E : CDB1, PDB$SEED, and PDB1 only

Answer: A

Question 4

Choose two. Which two are true about memory advisors?

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

B : If 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 : All memory advisors use data from Automatic Workload Repository

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

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

Answer: C,D

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 : A media manager is required to create RMAN proxy copies.

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

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

Answer: C,E

Page: 1 / 57

Total 285 Questions | Updated On: Dec 06, 2025

Add To Cart