Weekend Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale65best

Free Oracle 1z0-083 Practice Exam with Questions & Answers | Set: 8

Questions 71

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.)

Options:
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.

Oracle 1z0-083 Premium Access
Questions 72

Which two are true about gathering optimizer statistics? (Choose two.)

Options:
A.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.

B.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.

C.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

D.

System statistics can be gathered only while connected to CDB$ROOT.

E.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Questions 73

Choose two. Some archived log backups have been accidentally deleted from storage. Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups?

Options:
A.

RESYNC CATALOG

B.

CROSSCHECK BACKUP OF ARCHIVELOG ALL

C.

LIST ARCHIVELOG ALL

D.

LIST EXPIRED

E.

LIST ARCHIVELOG

F.

REPORT OBSOLETE

Questions 74

Choose three. Which three capabilities require the use of the RMAN recovery catalog?

Options:
A.

using RMAN stored scripts

B.

creating encrypted backups

C.

creating customized reports about a single database's backups

D.

using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

E.

using the KEEP FOREVER clause with the BACKUP command

F.

using the REPORT SCHEMA command to list a database's current data files and tablespaces

Questions 75

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

Options:
A.

defining primary keys for all tables to speed up all queries

B.

using check constraints to speed up updates

C.

defining foreign keys for all tables to speed up joins

D.

the physical data model

E.

the configuration of storage arrays

Questions 76

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN -----------------------2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?

Options:
A.

CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

B.

CDB1_TAB and APP_PDB1_TAB

C.

CDB1_TAB and APP_ROOT_TAB

D.

CDB1_TAB only

E.

none of the tables, because all three tables will be dropped

Questions 77

Choose two. Which two are true about RMAN Multisection backups when a very large data file is divided into four sections?

Options:
A.

The four sections must be image copies.

B.

Each of the file sections must be processed serially.

C.

The four sections must be contained in backup sets.

D.

The four sections can be created in parallel.

E.

The four sections can be created serially.

Questions 78

A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it. The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT. Which three are true? (Choose three.)

Options:
A.

Data file 24 can be recovered only while connected to PDB2.

B.

Data file 24 can be restored and recovered while connected to CDB$ROOT.

C.

Data file 24 can be restored only while connected to CDB$ROOT.

D.

Data file 24 can be restored only while connected to PDB2.

E.

Data file 24 can be recovered while connected to PDB2.

F.

Data file 24 can be recovered while connected to CDB$ROOT.

Questions 79

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?

Options:
A.

It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.

B.

It fails because the command does notspecify when the unified audit policy should be enforced.

C.

It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

D.

It fails because system privileges cannot be granted with roles in the same audit policy.

Questions 80

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

Options:
A.

SBT tape compression can be used even if no RMAN compression is configured.

B.

Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

C.

Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

D.

SBT tape compression and RMAN backup compression should be used in parallel.

E.

The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

Exam Code: 1z0-083
Certification Provider: Oracle
Exam Name: Oracle Database Administration II
Last Update: Jul 13, 2025
Questions: 286

Oracle Related Exams

How to pass Oracle 1z0-082 - Oracle Database Administration I Exam
How to pass Oracle 1z0-078 - Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Exam
1z0-1122-24 - Oracle Cloud Infrastructure 2024 AI Foundations Associate
1z0-1056-25 - Oracle Financials Cloud: Receivables 2025 Implementation Professional
1z0-1108-2 - Oracle Sales Business Process Foundations Associate Rel 2
1z0-1091-25 - Oracle Utilities Meter Solution Cloud Service 2025 Implementation Professional
1z0-1060-25 - Oracle Accounting Hub Cloud 2025 Implementation Professional
1z0-1121-25 - Oracle Cloud Infrastructure 2025 Networking Professional - Beta
1z0-1115-25 - Oracle Cloud Infrastructure 2025 Multicloud Architect Associate
1z0-911 - MySQL Developer Specialist
1z0-1045-25 - Oracle Warehouse Management Cloud 2025 Implementation Professional
1z0-997-25 - Oracle Cloud Infrastructure 2025 Architect Professional
1z0-106 - Oracle Linux 8 Advanced System Administration
1z0-1096-24 - Oracle Machine Learning using Autonomous Database 2024 Associate
1z0-902 - Oracle Exadata Database Machine X9M Implementation Essentials
Oracle Free Access
Get Oracle Full Access

Oracle Free Exams
Oracle Free Exams
Examstrack offers comprehensive free resources and practice tests for Oracle exams.