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

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

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

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 2: Which factor MOST impacts the usefulness of documentation & best practices outputs in Oracle Certified Master?

Format and visual presentation only
Volume of data collected
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 3: What is the PRIMARY objective of security & access control within the Oracle Certified Master profession?

To ensure quality outcomes through standardized practices and continuous improvement (Correct answer)
To create additional requirements for practitioners
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 4: What does the V$SQL view primarily contain in Oracle?

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

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

Unique identifier for each row that encodes its physical storage location (Correct answer)
A pointer to the corresponding UNDO record
A hash of the primary key columns
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 6: A DBA wants to apply a specific initialization parameter only to PDB 'DEVPDB' without affecting other PDBs. Which command achieves this?

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

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 7: 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)
ALL_PDBS
V$DATABASE

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 component of a CDB serves as a read-only, system-supplied template for creating new PDBs?

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

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 9: In Oracle RAC, what is a 'service' and why is it important for high availability?

A BG process responsible for block transfer between buffer caches
A synonym for the database SID used in tnsnames.ora
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)

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 10: What Oracle technology provides application-level, transparent failover for database connections during a planned or unplanned outage?

Fast Application Notification (FAN)
Transparent Application Failover (TAF)
Application Continuity (AC) (Correct answer)
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 11: Which factor BEST indicates mastery of implementation & configuration in Oracle Certified Master?

Years of experience in a single setting
Speed of task completion
Number of certifications held
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 12: In Oracle Certified Master, how does security & access control contribute to professional credibility?

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

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 13: In Oracle Certified Master, which project planning & deployment approach is MOST effective for achieving long-term goals?

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

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 14: Which documentation & best practices practice is MOST critical for maintaining data integrity in Oracle Certified Master?

Manual data entry without verification
Allowing unrestricted access to modify records
Storing data in multiple disconnected systems
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 15: What is the primary purpose of Application Containers introduced in Oracle 19c Multitenant?

Docker containers used to deploy Oracle Application Express instances
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
A set of PDBs managed centrally by Oracle Cloud Infrastructure

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 16: Which clause in a SELECT statement enables you to perform aggregations at multiple levels of a hierarchy in one query?

CONNECT BY
ROLLUP (Correct answer)
PIVOT
MODEL

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 17: What does a Refreshable PDB provide in Oracle Multitenant?

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

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: Which competency is MOST essential for professionals working in troubleshooting & problem resolution in Oracle Certified Master?

Speed of task completion above all else
Critical thinking combined with practical application of knowledge (Correct answer)
Seniority-based decision making
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 19: What is the primary purpose of a Far Sync instance in Oracle Data Guard?

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

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 20: 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 21: Which competency is MOST essential for professionals working in security & access control 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 22: What is the MOST effective way to stay current with developments in implementation & configuration 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 23: In an Oracle Data Guard configuration, what is a 'snapshot standby'?

A physical standby temporarily converted to a fully updatable database for testing, then re-synchronized (Correct answer)
A logical standby that mirrors only specific schemas
A cold backup clone used for disaster recovery drills
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 24: In Oracle Data Guard, which role does the primary database's standby perform when it actively processes redo in real time?

Snapshot Standby
Logical 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 25: How should documentation & best practices retention policies be determined in Oracle Certified Master?

Based on legal requirements, operational needs, and industry best practices (Correct answer)
Keeping everything indefinitely
Based on available storage space
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 26: 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 27: 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 28: In Oracle Certified Master, what is the MOST appropriate response when a potential compliance violation is discovered?

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

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 29: In Oracle, what does the PCTFREE storage parameter control?

Number of free lists for concurrent inserts
Percentage of block space reserved for future row updates (Correct answer)
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 30: 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)
Only during business hours for maximum visibility
By upgrading all systems simultaneously without staging
By implementing changes immediately without testing

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 31: What is the BEST approach to documentation & best practices standardization in Oracle Certified Master?

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

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

LGWR
DBWR (Correct answer)
CKPT
SMON

Correct answer: DBWR

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

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

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

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 34: How often should performance monitoring & optimization metrics be reviewed in Oracle Certified Master?

Regularly at defined intervals with additional reviews triggered by significant events (Correct answer)
When problems are reported
Only during annual performance reviews
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 35: 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
Annual review without interim checks
Compliance responsibility assigned to one individual only

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 36: 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)
Minimizing initial cost without considering long-term value
Selecting solutions based on vendor popularity alone

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

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

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 38: What is the PRIMARY benefit of standardizing system architecture & design practices in Oracle Certified Master?

Consistency, easier maintenance, and improved collaboration among team members (Correct answer)
Increasing dependency on specific vendors
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 39: What is a Materialized View Log used for in Oracle?

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

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

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)
A local undo segment is created in the SYSTEM tablespace
Undo operations are restricted to the local RAC node

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 41: What is the PRIMARY objective of troubleshooting & problem resolution within the Oracle Certified Master profession?

To create additional requirements for practitioners
To maintain the status quo without change
To limit the scope of professional activities
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 42: What is the role of data in performance monitoring & optimization programs for Oracle Certified Master?

Data is only needed for external reporting
Data provides objective evidence for decision-making and measuring progress (Correct answer)
Data complicates the improvement process
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 43: What is the MOST effective way to stay current with developments in troubleshooting & problem resolution for Oracle Certified Master?

Following a single expert opinions
Reading only internal communications
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 44: What is the MOST effective way to stay current with developments in security & access control for Oracle Certified Master?

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

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 45: Which performance monitoring & optimization tool is MOST valuable for identifying root causes in Oracle Certified Master?

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

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 46: Which Oracle feature automatically reclaims unused space from high-water mark in a segment?

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

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 47: Which metric BEST indicates successful project planning & deployment in Oracle Certified Master?

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

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

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

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 49: Which Oracle technology provides block-level storage replication independent of the Oracle software stack?

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

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: When facing an unfamiliar challenge in security & access control within Oracle Certified Master, what is the BEST approach?

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
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 51: After plugging a non-CDB into a CDB using CREATE PLUGGABLE DATABASE ... AS NON$CDB, which script must be run inside the new PDB to complete the conversion?

noncdb_to_pdb.sql (Correct answer)
multitenant_convert.sql
pdb_migration.sql
convert_noncdb.sql

Correct answer: noncdb_to_pdb.sql

The $ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql script must be executed inside the plugged PDB to remove non-CDB-specific dictionary objects and complete the multitenant conversion.

Question 52: Which factor BEST indicates mastery of automation & scripting in Oracle Certified Master?

Number of certifications held
Years of experience in a single setting
The ability to adapt knowledge and skills to varying contexts while maintaining standards (Correct answer)
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 53: Which Oracle feature partitions a table by automatically routing rows to sub-partitions based on hash values when list partitioning is the top level?

Range-Hash Composite Partitioning
List-Hash Composite Partitioning (Correct answer)
Interval Partitioning
Reference 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 54: When unplugging a PDB using ALTER PLUGGABLE DATABASE UNPLUG INTO, what type of file is created to store the PDB's metadata manifest?

.xml file (Correct answer)
.pdb file
.dmp file
.plug 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 55: What is the purpose of the UNDO tablespace in Oracle Database?

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

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 56: Which Oracle feature allows you to recover a dropped table without restoring from a backup?

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

Correct answer: Flashback Table

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

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

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

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 58: 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
Avoiding conflict at all costs
Maintaining strict authority over all decisions

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

Number of standby databases required
Maximum acceptable duration of downtime after a failure event (Correct answer)
Maximum acceptable data loss measured in time
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 approach to system architecture & design security is MOST effective in Oracle Certified Master?

Defense in depth with multiple layers of protection and regular audits (Correct answer)
Addressing security only after a breach occurs
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 61: What is the PRIMARY benefit of continuous improvement in project planning & deployment for Oracle Certified Master?

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

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

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

Question 62: In Oracle Certified Master, how should project planning & deployment challenges be prioritized?

Based on potential impact, urgency, and alignment with strategic objectives (Correct answer)
In the order they were identified
Based solely on cost considerations
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 63: In Oracle Certified Master, how should sensitive documentation & best practices be protected?

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

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 64: What does the FLASHBACK DATABASE command rely on to reconstruct earlier database states?

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

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 65: What is the purpose of the RMAN RECOVER … UNTIL TIME command?

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

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 66: What is the MOST important skill for effective data management & integration in Oracle Certified Master?

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

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 67: In Oracle, what happens when you issue COMMIT while a DDL statement is in progress?

The DDL is rolled back automatically
An ORA-600 error is raised
DDL issues an implicit COMMIT before and after execution; no explicit COMMIT needed (Correct answer)
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 68: 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
Increasing dependency on specific vendors
Reducing the number of tools available

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 69: When facing an unfamiliar challenge in troubleshooting & problem resolution within Oracle Certified Master, what is the BEST approach?

Avoid the challenge if possible
Research established best practices, consult colleagues, and document the approach (Correct answer)
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 70: To switch a DBA session from CDB$ROOT to a PDB named SALESPDB without disconnecting, which SQL command is used?

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

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 71: What is a Snapshot PDB in Oracle Multitenant?

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
A PDB in READ ONLY mode used exclusively for reporting
A temporary PDB created automatically during upgrade procedures

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 72: Which competency is MOST essential for professionals working in automation & scripting in Oracle Certified Master?

Speed of task completion above all else
Seniority-based decision making
Critical thinking combined with practical application of knowledge (Correct answer)
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 73: In Oracle Certified Master, which network design & administration practice BEST ensures system reliability?

Implementing redundancy, regular testing, and documented recovery procedures (Correct answer)
Relying on a single point of contact for all technical issues
Updating systems only when vendors release patches
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 74: In Oracle Certified Master, how does automation & scripting contribute to professional credibility?

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

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 75: 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 76: In Oracle Certified Master, how does implementation & configuration contribute to professional credibility?

By using impressive terminology
By avoiding challenging situations
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 77: What is the function of Oracle's Automatic Workload Repository (AWR)?

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

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 78: What is the role of the Oracle Notification Service (ONS) in a RAC or Data Guard environment?

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

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 79: Which Oracle tool is used to analyze and report on the contents of redo log files for auditing and recovery purposes?

RMAN
AWR
Data Pump
LogMiner (Correct answer)

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 80: What clause must be appended when granting a privilege to a common user so the grant applies across all containers in the CDB?

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

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 81: What is the MOST important consideration when implementing system architecture & design solutions in Oracle Certified Master?

Using the newest technology regardless of fit
Selecting solutions based on vendor popularity alone
Alignment with organizational needs and scalability requirements (Correct answer)
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 82: In Oracle Certified Master, how does troubleshooting & problem resolution 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 83: Which competency is MOST essential for professionals working in cloud infrastructure & services in Oracle Certified Master?

Memorization of procedures without understanding principles
Seniority-based decision making
Speed of task completion above all else
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 84: Which Oracle Data Dictionary view shows the dependencies between stored PL/SQL objects?

DBA_OBJECTS
DBA_DEPENDENCIES (Correct answer)
DBA_SOURCE
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 85: 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)?

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

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 86: When implementing project planning & deployment changes in Oracle Certified Master, what factor is MOST critical?

Top-down mandate without input from affected parties
Minimizing communication about the changes
Stakeholder buy-in and a clear change management plan (Correct answer)
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 87: What is the maximum number of PDBs supported in a single Oracle 12.2+ CDB?

252
512
1024
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 88: In Oracle Database, which isolation level prevents dirty reads and non-repeatable reads but still allows phantom reads by default?

Read Committed (Correct answer)
Repeatable Read
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 89: 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 DATABASE SAVE PDB STATE
ALTER PLUGGABLE DATABASE SET AUTOSTART
ALTER PLUGGABLE DATABASE SAVE STATE (Correct answer)

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

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

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 91: What is the PRIMARY benefit of continuous improvement in data management & integration for Oracle Certified Master?

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

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

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

Question 92: 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?

PATH_CONVERT
FILE_NAME_CONVERT (Correct answer)
DATAFILES IN
TABLESPACE 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 93: Which Oracle utility is used to clone a database or create a standby database directly from the primary without prior backups?

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

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 94: What is the effect of setting the OPTIMIZER_MODE parameter to FIRST_ROWS_10?

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

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

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

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 96: Which metric does Oracle's Recovery Point Objective (RPO) measure in a disaster recovery plan?

Time required to restore services after a failure
Number of full backups needed per recovery cycle
Maximum acceptable amount of data loss measured in time (Correct answer)
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 97: Which SQL hint forces the Oracle optimizer to use a full table scan instead of an index?

/*+ PARALLEL */
/*+ INDEX(table) */
/*+ FULL(table) */ (Correct answer)
/*+ 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.

Question 98: Which factor BEST indicates mastery of cloud infrastructure & services in Oracle Certified Master?

Speed of task completion
Number of certifications held
Years of experience in a single setting
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 99: Which RMAN command validates backup pieces and image copies without actually restoring them?

LIST BACKUP
RESTORE … PREVIEW
CROSSCHECK BACKUP
VALIDATE BACKUPSET (Correct answer)

Correct answer: VALIDATE BACKUPSET

VALIDATE BACKUPSET reads backup pieces and verifies block checksums to confirm that the backup is readable and internally consistent without performing an actual restore.

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

Automatic Segment Management
Locally Managed Tablespace
Automatic Extensible Datafiles (AUTOEXTEND ON) (Correct answer)
Bigfile 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 102: Which competency is MOST essential for professionals working in implementation & configuration in Oracle Certified Master?

Speed of task completion above all else
Seniority-based decision making
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 103: What is the MOST effective way to stay current with developments in automation & scripting 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 104: Which factor BEST indicates mastery of security & access control 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 105: Which metric BEST indicates successful data management & integration in Oracle Certified Master?

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

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 106: When facing an unfamiliar challenge in implementation & configuration 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 107: What is the PRIMARY purpose of documentation & best practices in Oracle Certified Master?

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

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

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

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 109: Which single SQL statement opens all PDBs in a CDB simultaneously?

ALTER SYSTEM OPEN ALL PDBS
ALTER DATABASE OPEN ALL CONTAINERS
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 110: What is a Proxy PDB in Oracle Multitenant?

A standby PDB in an Active Data Guard configuration
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 PDB restricted to read-only access for auditing purposes

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 111: In Oracle Multitenant architecture, what does CDB stand for?

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

Correct answer: Container Database

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

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

To ensure quality outcomes through standardized practices and continuous improvement (Correct answer)
To limit the scope of professional activities
To create additional requirements for practitioners
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 113: Which procedure in the DBMS_PDB package is used to verify compatibility before plugging a PDB into a target CDB?

DBMS_PDB.DESCRIBE
DBMS_PDB.CHECK_PLUG_COMPATIBILITY (Correct answer)
DBMS_MULTITENANT.VALIDATE
DBMS_PDB.VERIFY_MANIFEST

Correct answer: DBMS_PDB.CHECK_PLUG_COMPATIBILITY

DBMS_PDB.CHECK_PLUG_COMPATIBILITY evaluates the PDB's XML manifest against the target CDB's version, character set, and installed components to report any incompatibilities.

Question 114: 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 115: Which privilege is required to execute the DBMS_STATS.GATHER_DATABASE_STATS procedure?

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

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 116: What is the PRIMARY objective of automation & scripting within the Oracle Certified Master profession?

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
To create additional requirements for practitioners

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

By implementing changes immediately without testing
By upgrading all systems simultaneously without staging
Through a structured change management process with testing and rollback plans (Correct answer)
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 118: What is the default open mode of a PDB immediately after it is created using CREATE PLUGGABLE DATABASE from PDB$SEED?

READ WRITE
MOUNTED (Correct answer)
READ ONLY
RESTRICTED

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 119: In Oracle Certified Master, how does cloud infrastructure & services contribute to professional credibility?

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

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 120: What is the PRIMARY objective of compliance & governance in the Oracle Certified Master field?

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

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.

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