Oracle AI Database Administration Professional - 1Z1-183 Exam Questions [2026]

QUESTION NO: 1
When executing an incomplete recovery using RMAN, which additional step is mandatory after applying archived redo logs?

A. Enabling block change tracking B. Opening the database with RESETLOGS C. Creating a new password file D. Running CATPROC.SQL to recompile PL/SQL packages

Correct Answer: B

QUESTION NO: 2
How does Oracle Enterprise Manager (OEM) assist in monitoring application performance?

A. By providing end-to-end application tracing with SQL response time analysis B. By only reporting on system resource utilization, not SQL performance C. By disabling SQL plan baselines automatically during tuning D. By locking optimizer statistics to prevent changes

Correct Answer: A

QUESTION NO: 3
What is the difference between opatch and opatchauto
Response:

A. opatch can patch Grid Infrastructure, but opatchauto cannot B. opatch is GUI-based, while opatchauto is command-line only C. opatchauto handles both GI and database patching, while opatch is used for a single Oracle Home D. opatchauto applies interim patches, and opatch applies bundle patches

Correct Answer: C

QUESTION NO: 4
Which two tools are part of the Real Application Testing option?
(Choose two)

A. SQL Performance Analyzer (SPA) B. Active Session History (ASH) C. LogMiner D. Database Replay

Correct Answer: A,D

QUESTION NO: 5
Which two components are used for SQL plan stability?
(Choose two)

A. Undo Tablespace B. SQL Profiles C. Adaptive Cursor Sharing D. SQL Plan Baselines

Correct Answer: B,D

QUESTION NO: 6
Which two actions are required to enable the In-Memory Column Store?
(Choose two)

A. Enable DB_CACHE_SIZE to maximum B. Disable redo log archiving C. Mark objects with the INMEMORY attribute D. Set the INMEMORY_SIZE initialization parameter

Correct Answer: C,D

QUESTION NO: 7
What is the effect of issuing ALTER PLUGGABLE DATABASE ALL OPEN READ ONLY;?

A. All user-created PDBs except PDB$SEED open in read-only mode B. Only PDB$SEED opens, as it is the default template PDB C. All PDBs in the CDB are opened in READ WRITE mode D. The command fails because PDB$SEED cannot change open mode

Correct Answer: A

QUESTION NO: 8
How does enabling the In-Memory Column Store improve analytic query performance?

A. By eliminating the need for indexes entirely B. By converting tables to columnar format in memory, accelerating scans and aggregations C. By storing all tables in row format for faster transactional access D. By automatically converting redo logs into analytical indexes

Correct Answer: B