Reinforce OCP concepts with active-recall study cards covering all 5 blueprint domains. Each card shows the question on the front and the correct answer with a full explanation on the back.
Flashcards work through active recall — the process of retrieving information from memory rather than passively re-reading it. Research consistently shows that active recall produces stronger, longer-lasting memory than re-reading study guides. For OCP preparation, this means flashcards are one of the highest-return study tools available.
Attempt recall first
Read the OCP question on each card, pause, and attempt to formulate the answer in your own words before revealing. This retrieval attempt — even if wrong — dramatically strengthens memory compared to immediately reading the answer.
Review wrong cards again
When you get a card wrong, note it and add it back to your review pile. Spaced repetition — seeing difficult cards more frequently — is the mechanism that makes flashcard study far more efficient than linear reading.
Study by domain
Group your OCP flashcard sessions by domain for the first 3–4 weeks. Master one domain before moving to the next. In the final week, shuffle all cards together to test cross-domain recall — which is what the real OCP exam requires.
Short sessions beat marathon reviews
20–30 flashcard cards per session, done daily, produces better retention than a single 200-card marathon session. Five short daily sessions per week over 4 weeks gives you over 400 total card reviews — enough to reliably pass OCP.
Sample cards from the OCP flashcard bank. Read the question, think of the answer, then read the explanation below.
You need to identify the top SQL statements consuming the most CPU resources in an Oracle 23ai database over the last hour. Which tool provides the most direct analysis of this performance issue?
Automatic Workload Repository (AWR) report
The AWR report is the most direct tool for identifying top SQL by CPU consumption over a specific time period such as the last hour. AWR automatically captures snapshots of performance statistics, including SQL ordered by CPU time, and the report presents this data in a ready-to-read format. ASH provides session-level sampling for shorter, more granular analysis, but AWR is the standard tool for hourly or longer-range top-SQL identification.
Which view provides information about the open status of all PDBs in a CDB?
V$PDBS
V$PDBS provides the current status of each PDB in the container database.
You are implementing AI Vector Search in Oracle Database 23ai. Which data type is mandatory for storing vector embeddings?
VECTOR
Oracle Database 23ai introduces the VECTOR data type specifically for storing vector embeddings, and it is mandatory for AI Vector Search because it defines the dimensions and numeric format needed for distance calculations. Other data types such as BLOB or CLOB can store binary or character data but do not carry the vector semantics, dimensions, or format required by vector indexes and functions.
Which view should you query to verify the encryption status of tablespaces in 23ai?
V$ENCRYPTED_TABLESPACES
V$ENCRYPTED_TABLESPACES shows the encryption status of all tablespaces in the database.
You need to ensure that RMAN automatically deletes archived redo logs after they have been backed up twice to tape. Which configuration command should you use?
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DEVICE TYPE SBT;
The correct RMAN syntax to automatically delete archived redo logs after they have been backed up a specified number of times to a device type is 'CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP n TIMES TO DEVICE TYPE <device>'. This policy tells RMAN to delete archived logs once the specified redundancy to the given device (SBT = tape) is satisfied.
You observe a significant performance regression after a database upgrade. You suspect that the optimizer has chosen a suboptimal execution plan. Which component of SQL Plan Management should you use to ensure the database only uses known, verified execution plans?
SQL Plan Baselines
SQL Plan Baselines are used to capture and freeze known good execution plans for SQL statements. When the optimizer considers a new plan, it compares it to the baseline; if the new plan is not verified as better, the baseline plan is used. This ensures that only verified plans are used, preventing performance regressions after an upgrade.
Which of the following is true regarding SQL Plan Baselines?
They provide stability for SQL execution plans
They allow the database to maintain a stable execution plan even if the environment (stats, indexes) changes.
You need to perform a full database restore and recovery. The control file is lost. What is the correct sequence of operations?
STARTUP NOMOUNT; RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT; RESTORE DATABASE; RECOVER DATABASE; ALTER DATABASE OPEN RESETLOGS;
After losing the control file, you must restore it from an autobackup before you can restore the datafiles and perform recovery.
What happens if a Lock-Free Reservation numeric value reaches its maximum allowed limit?
It raises an error
Lock-Free Reservation columns in Oracle use a bounded numeric range, and when the accumulated value hits the maximum allowed limit, Oracle raises an error rather than silently wrapping or continuing. This is by design to preserve data integrity — the reservation mechanism cannot represent values beyond its defined ceiling. The error forces the application or DBA to intervene (e.g., reset, archive, or widen the column) before further reservations can be made.
Which file needs to be updated when you move the wallet location in 23ai?
sqlnet.ora
The sqlnet.ora file contains the WALLET_LOCATION parameter that must be updated.
When using 'Snapshot Carousel', how many snapshots can a single PDB retain?
Defined by MAX_PDB_SNAPSHOTS
The number is managed by the MAX_PDB_SNAPSHOTS parameter.
What is the default behavior when a session is set to use True Cache?
Transparent read routing
The session automatically routes queries to the cache if valid.
A PDB named FINPDB in your CDB is currently open in READ WRITE mode and is actively serving users. You need to perform a planned maintenance operation that requires all user sessions to be disconnected and the PDB to be unavailable for new connections, but you want the operation to complete as quickly as possible without waiting for sessions to end naturally. Which command should you use?
ALTER PLUGGABLE DATABASE FINPDB CLOSE IMMEDIATE;
CLOSE IMMEDIATE is designed for planned maintenance where sessions must be terminated quickly and the PDB must become unavailable. It rolls back active transactions, disconnects users, and performs a checkpoint so the PDB can be reopened cleanly. A plain CLOSE waits indefinitely for sessions, CLOSE ABORT skips the checkpoint and risks recovery, and SAVE STATE only preserves open mode across instance restarts.
You have a query that is performing poorly due to a stale execution plan. You want to lock the current optimal plan to prevent the optimizer from changing it during subsequent runs. What should you do?
Use DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE
DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE loads existing plans from the cursor cache into SQL Plan Baselines, allowing you to lock the current optimal plan. This prevents the optimizer from changing it because the baseline will be used.
You are performing a cross-platform data migration from a Linux-based Oracle 23ai source database to a Solaris target. You intend to use RMAN CONVERT DATABASE. Which prerequisite must be met to ensure the migration succeeds?
The source and target platforms must have the same endian format.
When converting a database using RMAN, the source and target platforms must have the same endian format, or the conversion must be done via transportable tablespaces if the endianness differs. RMAN CONVERT DATABASE requires the platforms to share endianness.
Which report provides a summary of SQL statements that have the highest 'Elapsed Time'?
AWR Report
The AWR (Automatic Workload Repository) Report includes a section titled 'SQL ordered by Elapsed Time' that lists SQL statements ranked by total elapsed time, making it the correct choice. This report aggregates performance statistics over a snapshot interval, capturing the cumulative impact of each SQL statement. The Alert Log and Listener Log do not provide SQL-level performance summaries, and ADDM focuses on diagnostic findings rather than raw SQL timing.
In 23ai, when using the 'JSON relational duality' feature, how are changes to the JSON document propagated to the underlying tables?
Automatically propagated by the database
JSON Relational Duality in Oracle 23ai provides automatic bidirectional synchronization between JSON documents and their underlying relational tables. When a JSON document is updated through a duality view, the database automatically propagates the changes to the base tables using the defined mappings. No manual re-synchronization, triggers, or stored procedures are required.
Which command is used to start the AutoUpgrade process?
java -jar autoupgrade.jar
AutoUpgrade is Oracle's command-line utility for automating database upgrades, and it is invoked as a Java executable: 'java -jar autoupgrade.jar'. The tool then reads a config file specifying source and target homes, databases, and modes (analyze, fixups, deploy, upgrade).
In True Cache, how is consistency maintained with the primary database?
Asynchronous replication
True Cache maintains consistency with the primary database through asynchronous replication of redo/change data. The True Cache instance applies changes from the primary's redo stream in near real-time, so it is not transactionally synchronous but is kept current with low lag. This design lets True Cache serve read-only queries without blocking on the primary.
When using Blockchain Tables, what is the default behavior for rows that have reached their 'no drop' period?
Rows remain immutable until deleted manually
In Oracle Blockchain Tables, rows are immutable and cannot be updated or deleted until the 'no drop' period expires. After the no-drop period, the default behavior is that rows remain immutable until explicitly deleted by a user—they are not automatically purged. This preserves the tamper-evident nature of the blockchain table while allowing administrative cleanup.
When using SQL Tuning Advisor, what is a 'SQL Tuning Set' (STS)?
A container for SQL statements and their metadata
An STS is a collection of SQL statements with their associated execution context.
Which type of operation is ideal for Blockchain tables?
Audit logs and financial records
Blockchain tables are designed for insert-only, tamper-evident records where each row is cryptographically hashed and chained to the previous row. Audit logs and financial records are the ideal use case because they require an immutable, verifiable history that can be used for compliance and auditing. These tables prevent updates and deletions, ensuring data integrity and non-repudiation.
When reviewing an AWR report, you notice a high value for 'db time'. What does this indicate?
The total time spent by sessions in the database
'DB time' in an AWR report represents the cumulative time spent by all foreground sessions in database calls — essentially the total amount of work the database performed, including CPU and wait time. A high DB time relative to elapsed time indicates sessions are spending significant time waiting or consuming CPU, signaling potential performance pressure.
The OCP flashcard bank covers all 5 official blueprint domains published by Oracle. Cards are distributed proportionally, so domains with higher exam weight have more cards.
Domain Coverage
Performance Tuning And Diagnostics
Core Administration And Cdb Pdb Architecture
23ai New Features
Security And Upgrades
Backup And Recovery
Both flashcards and practice questions are evidence-based study tools. The difference is in what they train:
Flashcards — concept retention
Best for memorising definitions, acronyms, protocol behaviours, command syntax, and conceptual distinctions. Use flashcards to build the foundational vocabulary that OCP questions assume you know.
Best in: weeks 1–3
Practice tests — application
Best for applying concepts to realistic scenarios, eliminating distractors, and building exam stamina.OCP questions test scenario reasoning — not just recall — so practice tests are essential.
Best in: weeks 3–6
The most effective OCP study plan combines both: use flashcards for the first 2–3 weeks to build conceptual foundations, then shift to practice tests and mock exams in the final 2–3 weeks to apply and benchmark that knowledge. Most candidates who pass on their first attempt use both tools.
Yes. Courseiva provides free OCP flashcards across all official exam domains. Every card includes the correct answer and a full explanation of why it is right and why the distractors are wrong. The platform also includes topic-based practice, mock exams, and readiness tracking — no account required.
Courseiva has 261+ original OCP flashcards across all 5 exam blueprint domains. New cards are added regularly as the question bank grows. All cards are checked against the official Oracle exam objectives, with editorial oversight from an experienced network and security engineer.
Courseiva flashcards are purpose-built for IT certification exams. Unlike generic flashcard platforms where content quality varies, every Courseiva card is mapped to the official OCP exam blueprint, written by engineers who hold the certification, and includes a full explanation of the correct answer and why the distractors are wrong. This explanation quality is what separates genuine learning from rote memorisation.
Courseiva is a web platform — an internet connection is required. For offline study, we recommend creating free Courseiva account, using the platform in your browser, and using your device's offline capabilities if your browser supports offline web apps.
Save your results, see which domains need more work, and get spaced repetition recommendations — all free.
Sign Up FreeFree forever · Every certification included