OCP Practice Test 7 — 10 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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