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

Add To Cart

Question 1

Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba SQL> STARTUP ....... Database opened. SQL> SHOW PDBS CON_ID CON_NAME --------------------------------------------------------------------OPEN MODE READ ONLY NO MOUNTED MOUNTED SQL> ALTER PLUGGABLE Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE; Pluggable database altered. SQL> ALTER PLUGGABLE A DATABASE pdb2 OPEN; Pluggable database altered. CDB1 is then restarted. Which three are true?

A : PDB2 will be opened READ WRITE.

B : PDB1 will be opened READ WRITE.

C : PDB1 will be MOUNTED.

D : PDB$SEED will be opened READ ONLY.

E : PDB$SEED will be MOUNTED

F : PDB2 will be MOUNTED.

Answer: A,B,D

Question 2

Choose two. Which two are true about various Oracle security and auditing capabilities?

A : Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.

B : Application-common TSDP policies are always container specific.

C : Application-common OLS policies can be created only if all the PDBs in the application container are closed.

D : Unified auditing can be automatically synchronized to all application PDBs in an application container.

E : Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.

Answer: A,D

Question 3

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 4

Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOTis an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully: Which two are true? (Choose two.)

A : APP1_USER1can be created in PDB1.

B : APP1_USER1can be created in CDB1.

C : APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

D : C##_APP_USER1 can be created in CDB1.

E : P1_USER1can be created in CDB1.

F : C##_USER1will have the same privileges and roles granted in all PDBs in CDB1.

Answer: C,D

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Apr 14, 2026

Add To Cart