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

Question 1: Which privilege is required to execute the DBMS_STATS.GATHER_DATABASE_STATS procedure?

ANALYZE ANY and SELECT ANY TABLE
SYSDBA
DBA role (Correct answer)
ANALYZE ANY

Correct answer: DBA role

The DBA role includes the ANALYZE ANY privilege needed to gather statistics on all objects across the database using DBMS_STATS.

Question 2: When troubleshooting system architecture & design issues in Oracle Certified Master, what is the BEST approach?

Making multiple changes simultaneously to save time
Systematic diagnosis starting with the most likely causes and documenting steps (Correct answer)
Restarting systems without investigating the root cause
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 3: Which clause in a SELECT statement enables you to perform aggregations at multiple levels of a hierarchy in one query?

MODEL
CONNECT BY
PIVOT
ROLLUP (Correct answer)

Correct answer: ROLLUP

The ROLLUP extension to GROUP BY computes subtotals and grand totals at each level of the specified column hierarchy within a single SQL statement.

Question 4: What is the BEST approach to documentation & best practices standardization in Oracle Certified Master?

Implementing consistent formats, terminology, and processes across the organization (Correct answer)
Using whatever format is most convenient at the time
Standardizing only external-facing documents
Allowing each department to create its own standards

Correct answer: Implementing consistent formats, terminology, and processes across the organization

Organization-wide consistency in formats, terminology, and processes ensures data can be shared, compared, and analyzed effectively.

Question 5: What is the role of the Oracle Notification Service (ONS) in a RAC or Data Guard environment?

Publishing Fast Application Notification (FAN) events to middleware and connection pools about service state changes (Correct answer)
Encrypting redo data sent to standby databases
Distributing SQL execution plans to all cluster nodes
Managing redo log archival across all RAC instances

Correct answer: Publishing Fast Application Notification (FAN) events to middleware and connection pools about service state changes

ONS propagates FAN events (instance up/down, service relocate) from the cluster to JDBC/OCI connection pools and middleware, enabling rapid connection failover and load balancing.

Question 6: Which approach to system architecture & design security is MOST effective in Oracle Certified Master?

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

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 7: What is the purpose of the UNDO tablespace in Oracle Database?

Storing archived redo logs
Holding temporary sort segments
Caching frequently accessed index blocks
Providing read consistency and supporting transaction rollback (Correct answer)

Correct answer: Providing read consistency and supporting transaction rollback

The UNDO tablespace stores before-images of modified data to support transaction rollback and provide consistent reads for concurrent queries.

Question 8: In Oracle Certified Master, how does automation & scripting contribute to professional credibility?

By demonstrating competence, maintaining standards, and delivering consistent results (Correct answer)
By using impressive terminology
By avoiding challenging situations
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 9: What is the PRIMARY benefit of continuous improvement in data management & integration for Oracle Certified Master?

Reduced need for employee input
Increased complexity in operations
Higher operational costs in the short term
Enhanced efficiency, quality, and competitive advantage over time (Correct answer)

Correct answer: Enhanced efficiency, quality, and competitive advantage over time

Continuous improvement systematically enhances efficiency and quality, leading to sustained competitive advantage.

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

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

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 11: What is the primary purpose of a Far Sync instance in Oracle Data Guard?

Host an Active Data Guard standby for zero-data-loss protection
Serve read-only queries to offload reporting from the primary
Receive redo from the primary synchronously and forward it asynchronously to terminal standbys (Correct answer)
Act as a witness for Data Guard Fast-Start Failover

Correct answer: Receive redo from the primary synchronously and forward it asynchronously to terminal standbys

A Far Sync instance sits close to the primary, receives redo synchronously (zero data loss), and ships it asynchronously to distant standbys, combining zero-RPO with low latency.

Question 12: What consequence can result from failing to maintain proper compliance & governance standards in Oracle Certified Master?

Lower training requirements
Increased customer satisfaction
Loss of certification, legal penalties, and reputational damage (Correct answer)
Reduced workload for staff

Correct answer: Loss of certification, legal penalties, and reputational damage

Non-compliance can result in serious consequences including certification revocation, legal penalties, fines, and significant reputational damage.

Question 13: What is the role of data in performance monitoring & optimization programs for Oracle Certified Master?

Data provides objective evidence for decision-making and measuring progress (Correct answer)
Data complicates the improvement process
Data is only needed for external reporting
Data is collected but rarely analyzed

Correct answer: Data provides objective evidence for decision-making and measuring progress

Data provides the objective evidence needed to make informed decisions, track progress, and validate the effectiveness of improvements.

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

Escalating immediately without initial investigation
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

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 15: Which element is ESSENTIAL for an effective compliance & governance program in Oracle Certified Master?

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

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 16: 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)
FOR ALL CONTAINERS
CDB_WIDE = TRUE
GLOBAL = 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 17: How should documentation & best practices retention policies be determined in Oracle Certified Master?

Based on available storage space
Keeping everything indefinitely
Based on legal requirements, operational needs, and industry best practices (Correct answer)
Destroying records as soon as they are no longer immediately needed

Correct answer: Based on legal requirements, operational needs, and industry best practices

Retention policies should balance legal requirements, operational needs, and best practices to ensure appropriate preservation and disposal.

Question 18: What does the V$SQL view primarily contain in Oracle?

Session wait events
Historical AWR snapshots
Active transaction undo information
Cursor statistics and SQL text for statements in the shared pool (Correct answer)

Correct answer: Cursor statistics and SQL text for statements in the shared pool

V$SQL stores execution statistics, execution plans (via V$SQL_PLAN), and the SQL text for each parsed cursor currently in the shared pool.

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

To create additional requirements for practitioners
To limit the scope of professional activities
To ensure quality outcomes through standardized practices and continuous improvement (Correct answer)
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.

Question 20: Which documentation & best practices practice is MOST critical for maintaining data integrity in Oracle Certified Master?

Storing data in multiple disconnected systems
Manual data entry without verification
Allowing unrestricted access to modify records
Standardized input procedures with validation checks and regular audits (Correct answer)

Correct answer: Standardized input procedures with validation checks and regular audits

Standardized procedures with validation and audits ensure data remains accurate, consistent, and trustworthy.

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

Minimum standby redo apply lag allowed before alerting
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

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 22: When facing an unfamiliar challenge in cloud infrastructure & services within Oracle Certified Master, what is the BEST approach?

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

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 23: Which factor BEST indicates mastery of implementation & configuration in Oracle Certified Master?

Speed of task completion
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

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 24: In Oracle Certified Master, which network design & administration practice BEST ensures system reliability?

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

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 25: Which factor BEST indicates mastery of security & access control in Oracle Certified Master?

The ability to adapt knowledge and skills to varying contexts while maintaining standards (Correct answer)
Number of certifications held
Years of experience in a single setting
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 26: 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?

FILE_NAME_CONVERT (Correct answer)
DATAFILES IN
TABLESPACE CONVERT
PATH_CONVERT

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 27: Which dynamic performance view displays the real-time open mode (MOUNTED, READ WRITE, READ ONLY) of each PDB in a CDB?

GV$CONTAINERS
CDB_DATABASES
V$PDBS (Correct answer)
DBA_PDBS

Correct answer: V$PDBS

V$PDBS is the dynamic performance view that shows current status information for all PDBs, including their real-time open mode.

Question 28: How should network design & administration upgrades be managed in a Oracle Certified Master environment?

Through a structured change management process with testing and rollback plans (Correct answer)
By upgrading all systems simultaneously without staging
By implementing changes immediately without testing
Only during business hours for maximum visibility

Correct answer: Through a structured change management process with testing and rollback plans

A structured change management process with testing and rollback plans minimizes risk and ensures upgrades do not disrupt operations.

Question 29: In Oracle Certified Master, what is the MOST appropriate response when a potential compliance violation is discovered?

Address it only if a supervisor specifically asks about it
Report it immediately through established channels and document findings (Correct answer)
Wait to see if the violation causes harm before reporting
Discuss it informally without documentation

Correct answer: Report it immediately through established channels and document findings

Immediate reporting through established channels with proper documentation ensures timely resolution and maintains the integrity of the compliance program.

Question 30: What prerequisite must be met at the CDB level to perform a Hot Clone (clone a PDB while it remains open in READ WRITE mode)?

ENABLE_CLONING = TRUE
LOCAL_UNDO = TRUE (Correct answer)
ENABLE_GOLDENGATE_REPLICATION = TRUE
db_recovery_file_dest must be configured

Correct answer: LOCAL_UNDO = TRUE

Hot Cloning requires LOCAL_UNDO = TRUE so the source PDB has its own undo tablespace, enabling redo synchronization during the clone operation while the PDB stays open.

Question 31: What is the MOST important consideration when implementing network design & administration solutions in Oracle Certified Master?

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

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 32: What is the MOST important skill for effective project planning & deployment in Oracle Certified Master?

Clear communication and the ability to align team efforts with objectives (Correct answer)
Technical expertise alone without people skills
Maintaining strict authority over all decisions
Avoiding conflict at all costs

Correct answer: Clear communication and the ability to align team efforts with objectives

Clear communication is essential for aligning team efforts, building consensus, and ensuring everyone understands and works toward shared objectives.

Question 33: Which metric BEST indicates successful data management & integration in Oracle Certified Master?

Hours worked by team members
Number of meetings held per week
Achievement of defined key performance indicators and stakeholder satisfaction (Correct answer)
Volume of emails sent

Correct answer: Achievement of defined key performance indicators and stakeholder satisfaction

KPI achievement and stakeholder satisfaction directly measure whether management activities are producing desired outcomes.

Question 34: What is a Materialized View Log used for in Oracle?

Storing execution plans for complex views
Auditing DML on the base table
Capturing DDL changes for replication
Supporting fast refresh of materialized views (Correct answer)

Correct answer: Supporting fast refresh of materialized views

A Materialized View Log records row-level changes on the master table so that an associated materialized view can be refreshed incrementally (fast refresh) rather than fully rebuilt.

Question 35: Which factor MOST impacts the usefulness of documentation & best practices outputs in Oracle Certified Master?

Volume of data collected
Format and visual presentation only
Complexity of the analysis
Timeliness, accuracy, and relevance to the intended audience (Correct answer)

Correct answer: Timeliness, accuracy, and relevance to the intended audience

Information is most useful when it is timely, accurate, and relevant to the needs of the people who will use it.

Question 36: What is the MOST effective way to stay current with developments in security & access control for Oracle Certified Master?

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

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 37: What is the FOUNDATION of effective performance monitoring & optimization in Oracle Certified Master?

Industry averages without internal benchmarks
Customer complaints as the sole quality indicator
Clearly defined standards and measurable criteria (Correct answer)
Personal opinion of experienced practitioners

Correct answer: Clearly defined standards and measurable criteria

Clearly defined standards and measurable criteria provide an objective foundation for assessing and improving quality.

Question 38: How often should performance monitoring & optimization metrics be reviewed in Oracle Certified Master?

Only during annual performance reviews
When problems are reported
Regularly at defined intervals with additional reviews triggered by significant events (Correct answer)
When external audits are scheduled

Correct answer: Regularly at defined intervals with additional reviews triggered by significant events

Regular scheduled reviews ensure ongoing monitoring while event-triggered reviews capture the impact of significant changes.

Question 39: Which Oracle tool is used to analyze and report on the contents of redo log files for auditing and recovery purposes?

AWR
RMAN
LogMiner (Correct answer)
Data Pump

Correct answer: LogMiner

LogMiner (DBMS_LOGMNR) reads online and archived redo logs to provide a SQL-based view of all database changes for auditing and point-in-time recovery analysis.

Question 40: In Oracle Certified Master, which project planning & deployment approach is MOST effective for achieving long-term goals?

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

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 41: Which action BEST demonstrates a commitment to compliance & governance in Oracle Certified Master?

Following only the regulations that are convenient
Maintaining current knowledge of all applicable regulations and standards (Correct answer)
Relying on colleagues to interpret regulatory requirements
Addressing compliance issues only when audited

Correct answer: Maintaining current knowledge of all applicable regulations and standards

Actively maintaining current knowledge of applicable regulations demonstrates genuine commitment to compliance and helps prevent violations.

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

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

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 43: What is the PRIMARY objective of cloud infrastructure & services 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.

Question 44: In Oracle Certified Master, how should performance monitoring & optimization initiatives be prioritized?

Based on impact on outcomes, feasibility, and alignment with strategic goals (Correct answer)
Based on the most recent complaints
By the department requesting the improvement
In order of ease of implementation only

Correct answer: Based on impact on outcomes, feasibility, and alignment with strategic goals

Prioritizing by impact, feasibility, and strategic alignment ensures resources are directed where they will produce the greatest benefit.

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

Percentage of block space reserved for future row updates (Correct answer)
Number of free lists for concurrent inserts
Maximum percentage of extents that can be free
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 46: Which competency is MOST essential for professionals working in cloud infrastructure & services in Oracle Certified Master?

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

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 47: Which Oracle background process is responsible for writing dirty buffers from the buffer cache to datafiles?

SMON
CKPT
LGWR
DBWR (Correct answer)

Correct answer: DBWR

DBWR (Database Writer) writes modified (dirty) buffers from the database buffer cache to the datafiles on disk.

Question 48: What is the default open mode of a PDB immediately after it is created using CREATE PLUGGABLE DATABASE from PDB$SEED?

MOUNTED (Correct answer)
RESTRICTED
READ ONLY
READ WRITE

Correct answer: MOUNTED

A newly created PDB starts in MOUNTED mode and must be explicitly opened using ALTER PLUGGABLE DATABASE OPEN before users can connect to it.

Question 49: Which Oracle technology provides block-level storage replication independent of the Oracle software stack?

Oracle GoldenGate
Oracle Streams
Oracle Data Guard
Oracle ASM Mirroring (Correct answer)

Correct answer: Oracle ASM Mirroring

Oracle ASM (Automatic Storage Management) built-in mirroring replicates data blocks across failure groups at the storage layer, providing redundancy without relying on the database redo mechanism.

Question 50: Which competency is MOST essential for professionals working in automation & scripting in Oracle Certified Master?

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

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 51: Which approach to network design & administration security is MOST effective in Oracle Certified Master?

A single strong firewall without additional measures
Addressing security only after a breach occurs
Defense in depth with multiple layers of protection and regular audits (Correct answer)
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 52: Which Oracle dynamic performance view provides real-time information about all containers (root, seed, and PDBs) in the current CDB?

DBA_CONTAINERS
V$CONTAINERS (Correct answer)
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 53: In Oracle Database, which isolation level prevents dirty reads and non-repeatable reads but still allows phantom reads by default?

Repeatable Read
Read Committed (Correct answer)
Read Uncommitted
Serializable

Correct answer: Read Committed

Oracle's default Read Committed isolation prevents dirty reads by only seeing committed data, but a new query within the same transaction can see newly committed rows (phantoms).

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

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

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 55: What is the purpose of the ROWID pseudocolumn in Oracle?

Unique identifier for each row that encodes its physical storage location (Correct answer)
A hash of the primary key columns
A pointer to the corresponding UNDO record
A sequential number assigned at insert time

Correct answer: Unique identifier for each row that encodes its physical storage location

ROWID is a unique address for each row in a table that encodes the data object number, data file, data block, and row slot position, allowing direct block-level access.

Question 56: Which component of a CDB serves as a read-only, system-supplied template for creating new PDBs?

CDB$ROOT
PDB$SEED (Correct answer)
ROOT$SEED
SEED$PDB

Correct answer: PDB$SEED

PDB$SEED is the read-only seed PDB provided by Oracle that acts as a template from which new Pluggable Databases are created.

Question 57: What is the PRIMARY objective of automation & scripting 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 maintain the status quo without change
To limit the scope of professional activities

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 58: When facing an unfamiliar challenge in automation & scripting 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
Apply the most familiar technique regardless of suitability
Attempt to resolve it independently without consultation

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 59: What is the Recovery Time Objective (RTO) primarily concerned with?

Maximum acceptable data loss measured in time
Number of standby databases required
Maximum acceptable duration of downtime after a failure event (Correct answer)
Frequency of database backups

Correct answer: Maximum acceptable duration of downtime after a failure event

RTO defines the maximum tolerable time from a failure event until business services are restored, directly driving high availability architecture decisions.

Question 60: Which command persists the current open mode of PDBs so they automatically return to that state after the CDB restarts?

ALTER PLUGGABLE DATABASE PERSISTENT OPEN
ALTER PLUGGABLE DATABASE SAVE STATE (Correct answer)
ALTER PLUGGABLE DATABASE SET AUTOSTART
ALTER DATABASE SAVE PDB STATE

Correct answer: ALTER PLUGGABLE DATABASE SAVE STATE

ALTER PLUGGABLE DATABASE SAVE STATE records each PDB's current open mode so that the CDB automatically restores that state when it is restarted.

Question 61: To switch a DBA session from CDB$ROOT to a PDB named SALESPDB without disconnecting, which SQL command is used?

USE CONTAINER SALESPDB
ALTER SYSTEM SET CONTAINER = SALESPDB
ALTER SESSION SET CONTAINER = SALESPDB (Correct answer)
CONNECT TO SALESPDB

Correct answer: ALTER SESSION SET CONTAINER = SALESPDB

ALTER SESSION SET CONTAINER = <PDB_name> switches the current session context from the root to the specified PDB without requiring a reconnection.

Question 62: When facing an unfamiliar challenge in security & access control within Oracle Certified Master, what is the BEST approach?

Attempt to resolve it independently without consultation
Avoid the challenge if possible
Research established best practices, consult colleagues, and document the approach (Correct answer)
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 63: What is the PRIMARY purpose of documentation & best practices in Oracle Certified Master?

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

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 64: Which factor BEST indicates mastery of troubleshooting & problem resolution in Oracle Certified Master?

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

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 65: In Oracle Certified Master, how should project planning & deployment challenges be prioritized?

Based solely on cost considerations
In the order they were identified
Based on potential impact, urgency, and alignment with strategic objectives (Correct answer)
By the preferences of senior management

Correct answer: Based on potential impact, urgency, and alignment with strategic objectives

Prioritizing based on impact, urgency, and strategic alignment ensures resources are directed where they will produce the greatest benefit.

Question 66: Which metric BEST indicates successful project planning & deployment in Oracle Certified Master?

Achievement of defined key performance indicators and stakeholder satisfaction (Correct answer)
Volume of emails sent
Number of meetings held per week
Hours worked by team members

Correct answer: Achievement of defined key performance indicators and stakeholder satisfaction

KPI achievement and stakeholder satisfaction directly measure whether management activities are producing desired outcomes.

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

By avoiding challenging situations
By using impressive terminology
By demonstrating competence, maintaining standards, and delivering consistent results (Correct answer)
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 68: Which factor BEST indicates mastery of automation & scripting in Oracle Certified Master?

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

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 69: When implementing data management & integration changes in Oracle Certified Master, what factor is MOST critical?

Stakeholder buy-in and a clear change management plan (Correct answer)
Top-down mandate without input from affected parties
Speed of implementation regardless of preparation
Minimizing communication about the changes

Correct answer: Stakeholder buy-in and a clear change management plan

Stakeholder buy-in and a structured change management plan significantly increase the likelihood of successful implementation.

Question 70: What is the purpose of the RMAN RECOVER … UNTIL TIME command?

Performs incomplete (point-in-time) recovery to restore the database to a specific timestamp (Correct answer)
Validates block corruption up to a time boundary
Recovers only archived logs up to a given time
Recovers a tablespace to a specific SCN

Correct answer: Performs incomplete (point-in-time) recovery to restore the database to a specific timestamp

RECOVER … UNTIL TIME performs incomplete recovery, rolling the database forward through archived and online redo logs to the exact timestamp specified, then stopping for RESETLOGS.

Question 71: What is the PRIMARY objective of compliance & governance in the Oracle Certified Master field?

To ensure adherence to established standards and protect stakeholders (Correct answer)
To limit the scope of professional practice
To increase operational costs for organizations
To create additional paperwork for professionals

Correct answer: To ensure adherence to established standards and protect stakeholders

The primary objective of compliance and regulatory frameworks is to ensure adherence to standards that protect stakeholders.

Question 72: In Oracle, what happens when you issue COMMIT while a DDL statement is in progress?

The DDL is rolled back automatically
DDL issues an implicit COMMIT before and after execution; no explicit COMMIT needed (Correct answer)
An ORA-600 error is raised
The DDL waits until the COMMIT completes

Correct answer: DDL issues an implicit COMMIT before and after execution; no explicit COMMIT needed

Oracle DDL statements automatically issue an implicit COMMIT before they execute and another implicit COMMIT upon successful completion, making them auto-transactional.

Question 73: What does the FLASHBACK DATABASE command rely on to reconstruct earlier database states?

Archived redo logs from the standby database
UNDO tablespace snapshots
Flashback Logs stored in the Fast Recovery Area (Correct answer)
RMAN incremental backups

Correct answer: Flashback Logs stored in the Fast Recovery Area

Flashback Database uses flashback logs written to the Fast Recovery Area that capture before-images of changed blocks, allowing the database to be rewound to an earlier SCN or timestamp.

Question 74: A DBA wants to apply a specific initialization parameter only to PDB 'DEVPDB' without affecting other PDBs. Which command achieves this?

ALTER SESSION SET parameter = value FOR PDB DEVPDB
ALTER PLUGGABLE DATABASE DEVPDB SET parameter = value
ALTER SYSTEM SET parameter = value SCOPE=SPFILE
ALTER SYSTEM SET parameter = value CONTAINER = DEVPDB (Correct answer)

Correct answer: ALTER SYSTEM SET parameter = value CONTAINER = DEVPDB

ALTER SYSTEM SET <parameter> = <value> CONTAINER = <PDB_name> sets an initialization parameter at the PDB level, overriding the CDB-level value only for that specific PDB.

Question 75: In an Oracle Data Guard configuration, what is a 'snapshot standby'?

A cold backup clone used for disaster recovery drills
A logical standby that mirrors only specific schemas
A physical standby temporarily converted to a fully updatable database for testing, then re-synchronized (Correct answer)
A read-only physical standby that applies redo in real time

Correct answer: A physical standby temporarily converted to a fully updatable database for testing, then re-synchronized

A snapshot standby is a physical standby that has been converted to allow DML/DDL for testing; when converted back, accumulated changes are discarded and redo is re-applied to resync with the primary.

Question 76: In Oracle Certified Master, how should data management & integration challenges be prioritized?

Based solely on cost considerations
In the order they were identified
Based on potential impact, urgency, and alignment with strategic objectives (Correct answer)
By the preferences of senior management

Correct answer: Based on potential impact, urgency, and alignment with strategic objectives

Prioritizing based on impact, urgency, and strategic alignment ensures resources are directed where they will produce the greatest benefit.

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

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

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 78: What does setting LOCAL_UNDO = TRUE at the CDB level enable in Oracle Multitenant?

A local undo segment is created in the SYSTEM tablespace
Undo operations are restricted to the local RAC node
Automatic undo management is enabled for temporary tablespaces
Each PDB maintains its own dedicated undo tablespace rather than sharing a CDB-level undo tablespace (Correct answer)

Correct answer: Each PDB maintains its own dedicated undo tablespace rather than sharing a CDB-level undo tablespace

LOCAL_UNDO = TRUE configures each PDB to own its individual undo tablespace, improving isolation and enabling PDB-level Flashback Database operations.

Question 79: What is the PRIMARY objective of implementation & configuration 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 80: What is the MOST effective way to stay current with developments in automation & scripting for Oracle Certified Master?

Following a single expert opinions
Relying on experience gained early in career
Reading only internal communications
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 81: When implementing project planning & deployment changes in Oracle Certified Master, what factor is MOST critical?

Top-down mandate without input from affected parties
Stakeholder buy-in and a clear change management plan (Correct answer)
Minimizing communication about the changes
Speed of implementation regardless of preparation

Correct answer: Stakeholder buy-in and a clear change management plan

Stakeholder buy-in and a structured change management plan significantly increase the likelihood of successful implementation.

Question 82: Which Oracle RAC component manages cluster membership and arbitrates split-brain scenarios?

Grid Naming Service (GNS)
Oracle Cluster Registry (OCR)
Cluster Synchronization Services (CSS) (Correct answer)
Virtual IP (VIP)

Correct answer: Cluster Synchronization Services (CSS)

CSS (Cluster Synchronization Services) maintains node membership, detects failures through missed heartbeats, and initiates node eviction to prevent split-brain data corruption.

Question 83: Which competency is MOST essential for professionals working in troubleshooting & problem resolution in Oracle Certified Master?

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

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 84: What is the MOST effective way to stay current with developments in troubleshooting & problem resolution for Oracle Certified Master?

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

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 85: Which factor BEST indicates mastery of cloud infrastructure & services in Oracle Certified Master?

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

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 86: Which Oracle feature automatically extends a tablespace by adding a new datafile or expanding an existing one when space runs out?

Automatic Segment Management
Bigfile Tablespace
Automatic Extensible Datafiles (AUTOEXTEND ON) (Correct answer)
Locally Managed Tablespace

Correct answer: Automatic Extensible Datafiles (AUTOEXTEND ON)

AUTOEXTEND ON configures a datafile to automatically grow by a specified increment (up to MAXSIZE) when the tablespace runs out of free space, preventing allocation failures.

Question 87: Which competency is MOST essential for professionals working in security & access control in Oracle Certified Master?

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

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 88: In Oracle Certified Master, how does troubleshooting & problem resolution 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 89: What is the MOST important consideration when implementing system architecture & design solutions in Oracle Certified Master?

Minimizing initial cost without considering long-term value
Using the newest technology regardless of fit
Selecting solutions based on vendor popularity alone
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 90: Which single SQL statement opens all PDBs in a CDB simultaneously?

ALTER DATABASE OPEN ALL CONTAINERS
ALTER SYSTEM OPEN ALL PDBS
ALTER PLUGGABLE DATABASE ALL OPEN (Correct answer)
STARTUP ALL PDBS

Correct answer: ALTER PLUGGABLE DATABASE ALL OPEN

ALTER PLUGGABLE DATABASE ALL OPEN is the CDB-level command that opens every PDB in the CDB in a single statement.

Question 91: When facing an unfamiliar challenge in troubleshooting & problem resolution within Oracle Certified Master, what is the BEST approach?

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

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 92: What is the maximum number of PDBs supported in a single Oracle 12.2+ CDB?

1024
252
512
4096 (Correct answer)

Correct answer: 4096

Oracle 12.2 and later supports up to 4096 PDBs in a single CDB, a significant expansion from the 252-PDB limit in Oracle 12.1.

Question 93: In Oracle Multitenant architecture, what does CDB stand for?

Central Data Buffer
Consolidated Database Block
Cluster Database Bundle
Container Database (Correct answer)

Correct answer: Container Database

CDB stands for Container Database, which is the top-level database that can host multiple Pluggable Databases (PDBs).

Question 94: What Oracle technology provides application-level, transparent failover for database connections during a planned or unplanned outage?

Application Continuity (AC) (Correct answer)
Fast Application Notification (FAN)
Transparent Application Failover (TAF)
Oracle Net Services Load Balancing

Correct answer: Application Continuity (AC)

Application Continuity replays in-flight transactions on a new database session after a recoverable failure, making the outage transparent to the application without code changes.

Question 95: What is the MOST important skill for effective data management & integration in Oracle Certified Master?

Clear communication and the ability to align team efforts with objectives (Correct answer)
Maintaining strict authority over all decisions
Avoiding conflict at all costs
Technical expertise alone without people skills

Correct answer: Clear communication and the ability to align team efforts with objectives

Clear communication is essential for aligning team efforts, building consensus, and ensuring everyone understands and works toward shared objectives.

Question 96: Which Oracle Data Dictionary view shows the dependencies between stored PL/SQL objects?

DBA_OBJECTS
DBA_SOURCE
DBA_DEPENDENCIES (Correct answer)
DBA_PROCEDURES

Correct answer: DBA_DEPENDENCIES

DBA_DEPENDENCIES lists all referencing and referenced objects so you can trace dependency chains between packages, procedures, triggers, and views.

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

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

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 98: How should system architecture & design upgrades be managed in a Oracle Certified Master environment?

By implementing changes immediately without testing
Through a structured change management process with testing and rollback plans (Correct answer)
Only during business hours for maximum visibility
By upgrading all systems simultaneously without staging

Correct answer: Through a structured change management process with testing and rollback plans

A structured change management process with testing and rollback plans minimizes risk and ensures upgrades do not disrupt operations.

Question 99: In Oracle Certified Master, how should sensitive documentation & best practices be protected?

By limiting all access to one person
By avoiding digital storage entirely
Through role-based access controls, encryption, and compliance with privacy regulations (Correct answer)
Through password protection alone

Correct answer: Through role-based access controls, encryption, and compliance with privacy regulations

Multi-layered protection through access controls, encryption, and regulatory compliance provides comprehensive security for sensitive data.

Question 100: How does ongoing professional development support compliance & governance in Oracle Certified Master?

It is irrelevant to compliance outcomes
It keeps professionals informed of evolving standards and best practices (Correct answer)
It only benefits entry-level professionals
It replaces the need for formal compliance audits

Correct answer: It keeps professionals informed of evolving standards and best practices

Ongoing professional development ensures that practitioners stay current with evolving regulations, standards, and best practices in their field.

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

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

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 102: Which competency is MOST essential for professionals working in implementation & configuration in Oracle Certified Master?

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

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 103: In Oracle Data Guard, which protection mode guarantees zero data loss by requiring the standby to acknowledge redo receipt before the primary commits?

Maximum Availability
Synchronous Replication
Maximum Protection (Correct answer)
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 104: What is the PRIMARY benefit of standardizing network design & administration practices in Oracle Certified Master?

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

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 105: In Oracle Data Guard Broker, what is the purpose of the DGMGRL command SWITCHOVER TO?

Converts a physical standby to a logical standby
Forces an emergency failover when the primary is unavailable
Resynchronizes a lag standby after network interruption
Performs a planned role transition with no data loss between primary and standby (Correct answer)

Correct answer: Performs a planned role transition with no data loss between primary and standby

SWITCHOVER TO performs an orderly, zero-data-loss role reversal where the current primary becomes a standby and the target standby becomes the new primary.

Question 106: Which characteristic BEST describes a successful performance monitoring & optimization culture in Oracle Certified Master?

Periodic campaigns without sustained effort
Top-down directives without employee input
Continuous learning where all team members actively seek improvement (Correct answer)
Focus on compliance over genuine improvement

Correct answer: Continuous learning where all team members actively seek improvement

A culture where all team members actively seek improvement opportunities creates sustainable quality enhancement across the organization.

Question 107: In Oracle RAC, what is a 'service' and why is it important for high availability?

A dedicated process for inter-node communication over the private interconnect
A named workload unit that can be started, stopped, and relocated across instances to maintain availability (Correct answer)
A synonym for the database SID used in tnsnames.ora
A BG process responsible for block transfer between buffer caches

Correct answer: A named workload unit that can be started, stopped, and relocated across instances to maintain availability

A RAC service is a named logical unit of work that runs on one or more instances; if an instance fails, the service automatically relocates to a surviving instance, providing continuous availability.

Question 108: Which performance monitoring & optimization tool is MOST valuable for identifying root causes in Oracle Certified Master?

Historical trend analysis alone
Blame assignment without investigation
Quick fixes based on symptoms
Root cause analysis with systematic investigation methods (Correct answer)

Correct answer: Root cause analysis with systematic investigation methods

Root cause analysis with systematic methods identifies underlying causes rather than symptoms, leading to lasting solutions.

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

By demonstrating competence, maintaining standards, and delivering consistent results (Correct answer)
By using impressive terminology
By avoiding challenging situations
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 110: What is the PRIMARY benefit of continuous improvement in project planning & deployment for Oracle Certified Master?

Reduced need for employee input
Higher operational costs in the short term
Increased complexity in operations
Enhanced efficiency, quality, and competitive advantage over time (Correct answer)

Correct answer: Enhanced efficiency, quality, and competitive advantage over time

Continuous improvement systematically enhances efficiency and quality, leading to sustained competitive advantage.

Question 111: In Oracle Data Guard, which role does the primary database's standby perform when it actively processes redo in real time?

Logical Standby
Snapshot Standby
Physical Standby in Maximum Availability mode (Correct answer)
Far Sync Instance

Correct answer: Physical Standby in Maximum Availability mode

A Physical Standby in Maximum Availability mode applies redo data in real time using Redo Apply (MRP), maintaining synchronization with near-zero lag.

Question 112: In Oracle Certified Master, which system architecture & design practice BEST ensures system reliability?

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

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 113: Which Oracle utility is used to clone a database or create a standby database directly from the primary without prior backups?

SQL*Loader
Data Pump impdp
GoldenGate Initial Load
RMAN DUPLICATE … FROM ACTIVE DATABASE (Correct answer)

Correct answer: RMAN DUPLICATE … FROM ACTIVE DATABASE

RMAN DUPLICATE … FROM ACTIVE DATABASE streams datafiles directly from the primary (or auxiliary) instance over an Oracle Net connection to build a clone or standby without needing RMAN backups.

Question 114: Which Oracle feature allows you to recover a dropped table without restoring from a backup?

LogMiner
Data Guard Redo Apply
RMAN Block Recovery
Flashback Table (Correct answer)

Correct answer: Flashback Table

Flashback Table uses the Oracle Recycle Bin to restore a dropped table to its state before the DROP command.

Question 115: 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 116: Which Oracle feature partitions a table by automatically routing rows to sub-partitions based on hash values when list partitioning is the top level?

Reference Partitioning
Range-Hash Composite Partitioning
List-Hash Composite Partitioning (Correct answer)
Interval Partitioning

Correct answer: List-Hash Composite Partitioning

List-Hash composite partitioning first divides data by a list of discrete values, then applies hash sub-partitioning within each list partition for even data distribution.

Question 117: What is the MOST effective way to stay current with developments in cloud infrastructure & services for Oracle Certified Master?

Relying on experience gained early in career
Following a single expert opinions
Reading only internal communications
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 118: What is the PRIMARY objective of security & access control within the Oracle Certified Master profession?

To limit the scope of professional activities
To create additional requirements for practitioners
To maintain the status quo without change
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 119: In Oracle RAC, what does Cache Fusion do?

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

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 120: Which SQL hint forces the Oracle optimizer to use a full table scan instead of an index?

/*+ FULL(table) */ (Correct answer)
/*+ INDEX(table) */
/*+ PARALLEL */
/*+ NO_MERGE */

Correct answer: /*+ FULL(table) */

The FULL hint instructs the Cost-Based Optimizer to perform a full table scan on the specified table, bypassing available indexes.

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.

120

Questions

150 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

These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

learn.oracle.com — Exam information · verified Oct 2026
docs.oracle.com — Passing score, score release, fees · verified Oct 2026
mylearn.oracle.com — Time limit · verified Oct 2026
oracle.com — Retake policy, score validity, test delivery, eligibility · verified Oct 2026