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 02, 2026

Add To Cart

Question 1

Examine this configuration: While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/ controlfile02.ctl'is accidentally deleted. To recover from this critical failure, you execute these commands:
What will be the outcome?

A : It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'

B : It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.

C : It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'

D : It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.

E : It will fail because there is no autobackup of the controlfiles.

Answer: C

Question 2

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 3

Choose two. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

A : A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.

B : A PDB Lockdown profile can be created in an application root.

C : A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.

D : A PDB Lockdown profile can be created in a regular PDB.

E : A PDB Lockdown profile can be created in CDB$ROOT .

Answer: A,B

Question 4

Which three are true about performing an Oracle Database install on Linux? (Choose three.)

A : The runfixup.sh script can install missing RPMs.

B : The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group

C : It allows you to select the languages supported by the Oracle database server.

D : It can be done before installing Grid Infrastructure for a Standalone Server

E : The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group

F : It can be done after installing Grid Infrastructure for a Standalone Server.

G : The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.

Answer: A,D

Question 5

Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?

A : It uses multisection backup.

B : It uses parallelization for the backup set.

C : It uses asynchronousI/O for the backup.

D : It creates compressed backup sets.

Answer: B

Page: 1 / 57

Total 285 Questions | Updated On: Apr 02, 2026

Add To Cart