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: 4)
Oracle Database Administration II
Updated on: 31-Aug-2025

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

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?

  1. All the triggers associated with the table are flashed back but are disabled.
  2. Materialized views that use the CUSTOMERS table are flashed back.
  3. LOB segments associated with the CUSTOMERS table are flashed back.
  4. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
  5. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

Answer(s): C,D



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 4 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