Mixed Deck — All OCM Topics Flashcards

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)?

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.

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

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.

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

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.

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

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.

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?

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.

What is the PRIMARY objective of automation & scripting within the Oracle Certified Master profession?

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.

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

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.

What is a Materialized View Log used for in Oracle?

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.

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

Answer: DBA_DEPENDENCIES

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

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

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.

What does a Refreshable PDB provide in Oracle Multitenant?

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.

Which factor BEST indicates mastery of security & access control in Oracle Certified Master?

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.

In Oracle Database, which isolation level prevents dirty reads and non-repeatable reads but still allows phantom reads by default?

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).

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

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.

In Oracle, what does the PCTFREE storage parameter control?

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.

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

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.

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

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.

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

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.

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

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.

Which SQL hint forces the Oracle optimizer to use a full table scan instead of an index?

Answer: /*+ FULL(table) */

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