Oracle Certified Master (OCM) - Oracle Database 19c — Questions and Answers

Question 1: What is a Proxy PDB in Oracle Multitenant?

A PDB restricted to read-only access for auditing purposes
A PDB template used to create other PDBs
A local PDB that transparently forwards SQL to a remote PDB in a different CDB (Correct answer)
A standby PDB in an Active Data Guard configuration

Correct answer: A local PDB that transparently forwards SQL to a remote PDB in a different CDB

A Proxy PDB is a local database link-based construct that provides seamless connectivity to a PDB residing in a remote CDB, making the remote PDB appear local.

Question 2: What is the MOST important consideration when implementing system architecture & design solutions in Oracle Certified Master?

Minimizing initial cost without considering long-term value
Selecting solutions based on vendor popularity alone
Using the newest technology regardless of fit
Alignment with organizational needs and scalability requirements (Correct answer)

Correct answer: Alignment with organizational needs and scalability requirements

Technology solutions must align with organizational needs and scale appropriately to deliver value both now and in the future.

Question 3: What is the primary purpose of Application Containers introduced in Oracle 19c Multitenant?

Docker containers used to deploy Oracle Application Express instances
A set of PDBs managed centrally by Oracle Cloud Infrastructure
A CDB-level tier that groups related PDBs sharing a common application schema installed once (Correct answer)
WebLogic application server containers that connect to multiple PDBs

Correct answer: A CDB-level tier that groups related PDBs sharing a common application schema installed once

Application Containers introduce an additional hierarchy tier where multiple application PDBs share a master application schema defined at the application root, eliminating redundant schema deployment.

Question 4: What is the MOST effective way to stay current with developments in implementation & configuration for Oracle Certified Master?

Reading only internal communications
Following a single expert opinions
Relying on experience gained early in career
Participating in professional development, industry events, and peer collaboration (Correct answer)

Correct answer: Participating in professional development, industry events, and peer collaboration

A multi-faceted approach including formal development, industry events, and peer collaboration provides the broadest perspective on current developments.

Question 5: What clause must be appended when granting a privilege to a common user so the grant applies across all containers in the CDB?

WITH CONTAINER = ALL (Correct answer)
GLOBAL = TRUE
FOR ALL CONTAINERS
CDB_WIDE = TRUE

Correct answer: WITH CONTAINER = ALL

Appending WITH CONTAINER = ALL to a GRANT statement extends the privilege to the common user in CDB$ROOT and all existing and future PDBs.

Question 6: What is the function of Oracle's Automatic Workload Repository (AWR)?

Captures and retains database performance statistics snapshots for analysis (Correct answer)
Provides real-time SQL monitoring dashboards
Manages automatic memory allocation for PGA and SGA
Stores execution plans in the SQL Plan Baseline

Correct answer: Captures and retains database performance statistics snapshots for analysis

AWR automatically collects and stores database performance statistics in periodic snapshots (default every 60 minutes) retained for 8 days for historical analysis and tuning.

Question 7: Which Oracle dynamic performance view provides real-time information about all containers (root, seed, and PDBs) in the current CDB?

V$CONTAINERS (Correct answer)
DBA_CONTAINERS
V$DATABASE
ALL_PDBS

Correct answer: V$CONTAINERS

V$CONTAINERS is the dynamic performance view that lists every container in the CDB including CDB$ROOT, PDB$SEED, and all user-created PDBs.

Question 8: Which factor BEST indicates mastery of implementation & configuration in Oracle Certified Master?

The ability to adapt knowledge and skills to varying contexts while maintaining standards (Correct answer)
Years of experience in a single setting
Number of certifications held
Speed of task completion

Correct answer: The ability to adapt knowledge and skills to varying contexts while maintaining standards

True mastery is demonstrated by the ability to apply knowledge flexibly across different contexts while consistently maintaining quality standards.

Question 9: In Oracle Certified Master, which network design & administration practice BEST ensures system reliability?

Implementing redundancy, regular testing, and documented recovery procedures (Correct answer)
Updating systems only when vendors release patches
Relying on a single point of contact for all technical issues
Running systems until failure occurs

Correct answer: Implementing redundancy, regular testing, and documented recovery procedures

Redundancy, regular testing, and documented recovery procedures create a robust environment that minimizes downtime and data loss.

Question 10: What is the PRIMARY purpose of documentation & best practices in Oracle Certified Master?

To limit access to information
To create paperwork for filing purposes
To satisfy audit requirements only
To provide accurate, accessible information for decision-making and compliance (Correct answer)

Correct answer: To provide accurate, accessible information for decision-making and compliance

Data and documentation exist primarily to provide accurate, accessible information that supports both decision-making and regulatory compliance.

Question 11: When unplugging a PDB using ALTER PLUGGABLE DATABASE UNPLUG INTO, what type of file is created to store the PDB's metadata manifest?

.plug file
.xml file (Correct answer)
.pdb file
.dmp file

Correct answer: .xml file

Unplugging a PDB generates an XML manifest file describing the PDB's tablespaces, datafiles, and configuration needed to plug it into another compatible CDB.

Question 12: In Oracle RAC, what does Cache Fusion do?

Merges UNDO segments across all nodes into a single tablespace
Merges duplicate index entries across RAC instances
Fuses the redo streams from all instances into a single redo log
Transfers data blocks between node buffer caches over the private interconnect to avoid disk reads (Correct answer)

Correct answer: Transfers data blocks between node buffer caches over the private interconnect to avoid disk reads

Cache Fusion uses the high-speed private cluster interconnect to ship modified data blocks directly between instance buffer caches, eliminating the need for intermediate disk writes.

Question 13: In Oracle Certified Master, how does security & access control contribute to professional credibility?

By demonstrating competence, maintaining standards, and delivering consistent results (Correct answer)
By avoiding challenging situations
By using impressive terminology
Through the number of years in practice alone

Correct answer: By demonstrating competence, maintaining standards, and delivering consistent results

Professional credibility is built through demonstrated competence, consistent adherence to standards, and reliable delivery of quality results.

Question 14: In Oracle Certified Master, which data management & integration approach is MOST effective for achieving long-term goals?

Strategic planning with measurable objectives and regular progress reviews (Correct answer)
Focusing solely on short-term financial targets
Delegating all decisions without oversight
Reactive management that addresses issues as they arise

Correct answer: Strategic planning with measurable objectives and regular progress reviews

Strategic planning with measurable objectives and regular reviews provides direction, accountability, and the ability to adapt strategies based on progress.

Question 15: Which Oracle feature automatically reclaims unused space from high-water mark in a segment?

Automatic Segment Space Management (ASSM)
DBMS_SPACE.FREE_BLOCKS
Locally Managed Tablespaces
Segment Advisor with Shrink (Correct answer)

Correct answer: Segment Advisor with Shrink

The Segment Advisor with the ALTER TABLE … SHRINK SPACE command reclaims free space below the high-water mark by compacting rows and resetting the HWM.

Question 16: Which metric does Oracle's Recovery Point Objective (RPO) measure in a disaster recovery plan?

Maximum acceptable amount of data loss measured in time (Correct answer)
Number of full backups needed per recovery cycle
Time required to restore services after a failure
Minimum standby redo apply lag allowed before alerting

Correct answer: Maximum acceptable amount of data loss measured in time

RPO defines the maximum duration of data loss a business can tolerate; it determines how frequently data must be replicated or backed up to meet business continuity requirements.

Question 17: What does a Refreshable PDB provide in Oracle Multitenant?

A PDB clone that automatically synchronizes changes from a source PDB on a scheduled basis using redo shipping (Correct answer)
A PDB that auto-updates its optimizer statistics using DBMS_STATS scheduled jobs
A PDB with automatic patch application capabilities from Oracle Cloud
A PDB whose SGA and PGA memory are automatically refreshed under memory pressure

Correct answer: A PDB clone that automatically synchronizes changes from a source PDB on a scheduled basis using redo shipping

A Refreshable PDB is a thin clone that periodically replicates data changes from the source PDB via redo log shipping, providing a near-real-time read-only copy for reporting or dev/test use.

Question 18: When troubleshooting network design & administration issues in Oracle Certified Master, what is the BEST approach?

Systematic diagnosis starting with the most likely causes and documenting steps (Correct answer)
Restarting systems without investigating the root cause
Making multiple changes simultaneously to save time
Escalating immediately without initial investigation

Correct answer: Systematic diagnosis starting with the most likely causes and documenting steps

Systematic diagnosis with documentation ensures efficient problem resolution and prevents recurrence by addressing root causes.

Question 19: Which element is ESSENTIAL for an effective compliance & governance program in Oracle Certified Master?

Regular audits and continuous monitoring processes (Correct answer)
Documentation stored without regular updates
Compliance responsibility assigned to one individual only
Annual review without interim checks

Correct answer: Regular audits and continuous monitoring processes

Regular audits and continuous monitoring enable early detection of compliance gaps and ensure ongoing adherence to standards.

Question 20: What is the PRIMARY benefit of standardizing system architecture & design practices in Oracle Certified Master?

Increasing dependency on specific vendors
Reducing the number of tools available
Limiting innovation and creativity
Consistency, easier maintenance, and improved collaboration among team members (Correct answer)

Correct answer: Consistency, easier maintenance, and improved collaboration among team members

Standardization promotes consistency across the organization, simplifies maintenance, and enables better collaboration between team members.

Question 21: In Oracle Certified Master, how does cloud infrastructure & services contribute to professional credibility?

Through the number of years in practice alone
By demonstrating competence, maintaining standards, and delivering consistent results (Correct answer)
By avoiding challenging situations
By using impressive terminology

Correct answer: By demonstrating competence, maintaining standards, and delivering consistent results

Professional credibility is built through demonstrated competence, consistent adherence to standards, and reliable delivery of quality results.

Question 22: In Oracle Certified Master, how does implementation & configuration contribute to professional credibility?

By avoiding challenging situations
Through the number of years in practice alone
By using impressive terminology
By demonstrating competence, maintaining standards, and delivering consistent results (Correct answer)

Correct answer: By demonstrating competence, maintaining standards, and delivering consistent results

Professional credibility is built through demonstrated competence, consistent adherence to standards, and reliable delivery of quality results.

Question 23: What is the effect of setting the OPTIMIZER_MODE parameter to FIRST_ROWS_10?

Optimizer minimizes total resource consumption for all rows
Optimizer uses 10 parallel threads for query execution
Optimizer limits result sets to 10 rows
Optimizer chooses plans that return the first 10 rows as fast as possible (Correct answer)

Correct answer: Optimizer chooses plans that return the first 10 rows as fast as possible

FIRST_ROWS_10 instructs the optimizer to favor execution plans that deliver the first 10 rows of a result set with the lowest latency.

Question 24: In Oracle, what does the PCTFREE storage parameter control?

Maximum percentage of extents that can be free
Percentage of block space reserved for future row updates (Correct answer)
Number of free lists for concurrent inserts
Minimum percentage of a block that must be full before rows are added

Correct answer: Percentage of block space reserved for future row updates

PCTFREE specifies the percentage of each data block kept free to accommodate future updates that increase the size of existing rows.

Question 25: What is the PRIMARY objective of troubleshooting & problem resolution within the Oracle Certified Master profession?

To limit the scope of professional activities
To maintain the status quo without change
To create additional requirements for practitioners
To ensure quality outcomes through standardized practices and continuous improvement (Correct answer)

Correct answer: To ensure quality outcomes through standardized practices and continuous improvement

The primary objective is ensuring quality outcomes through established standards while continuously improving practices and processes.

Question 26: When facing an unfamiliar challenge in implementation & configuration within Oracle Certified Master, what is the BEST approach?

Research established best practices, consult colleagues, and document the approach (Correct answer)
Avoid the challenge if possible
Attempt to resolve it independently without consultation
Apply the most familiar technique regardless of suitability

Correct answer: Research established best practices, consult colleagues, and document the approach

Researching best practices and consulting colleagues combines established knowledge with practical experience, while documentation supports future reference.

Question 27: What is a Snapshot PDB in Oracle Multitenant?

A PDB in READ ONLY mode used exclusively for reporting
A temporary PDB created automatically during upgrade procedures
A thin, space-efficient PDB clone created from a storage-level snapshot (Correct answer)
A point-in-time backup of a PDB stored in the flash recovery area

Correct answer: A thin, space-efficient PDB clone created from a storage-level snapshot

A Snapshot PDB is a thin clone leveraging copy-on-write storage snapshots, enabling rapid and space-efficient PDB provisioning ideal for dev/test environments.

Question 28: When creating a new PDB using CREATE PLUGGABLE DATABASE, which clause is typically used to map source datafile paths to the new PDB's target file locations?

DATAFILES IN
PATH_CONVERT
TABLESPACE CONVERT
FILE_NAME_CONVERT (Correct answer)

Correct answer: FILE_NAME_CONVERT

FILE_NAME_CONVERT maps source datafile path patterns to target path patterns, telling Oracle where to place the new PDB's datafiles during creation or plug-in.

Question 29: Which approach to network design & administration security is MOST effective in Oracle Certified Master?

A single strong firewall without additional measures
Defense in depth with multiple layers of protection and regular audits (Correct answer)
Addressing security only after a breach occurs
Security through obscurity alone

Correct answer: Defense in depth with multiple layers of protection and regular audits

Defense in depth provides multiple layers of protection, so if one layer is compromised, others continue to provide security.

Question 30: Which competency is MOST essential for professionals working in implementation & configuration in Oracle Certified Master?

Seniority-based decision making
Speed of task completion above all else
Memorization of procedures without understanding principles
Critical thinking combined with practical application of knowledge (Correct answer)

Correct answer: Critical thinking combined with practical application of knowledge

Critical thinking allows professionals to apply knowledge effectively in varied situations, leading to better outcomes than rote procedures.

Question 31: In Oracle Data Guard, which protection mode guarantees zero data loss by requiring the standby to acknowledge redo receipt before the primary commits?

Synchronous Replication
Maximum Protection (Correct answer)
Maximum Availability
Maximum Performance

Correct answer: Maximum Protection

Maximum Protection mode requires at least one standby to confirm redo receipt before each primary transaction commits; if no standby is reachable, the primary shuts down.

Question 32: What is the PRIMARY objective of implementation & configuration within the Oracle Certified Master profession?

To create additional requirements for practitioners
To ensure quality outcomes through standardized practices and continuous improvement (Correct answer)
To limit the scope of professional activities
To maintain the status quo without change

Correct answer: To ensure quality outcomes through standardized practices and continuous improvement

The primary objective is ensuring quality outcomes through established standards while continuously improving practices and processes.

Oracle Certified Master (OCM) - Oracle Database 19c

The Oracle Certified Master (OCM) is Oracle's highest-level database certification, validating expert-level skills through a rigorous two-day, four-module hands-on practical exam covering database administration, multitenant architecture, backup/recovery, and high availability solutions.

Questions

38 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds