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

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

A : PDB1 and PDB2 are in MOUNT state.

B : Redo logs are opened.

C : PDB1 and PDB2 are in READ ONLY state.

D : CDB$ROOT is in MOUNT state.

E : PDB$SEED is in READ ONLY state.

Answer: A,D

Question 2

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 3

Which two are true about RMAN duplexed backup sets? (Choose two.)

A : A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

B : A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

C : A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

D : A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

E : A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

F : A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

Answer: B,D

Question 4

choose two Which two statements are true about encrypted backups performed by using RMAN?

A : Transparent encryption of backups uses an encryption wallet.

B : Image copy backups can be created by using password encryption.

C : A password encryption of backups uses the password while creating and restoring backups.

D : Encrypted backups can only be written to disk.

E : A database uses the same encryption key for every encrypted backup.

Answer: A,C

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Dec 06, 2025

Add To Cart