OCP Security And Upgrades Practice Test 3 — 15 Questions

Question 1

Which file needs to be updated when you move the wallet location in 23ai?

Accepted Answer

sqlnet.ora. The sqlnet.ora file contains the WALLET_LOCATION parameter that must be updated.

Answer

init.ora

Answer

tnsnames.ora

Answer

listener.ora

Question 2

What is the primary purpose of 'Data Masking' in the Oracle Data Masking and Subsetting Pack?

Accepted Answer

To protect sensitive data in non-production databases. Data masking permanently obscures sensitive data in a non-production environment.

Answer

To improve performance

Answer

To encrypt data in transit

Answer

To audit privileged users

Question 3

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 4

You have a 19c database. Which tool must you run to ensure the database is ready for an upgrade to 23ai?

Accepted Answer

preupgrade.jar. The Pre-Upgrade Information Tool (preupgrade.jar) is mandatory for evaluating the source database.

Answer

utlrp.sql

Answer

dbv

Answer

catupgrd.sql

Question 5

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 6

When upgrading a database, what is a 'Flashback Database' used for?

Accepted Answer

Quick recovery after a failed upgrade. Flashback Database allows you to quickly revert to a point-in-time if the upgrade fails.

Answer

User authentication

Answer

Data migration

Answer

Performance tuning

Question 7

What is the best way to ensure an encrypted connection between the application server and the database?

Accepted Answer

Using Native Network Encryption. Configuring Native Network Encryption (NNE) or TLS on the listener ensures encrypted traffic.

Answer

Using Audit Vault

Answer

Using Database Vault

Answer

Using TDE

Question 8

What is the primary role of the 'Patching' phase in an upgrade?

Accepted Answer

To apply necessary updates to the dictionary. Ensuring the binaries and the data dictionary match the desired target version.

Answer

To clear the redo logs

Answer

To reorganize the tables

Answer

To increase memory

Question 9

What is the recommended tool to apply a bundle patch to a 23ai environment?

Accepted Answer

OPatch. OPatch is the standard utility for applying patches to Oracle software.

Answer

Enterprise Manager

Answer

RMAN

Answer

AutoUpgrade

Question 10

Which view can you use to check the status of TDE wallet encryption?

Accepted Answer

V$ENCRYPTION_WALLET. V$ENCRYPTION_WALLET displays the status of the wallet used for TDE.

Answer

V$TDE_STATUS

Answer

DBA_ENCRYPTION_STATUS

Answer

DBA_WALLET

Question 11

What happens to a traditional audit record when you migrate to Unified Auditing in 23ai?

Accepted Answer

Stay in separate tables. Traditional audit records are not automatically migrated; you should clear them or archive them before switching to Unified Auditing.

Answer

Automatically converted

Answer

Deleted automatically

Answer

Merged into the Unified Trail

Question 12

How do you disable a Unified Audit policy?

Accepted Answer

NOAUDIT POLICY. The 'NOAUDIT POLICY' command is used to disable a policy.

Answer

ALTER POLICY DISABLE

Answer

DISABLE AUDIT POLICY

Answer

DROP POLICY

Question 13

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 14

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 15

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