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: May 24, 2026
Rated: 4.9 |
Online Users: 570

Page No. 1 of 57

Add To Cart

Question 1
- Choose the best answer. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
 A : log writer performance
 
 B : database writer performance
 
 C : general operating system health
 
 D : SQL statements
 
 E : database instance memory management and sizes
 
 Answer: C
Question 2
- 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 3
- 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 4
- Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADAT 3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands: $ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type --------------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?
  
  A : SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.
  
  B : SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows
  
  C : It will return an error because the SYNC operation is not allowed when constraints are added to common objects.
  
  D : It will return an error because EMP is not empty in APP_ROOT.
  
  E : It will return an error because EMP.SAL is empty in APP_ROOT.
  
  Answer: D
Question 5
- Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
  A : After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
  
  B : Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT
  
  C : After the change, only one undo tablespace can exist in CDB$ROOT.
  
  D : After the change, any user with the required privilege can create an undo tablespace in the PDBs.
  
  E : Undo tablespaces existing in PDBs must be dropped before the change.
  
  F : After the change, each existing PDB has to be reopened for the new undo mode to take effect.
  
  Answer: A,B

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.