OCP Practice Test 3 — 30 Questions

Question 1

Which report provides a summary of SQL statements that have the highest 'Elapsed Time'?

Accepted Answer

AWR Report. The AWR report has a section specifically for Top SQL by Elapsed Time.

Answer

Alert Log

Answer

Listener Log

Answer

ADDM Report

Question 2

Which advisor should you run to determine if your SGA and PGA memory settings are optimal?

Accepted Answer

Memory Advisor. Memory Advisor identifies if memory pools are undersized or oversized.

Answer

SQL Access Advisor

Answer

SQL Tuning Advisor

Answer

ADDM

Question 3

What is the default state of a PDB after creating it using the CREATE PLUGGABLE DATABASE command?

Accepted Answer

MOUNTED. By default, a new PDB is created in MOUNTED state.

Answer

READ WRITE

Answer

OPEN UPGRADE

Answer

READ ONLY

Question 4

You observe a significant performance regression after a database upgrade. You suspect that the optimizer has chosen a suboptimal execution plan. Which component of SQL Plan Management should you use to ensure the database only uses known, verified execution plans?

Accepted Answer

SQL Plan Baselines. SQL Plan Baselines are used to ensure that only verified execution plans are used for a specific SQL statement, protecting against performance regressions.

Answer

Optimizer Statistics Advisor

Answer

SQL Tuning Sets

Answer

Automatic SQL Tuning Advisor

Question 5

Which utility is used to perform a 'fixup' during the AutoUpgrade process?

Accepted Answer

preupgrade_fixups.sql. AutoUpgrade performs fixups automatically, but you can also run them manually using the pre-upgrade fixup scripts.

Answer

srvctl

Answer

utlu122s.sql

Answer

catupgrd.sql

Question 6

When migrating to 23ai, which file is used to specify the target home directory in AutoUpgrade?

Accepted Answer

config.cfg. The AutoUpgrade .cfg file uses the 'target_home' parameter.

Answer

init.ora

Answer

oratab

Answer

spfile.ora

Question 7

Which command is used to start the AutoUpgrade process?

Accepted Answer

java -jar autoupgrade.jar. The command is 'java -jar autoupgrade.jar -config <config_file>'.

Answer

sqlplus / as sysdba

Answer

opatch

Answer

dbua

Question 8

Which TWO are common audit types in Oracle?

Accepted Answer

Unified Auditing. Standard and Unified auditing are the two primary types.

Answer

Tablespace Auditing

Answer

Instance Auditing

Answer

Flashback Auditing

Question 9

Which THREE steps are required for a manual TDE configuration?

Accepted Answer

Create the keystore. Setting the location, creating the wallet, and opening the wallet are the required steps.

Answer

Rebuild all tables

Answer

Encrypt the entire database

Question 10

Which THREE actions are part of the AutoUpgrade process?

Accepted Answer

Post-upgrade cleanup. AutoUpgrade handles the Pre-check, Upgrade, and Post-upgrade phases.

Answer

Applying security patches

Answer

Rebuilding the OS

Question 11

What is the default behavior of the Unified Audit trail in 23ai?

Accepted Answer

Stored in the SYSTEM tablespace. Unified audit records are stored in a secure table in the SYSTEM tablespace.

Answer

Not stored by default

Answer

Stored in the OS as XML files

Answer

Stored in the UNDO tablespace

Question 12

In 23ai, if you want to audit 'CREATE TABLE' statements, which policy type should you use?

Accepted Answer

Unified Audit Policy. A Unified Audit Policy for system events or actions is used.

Answer

Fine-Grained Auditing (FGA)

Answer

Logon Trigger

Answer

Traditional Audit

Question 13

Which THREE factors influence the duration of a database upgrade?

Accepted Answer

Number of database objects. The number of objects, the amount of data, and system resources all impact performance.

Answer

The color of the server

Answer

Number of users

Question 14

When configuring a secure listener in 23ai, which protocol is recommended for encrypted communication?

Accepted Answer

TCPS. TCPS (TCP with SSL/TLS) is required for encrypted listener communication.

Answer

TCP

Answer

IPC

Answer

HTTP

Question 15

Which TWO are benefits of TDE?

Accepted Answer

Helps with compliance. TDE provides security for data at rest and helps with regulatory compliance.

Answer

Reduces disk space

Answer

Simplifies login

Answer

Increases performance

Question 16

Which THREE things should be checked before upgrading to 23ai?

Accepted Answer

Current patch levels. System resources, disk space, and patch levels are critical checks.

Answer

Table indexes

Answer

Application user passwords

Question 17

When configuring Oracle Network Encryption, which TWO of the following parameters in the sqlnet.ora file are used to specify encryption settings?

Accepted Answer

SQLNET.ENCRYPTION_TYPES_SERVER. SQLNET.ENCRYPTION_SERVER and SQLNET.ENCRYPTION_TYPES_SERVER are the primary parameters for configuring server-side network encryption.

Answer

TNS_ENCRYPTION_ENABLED

Answer

SQLNET.AUTHENTICATION_SERVICES

Answer

NETWORK_SECURE_MODE

Question 18

Which tool can be used to monitor the progress of an AutoUpgrade process?

Accepted Answer

AutoUpgrade Job Monitor. The AutoUpgrade tool provides a job monitor output in the log file directory.

Answer

ADRCI

Answer

SQL*Plus

Answer

Enterprise Manager

Question 19

Your organization requires that all data stored in the 23ai database be encrypted at rest using Transparent Data Encryption (TDE). You have configured the Keystore. Which command correctly rotates the master encryption key without re-encrypting all existing data blocks immediately?

Accepted Answer

ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY 'password' WITH BACKUP;. ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY 'password' WITH BACKUP rotates the master key, which is a metadata-only operation for TDE tablespaces.

Answer

ALTER SYSTEM SET ENCRYPTION KEY;

Answer

ALTER TABLESPACE USERS REKEY;

Answer

ALTER SYSTEM ROTATE MASTER KEY;

Question 20

Which TWO files are modified to configure a secured listener?

Accepted Answer

listener.ora. listener.ora and sqlnet.ora are both typically involved in network security configuration.

Answer

spfile.ora

Answer

init.ora

Answer

tnsnames.ora