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: 6)

Page 6 of 71
PDF with 286 Questions

Which two are true about common objects? (Choose two.)

  1. They can be created only in CDB$ROOT.
  2. They can be only metadata-linked in an application container.
  3. They can exist in user-defined schemas only in application containers.
  4. They can exist in CDB$ROOT and an application root.
  5. They can be extended data-linked in CDB$ROOT. F. They can be created only in an application root.

Answer(s): D



Which two are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  1. It analyzes a period of time corresponding to the 12 hours of activity.
  2. It runs automatically after each AWR snapshot.
  3. A DBA can run it manually.
  4. Results are written to the alert log.
  5. It analyzes a period of time corresponding to the last day of activity.

Answer(s): B,C



You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

  1. Database Replay
  2. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
  3. Active Session History (ASH) report
  4. SQL Performance Analyzer

Answer(s): B



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

  1. Enable Memory Access Mode, which reads performance data from SG
  2. Use emergency monitoring to fetch data directly from SGA for analysis.
  3. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
  4. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
  5. Run ADDM in diagnostic mode.

Answer(s): B



Viewing page 6 of 71



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

1z0-083 Exam Discussions & Posts