Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1z0-083

Oracle 1z0-083 Exam (page: 5)
Oracle Database Administration II
Updated on: 31-Aug-2025

Viewing Page 5 of 58
1z0-083 PDF 286 Questions

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?

  1. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
  2. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
  3. by using Active Session History (ASH) data and performing hang analysis
  4. by running ADDM in diagnostic mode

Answer(s): A



Which four are true about performance-related Oracle tools? (choose four.)

  1. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.
  2. SQL Performance Analyzer can suggest schema changes.
  3. SQL Performance Analyzer can identify regressed SQL statements.
  4. Database Replay always uses one replay client for all the original database sessions.
  5. Database Replay always uses one replay client for each original database session.
  6. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non¬consecutive periods.
  7. The Active Session History (ASH) report is based on wait event samples.

Answer(s): A,B,C,F



Which two are true about server-generated alerts? (Choose two.)

  1. Stateful alerts must be created by a DBA after resolving the problem.
  2. Stateless alerts can be purged manually from the alert history.
  3. Stateless alerts can be cleared manually.
  4. Stateless alerts are automatically cleared.
  5. Stateful alerts are purged automatically from the alert history

Answer(s): B,C



Which three are located by using environment variables?

  1. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
  2. the location of Oracle Net Services configuration files
  3. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
  4. default directories for temporary files used by temporary tablespaces
  5. the temporary disk space used by Oracle Installer during installation
  6. the maximum number of database files that can be opened by a database instance

Answer(s): A,B,E



Which three are true about opatch auto? (Choose three.)

  1. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
  2. It must be invoked by a user with root user privileges.
  3. Patches are applied via opatchauto.
  4. Users must always input patch plans to opatchauto.
  5. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
  6. It applies patches in nonrolling mode by default.
  7. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Answer(s): A,B,G



Viewing Page 5 of 58



Share your comments for Oracle 1z0-083 exam with other users:

Blessious Phiri 8/13/2023 10:32:00 AM

very explainable
Anonymous


Blessious Phiri 8/15/2023 3:38:00 PM

excellent topics covered
Anonymous


Blessious Phiri 8/12/2023 11:56:00 AM

its getting more technical
Anonymous


Blessious Phiri 8/15/2023 1:56:00 PM

asm management configuration is about storage
Anonymous


Blessious Phiri 8/14/2023 9:53:00 AM

cbd and pdb are key to the database
SOUTH AFRICA


Blessious Phiri 8/13/2023 11:58:00 AM

becoming interesting on the logical part of the cdbs and pdbs
Anonymous


Blessious Phiri 8/13/2023 10:26:00 AM

admin ii is real technical stuff
Anonymous


Blessious Phiri 8/12/2023 2:19:00 PM

so challenging
Anonymous


Blessious Phiri 8/13/2023 8:37:00 AM

making progress
Anonymous


Blessious Phiri 8/15/2023 3:19:00 PM

oracle 19c is complex db
Anonymous


Blessious Phiri 8/13/2023 9:35:00 AM

rman is one good recovery technology
Anonymous


Blessious Phiri 8/14/2023 3:49:00 PM

expository experience
Anonymous


Blessious Phiri 8/15/2023 3:31:00 PM

these questions are a great eye opener
Anonymous


Blessious Phiri 8/15/2023 2:18:00 PM

pdb and cdb are critical to the database
Anonymous


Blessious Phiri 8/13/2023 3:10:00 PM

control file is the heart of rman backup
Anonymous


Blessious Phiri 8/12/2023 11:47:00 AM

the exams are giving me an eye opener
Anonymous


Blessious Phiri 8/15/2023 2:02:00 PM

dbua is used for upgrading oracle database
Anonymous


Blessious Phiri 8/15/2023 4:08:00 PM

its giving best technical knowledge
Anonymous