Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1z0-083

Free Oracle 1z0-083 Exam Questions (page: 7)

Page 7 of 71
PDF with 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



Viewing page 7 of 71



Post your Comments and Discuss Oracle 1z0-083 exam prep with other Community members:

1z0-083 Exam Discussions & Posts