314 questions total · 5pages · All types, answers revealed
Page 5 of 5
In 23ai, if you want to audit 'CREATE TABLE' statements, which policy type should you use?
This is the standard approach for system actions.
Why this answer
A Unified Audit Policy for system events or actions is used.
What is the primary function of ADDM in Oracle Database 23ai?
This is the core purpose of ADDM.
Why this answer
ADDM analyzes AWR snapshots to identify performance bottlenecks and provide recommendations.
Which of these is a benefit of using JSON Duality Views?
This is the primary benefit.
Why this answer
It allows developers to work with JSON while maintaining relational data integrity.
You want to perform a point-in-time recovery to a specific timestamp. Which RMAN command is used to set the target time?
This is the correct syntax for point-in-time recovery.
Why this answer
SET UNTIL TIME is the standard way to define the recovery point.
What is the main benefit of JSON Duality Views?
The primary benefit.
Why this answer
It provides a bidirectional view of the data, both as JSON and as relational rows.
What is the result of setting STATISTICS_LEVEL to 'BASIC'?
BASIC level turns off most automated diagnostic tools.
Why this answer
Setting it to BASIC disables many diagnostic features, including AWR and ADDM.
What is the purpose of the 'REPORT OBSOLETE' command?
It lists them but does not delete them.
Why this answer
It identifies backups that are no longer needed based on the retention policy.
Which THREE steps are required for a manual TDE configuration?
Required step.
Why this answer
Setting the location, creating the wallet, and opening the wallet are the required steps.
An application query is failing to use a newly created index. You suspect the optimizer statistics are inaccurate. Which package should you use to gather statistics for this specific table?
This is the correct procedure for gathering table statistics.
Why this answer
DBMS_STATS is the standard package for managing optimizer statistics.
Which THREE components are involved in TDE master key management?
Stores the master key.
Why this answer
The keystore, the master key, and the database instance itself are the components.
Which TWO are common audit types in Oracle?
The current, recommended audit method.
Why this answer
Standard and Unified auditing are the two primary types.
You are analyzing a query with the SQL Tuning Advisor. The advisor recommends an 'SQL Profile'. What does the profile actually do?
Profiles guide the optimizer to better choices.
Why this answer
A SQL Profile provides additional optimizer hints and statistics corrections.
You are investigating high CPU utilization in the database. Which view provides the top SQL statements currently in memory based on CPU usage?
This view has CPU_TIME and EXECUTIONS columns to identify heavy SQL.
Why this answer
V$SQLAREA contains aggregated statistics for SQL statements in the library cache, including CPU_TIME.
You want to clear all configured RMAN settings back to their default values. Which command do you use?
This resets the specified parameter to the default.
Why this answer
CONFIGURE [parameter] CLEAR resets a specific setting to its default.
Page 5 of 5
Practice OCP by domain
Target a specific domain to shore up weak areas.