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: Jun 05, 2025

Add To Cart

Question 1

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

A : Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.

B : A connection to an auxiliary instance is always required.

C : A subset of the target database can be duplicated.

D : A new DBID is always created for the duplicated database.

E : A connection to the recovery catalog instance is always required.

F : A backup of the target database is always required.

G : Duplication can be done by having the target database instance push copies to the auxiliary database instance.

H : A connection to the target database instance is always required.

Answer: A,B,C

Question 2

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 3

You execute the following piece of code with appropriate privileges: BEGIN DBMS_REDACT.ADD_POLICY ( END; object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP', => 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT (''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); END; BEGIN DBMS_REDACT.ADD_POLICY ( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP_VW', => 'SAL', => 'SCOTT_EMP_VW', => DBMS_REDACT.NONE, => 'SYS_CONTEXT (''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A : DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheMGR role set.

B : DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.

C : Data is never redacted for the EMP_VW.SAL column.

D : Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E : Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. Correct

Answer: A,C

Question 4

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 5

Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

A : redo logs

B : control files

C : all data dictionary metadata

D : user-defined PL/SQL packages

E : temporary tablespaces

F : mandatory Oracle-supplied PL/SQL packages

G : undo tablespaces

Answer: A,B,C

Page: 1 / 57

Total 285 Questions | Updated On: Jun 05, 2025

Add To Cart