Free Oracle 1Z0-083 Exam Questions

Absolute Free 1Z0-083 Exam Practice for Comprehensive Preparation

Oracle 1Z0-083 Exam Questions
Provided By: Oracle
Exam: Oracle Database Administration II
Certification: Oracle Database

Total Questions: 285
Updated On: Jul 25, 2026
Rated: 4.9 |
Online Users: 570

Page No. 1 of 57

Add To Cart

Question 1
- You have configured RMAN SBT channels to write backups to medi
  a. You then take an RMAN backup by using this command: Which three are true? (Choose three.)
  A : The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
  
  B : The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
  
  C : All archive logs created after this backup are kept for two years.
  
  D : The SPFILE is included in the self-contaied archival backup.
  
  E : The control file is included in the self-contained archival backup.
  
  F : The restore point is a label for the system change number (SCN) before the archival backup was taken.
  
  Answer: A,B,D
Question 2
- Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
  A : cloning a remote container database in interactive mode
  
  B : cloning a remote pluggable database in silent mode
  
  C : relocating a remote pluggable database in interactive mode
  
  D : relocating a remote container database in silent mode
  
  E : cloning a remote container database in silent mode
  
  F : relocating a remote pluggable database in silent mode
  
  G : relocating a remote container database in interactive mode.
  
  Answer: A,B
Question 3
- Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?
  A : 2,4,5,6
  
  B : 1,2,3,4,5,6
  
  C : 1,2,4,5
  
  D : 2,4,5
  
  E : 1,3,4,5
  
  Answer: D
Question 4
- 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 5
- 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

PAGE: 1 - 57

Add To Cart

We use cookies to ensure your best experience. So we hope you are happy to receive all cookies on the DumpsEngine.