What does an Automatic Workload Repository (AWR) report primarily show?
Select an option, then click Submit answer.
- ○ It compares two snapshots
- ○ It stores only current sessions
- ○ It replaces the alert log
- ○ It runs SQL Tuning Advisor
Showing 1–10 of 10 questions
What does an Automatic Workload Repository (AWR) report primarily show?
Select an option, then click Submit answer.
What is the SQL Tuning Advisor used for?
Select an option, then click Submit answer.
Which two statements about performance tuning methodology are correct? (Choose two.)
Select all that apply, then click Submit answer.
What is the purpose of an AWR baseline?
Select an option, then click Submit answer.
Why use SQL Plan Management with plan baselines?
Select an option, then click Submit answer.
What problem does Adaptive Cursor Sharing address?
Select an option, then click Submit answer.
What does the Database In-Memory column store accelerate?
Select an option, then click Submit answer.
What does Real Application Testing let a DBA do before a database upgrade?
Select an option, then click Submit answer.
Which two statements about ADDM are correct? (Choose two.)
Select all that apply, then click Submit answer.
What does Active Session History (ASH) provide?
Select an option, then click Submit answer.
This page holds a free practice test for the Oracle AI Database Administration Professional exam (1Z0-183), the exam that earns the Oracle AI Database Administration Certified Professional credential. The questions follow Oracle's official blueprint and its published weights — performance tuning at 25%, then multitenant architecture, backup and recovery, and AI Database new features at 20% each.
The free demo runs in the web test engine with no signup. The full practice test carries the complete question bank with an explanation for every answer.
Work through the questions in study mode first, checking the explanation for every answer — the 1Z0-183 exam rewards administrators who can pick the right RMAN, multitenant or tuning action for a described situation. When your study scores are steady, switch to timed mode to rehearse the real exam's 120-minute pace for 65 questions.
Worth 25% of the exam: tuning diagnostics, metrics and baselines, AWR analysis, SQL optimisation, Real Application Testing, instance tuning and the In-Memory column store.
Worth 20%: creating CDBs and PDBs with DBCA, application PDBs, day-to-day CDB and PDB management, multitenant security, PDB upgrades and transport.
Worth 20%: RMAN configuration and use, backup strategy, failure diagnosis, complete recovery, Flashback technologies, transportable tablespaces, duplication and RMAN tuning.
Worth 20%: AI Vector Search, Lock-Free Reservations, True Cache, Blockchain Tables, JSON Relational Duality and the latest availability, manageability and security enhancements.
Worth 15%: installing Grid Infrastructure and the database, creating databases with DBCA, patching, Oracle Restart configuration, and upgrading Grid Infrastructure and the database.
Yes — the demo practice test on this page is free and needs no signup. The full bank of practice questions, with explanations for every answer, is in the premium practice test.
The full practice test holds 80 questions written to Oracle's official 1Z0-183 blueprint and its published domain weightings; the free demo shows a 10-question sample.
Yes. The real exam is 65 multiple-choice questions in 120 minutes with a 60% pass mark, and these practice questions follow the same administration scenarios and weighting.