Career upgrade: Learn practical AI skills for better jobs and higher pay.
Level up
PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free Oracle DB 23ai Admin Practice Questions

Pass your Oracle Database 23ai Administrator Professional exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
~55-65% Pass Rate
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

Which object stores a workload of SQL statements with execution context and statistics so it can be used by SQL Tuning Advisor or SQL Performance Analyzer?

A
B
C
D
to track
Same family resources

Explore More Oracle Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Oracle SQL

Practice Questions1 blog

OCI AI Foundations

Practice Questions

OCI Architect

Practice Questions

OCI Foundations

Practice Questions

Oracle DBA

Practice Questions

OCI 2025 Data Science Professional (1Z0-1110-25)

Practice Questions

More From This Family

Videos and articles for deeper review.

ArticleOracle SQL 1Z0-071 Exam Guide 2026: Official Facts, Topic Traps, and Practice Plan12 min read
2026 Statistics

Key Facts: Oracle DB 23ai Admin Exam

~75

Exam Questions

Oracle

90 min

Exam Duration

Oracle

60-66%

Passing Score

Oracle (scaled)

$245

Exam Fee

Oracle/Pearson VUE

2 years

Certification Validity

Oracle

20-25%

Multitenant Domain

Largest domain

The Oracle 23ai Administrator Professional exam has ~75 questions in 90 minutes. Key domains: Multitenant CDB/PDB (20-25%), RMAN Backup/Recovery (20-25%), Performance Management (15-20%), Security (10-15%), Storage/ASM (10-12%), and 23ai New Features including AI Vector Search (8-12%). Exam fee is $245. Certification valid 2 years. Available in-person or online proctored through Pearson VUE.

Sample Oracle DB 23ai Admin Practice Questions

Try these sample questions to test your Oracle DB 23ai Admin exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1In Oracle 23ai, which background process is responsible for writing dirty buffers from the database buffer cache to data files?
A.LGWR
B.DBWR
C.CKPT
D.SMON
Explanation: DBWR (Database Writer) is responsible for writing modified (dirty) buffers from the database buffer cache to data files on disk. It does this when the buffer cache needs free buffers or at checkpoints.
2Which Oracle 23ai initialization parameter must be set to CDB$ROOT-level to enable the multitenant architecture with multiple PDBs?
A.ENABLE_PLUGGABLE_DATABASE
B.CONTAINER_DATA
C.ENABLE_DDL_LOGGING
D.MAX_PDBS
Explanation: ENABLE_PLUGGABLE_DATABASE=TRUE is required in the CDB initialization parameter file to enable the multitenant container database architecture. Without it, the database operates in non-CDB mode.
3A DBA needs to create a PDB by cloning an existing PDB named HRPDB while it remains open. Which SQL statement accomplishes this?
A.CREATE PLUGGABLE DATABASE HRPDB_CLONE FROM HRPDB;
B.CREATE PLUGGABLE DATABASE HRPDB_CLONE FROM HRPDB SNAPSHOT COPY;
C.CREATE PLUGGABLE DATABASE HRPDB_CLONE FROM HRPDB FILE_NAME_CONVERT=('/hrpdb/','/hrpdb_clone/');
D.CREATE PLUGGABLE DATABASE HRPDB_CLONE CLONE FROM HRPDB OPEN RESTRICTED;
Explanation: To clone an open PDB (hot clone), use CREATE PLUGGABLE DATABASE ... FROM ... with FILE_NAME_CONVERT to map the source data file paths to new destination paths. Oracle 12.2+ supports hot cloning without closing the source PDB.
4Which view provides information about all PDBs within a CDB, including their OPEN_MODE and RESTRICTED status?
A.DBA_PDBS
B.V$PDBS
C.V$DATABASE
D.CDB_PDB_HISTORY
Explanation: V$PDBS displays information about all pluggable databases in the CDB, including NAME, CON_ID, OPEN_MODE, RESTRICTED, CREATION_TIME, and other runtime attributes. It is the primary dynamic performance view for PDB status.
5A DBA wants to prevent a PDB from running Java stored procedures while still allowing SQL and PL/SQL. Which feature should be used?
A.Resource Manager PDB directives
B.PDB Lockdown Profile
C.Database Vault realms
D.PDB isolation parameter CONTAINERS_PARALLEL_DEGREE
Explanation: PDB Lockdown Profiles restrict operations within a PDB without affecting other PDBs. A DBA creates a profile with DISABLE JAVA option and assigns it to the PDB using the PDB_LOCKDOWN initialization parameter.
6Which RMAN command creates a level 0 incremental backup of the entire CDB?
A.BACKUP INCREMENTAL LEVEL 0 DATABASE;
B.BACKUP FULL DATABASE;
C.BACKUP INCREMENTAL LEVEL 0 CDB;
D.BACKUP DATABASE PLUS ARCHIVELOG;
Explanation: BACKUP INCREMENTAL LEVEL 0 DATABASE; creates a level 0 incremental backup, which backs up all data blocks that have ever been used. This is the baseline for subsequent level 1 incremental backups.
7During an RMAN recovery, the DBA wants to restore the database to a point in time before a table was accidentally dropped at 14:00. Which command sequence is correct?
A.RESTORE DATABASE; RECOVER DATABASE UNTIL TIME '2026-05-19 13:55:00';
B.RECOVER DATABASE UNTIL TIME '2026-05-19 13:55:00'; RESTORE DATABASE;
C.FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2026-05-19 13:55:00','YYYY-MM-DD HH24:MI:SS');
D.RESTORE DATABASE UNTIL TIME '2026-05-19 13:55:00';
Explanation: For point-in-time recovery (PITR), the correct RMAN sequence is: (1) shut down and mount the database, (2) RESTORE DATABASE, then (3) RECOVER DATABASE UNTIL TIME '...'. RESTORE must precede RECOVER.
8Which Oracle feature allows an individual row or table to be recovered without restoring and recovering the entire database?
A.RMAN PITR
B.Flashback Table
C.Data Recovery Advisor
D.RMAN Transportable Tablespace
Explanation: Flashback Table uses undo data to restore a table to a previous state without database downtime. The command is FLASHBACK TABLE <table> TO TIMESTAMP <time>. It requires ROW MOVEMENT to be enabled on the table.
9Which view shows RMAN backup sets and their component backup pieces in the control file catalog?
A.V$BACKUP_SET and V$BACKUP_PIECE
B.DBA_BACKUP_JOBS
C.RMAN$BACKUP_FILES
D.V$RMAN_CONFIGURATION
Explanation: V$BACKUP_SET shows information about backup sets (logical groupings of backup pieces), and V$BACKUP_PIECE shows individual physical backup files. Together they provide a complete picture of RMAN backups tracked in the control file.
10A DBA configures Active Data Guard on Oracle 23ai. What is the primary advantage of Active Data Guard over a standard physical standby?
A.Active Data Guard allows the standby database to be open read-write while receiving redo
B.Active Data Guard allows the standby database to be open read-only while continuously applying redo
C.Active Data Guard eliminates the need for archiving on the primary
D.Active Data Guard supports logical standby replication using SQL Apply
Explanation: Active Data Guard keeps the physical standby database open in READ ONLY mode while simultaneously applying redo from the primary (real-time apply). This allows read workloads to be offloaded to the standby without any RPO impact.

About the Oracle DB 23ai Admin Exam

The Oracle Database 23ai Administrator Professional exam (1Z0-083) validates advanced Oracle DBA skills for the 23ai release. It covers multitenant container database (CDB) and pluggable database (PDB) management, RMAN backup and recovery, Active Data Guard, ASM storage, performance tuning (AWR/ASH/ADDM), database security (TDE, VPD, unified auditing), patching, and 23ai new features including AI Vector Search and JSON Relational Duality Views.

Questions

75 scored questions

Time Limit

90 minutes

Passing Score

60-66% (scaled)

Exam Fee

$245 (Oracle / Pearson VUE)

Oracle DB 23ai Admin Exam Content Outline

20-25%

Multitenant (CDB/PDB)

Creating, cloning, and managing pluggable databases; application containers; PDB lockdown profiles; CDB/PDB resource management plans; plugging/unplugging PDBs; PDB snapshots

20-25%

Backup and Recovery (RMAN)

RMAN architecture and catalog; backup strategies (full, incremental, cumulative); complete and incomplete recovery; PITR; flashback database and table; Data Recovery Advisor; cross-platform transport

15-20%

Performance Management

AWR baselines and snapshots, ASH real-time sampling, ADDM analysis, SQL Tuning Advisor, SQL Access Advisor, adaptive execution plans, Real-Time SQL Monitoring, wait event analysis

10-15%

Security

Transparent Data Encryption (TDE) keystore and tablespace encryption, Virtual Private Database (VPD) policies, unified auditing policies and conditions, privilege analysis, Oracle Database Vault

10-12%

Storage and ASM

ASM disk groups, failure groups, rebalancing, ASM Filter Driver, ACFS, Oracle Managed Files (OMF), tablespace compression and encryption, ILM tiering

10-15%

Architecture and Administration

Oracle 23ai memory structures (SGA, PGA), background processes, initialization parameters, alert log, ADR, patching (opatch, datapatch, AutoUpgrade), upgrade and migration

8-12%

23ai New Features

AI Vector Search (VECTOR data type, DBMS_VECTOR, similarity functions), JSON Relational Duality Views, True Cache, Schema Privileges, IF [NOT] EXISTS DDL, domain data types, annotations

How to Pass the Oracle DB 23ai Admin Exam

What You Need to Know

  • Passing score: 60-66% (scaled)
  • Exam length: 75 questions
  • Time limit: 90 minutes
  • Exam fee: $245

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

Oracle DB 23ai Admin Study Tips from Top Performers

1Prioritize multitenant — CDB/PDB questions make up 20-25% of the exam; know PDB cloning, application containers, and lockdown profiles
2Master RMAN recovery scenarios: practice complete recovery, PITR, and flashback database in a lab environment
3Know AWR vs ASH vs ADDM: AWR stores historical snapshots, ASH samples active sessions in real time, ADDM analyzes both
4Understand TDE keystores: software keystore vs. hardware HSM, auto-login vs. password-protected, tablespace vs. column encryption
5Study ASM architecture: disk groups, failure groups (mirroring), rebalance operations, and ACFS filesystem
6Know Oracle 23ai new features tested on exam: AI Vector Search (VECTOR type, DBMS_VECTOR), JSON Duality Views, True Cache, Schema Privileges
7Use Oracle 23ai Free Developer Edition for hands-on lab practice — it is free and full-featured
8Learn AutoUpgrade tool for patching and upgrades — it is the recommended method from Oracle 19c onward

Frequently Asked Questions

What exam number is the Oracle 23ai Administrator Professional?

The Oracle Database 23ai Administrator Professional exam is numbered 1Z0-083. It replaced the 1Z0-082 (Administration I) and 1Z0-083 lineage for the 23ai release and is available through Pearson VUE.

What is Oracle AI Vector Search?

AI Vector Search is an Oracle 23ai feature that stores and indexes vector embeddings using the VECTOR data type. It enables semantic/similarity search directly in the Oracle database using DBMS_VECTOR APIs, cosine distance functions, and approximate nearest neighbor (ANN) index types like IVF and HNSW.

What are JSON Relational Duality Views?

JSON Relational Duality Views are an Oracle 23ai feature that exposes relational tables as JSON documents without data duplication. Applications can read and write JSON while Oracle manages the underlying relational storage, combining the flexibility of JSON with ACID transactional guarantees.

What RMAN concepts are tested?

RMAN topics include: backup types (full, level 0/1 incremental, cumulative), RMAN catalog vs. control file, complete recovery, incomplete/PITR recovery, flashback database, flashback table, Data Recovery Advisor, cross-platform transport, and backup encryption and compression.

How should I prepare for the Oracle 23ai exam?

Plan 80-120 hours over 2-3 months. Use Oracle University courses or the official Oracle 23ai documentation. Focus on multitenant (heaviest domain), RMAN, and performance tuning. Set up a hands-on Oracle 23ai Free Developer Edition lab. Complete 100+ practice questions and target 75%+ before scheduling.

What is True Cache in Oracle 23ai?

True Cache is an Oracle 23ai feature that provides an application-tier read-only cache of Oracle Database data. It is fully consistent with the primary database and requires no application code changes, enabling horizontal read scaling without the complexity of traditional caching layers.