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

QUESTION NO: 1
Which two actions are performed by the Data Recovery Advisor (DRA)?
(Choose two)

A. Suggesting and generating repair scripts B. Identifying physical datafile corruption C. Dropping damaged user schemas automatically D. Automatically applying OS-level patches

Correct Answer: A,B

QUESTION NO: 2
What occurs when you execute the ALTER PLUGGABLE DATABASE pdb1 OPEN command without specifying any additional clauses?

A. The PDB opens in read-write mode but returns to MOUNT state on CDB restart B. The PDB opens only for read-only transactions and remains in that mode permanently C. The PDB cannot open unless an instance parameter is modified D. The PDB opens in read-write mode and remains open permanently

Correct Answer: A

QUESTION NO: 3
What advantage does Flashback Database provide over traditional point-in-time recovery?

A. It creates guaranteed restore points automatically for every transaction B. It replaces undo segments with archived redo C. It eliminates the need for any redo logs D. It allows rewinding the entire database quickly using flashback logs instead of restoring backups

Correct Answer: D

QUESTION NO: 4
What view provides information about active RMAN sessions and backup operations?

A. V$BACKUP_SESSION B. V$RMAN_OUTPUT C. V$SESSION_LONGOPS D. V$RMAN_STATUS

Correct Answer: D

QUESTION NO: 5
What is the function of SQL Plan Baselines?

A. To disable adaptive query optimization features B. To lock execution plans for a fixed period C. To ensure the optimizer uses only known, verified execution plans D. To dynamically change SQL text at runtime

Correct Answer: C

QUESTION NO: 6
How does the CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb_admin IDENTIFIED BY password; statement function?

A. It converts the current root database into a PDB named pdb1 B. It creates a new root container with the name pdb1 C. It generates only metadata for pdb1 without any datafiles D. It clones the seed database to create pdb1 with its own administrative user

Correct Answer: D

QUESTION NO: 7
What is the purpose of using bind variables in SQL statements?

A. To generate automatic statistics for queries B. To reduce SQL parse overhead and improve plan reuse C. To force index usage regardless of optimizer choice D. To bypass cost-based optimization

Correct Answer: B

QUESTION NO: 8
What differentiates an Application PDB from a regular PDB in Oracle 23ai multitenant architecture?

A. Application PDBs share a common application root that enables simplified patching and upgrades B. Application PDBs require dedicated listener processes C. Application PDBs cannot host schemas or objects D. Application PDBs automatically inherit all common users from all other PDBs

Correct Answer: A