OCP Practice Test 24 — 15 Questions

Question 1

Which user is responsible for the management of the Unified Audit trail?

Accepted Answer

AUDIT_ADMIN. The AUDIT_ADMIN role is required for managing unified audit policies and data.

Answer

SYSDBA

Answer

DBA

Answer

SECURITY_ADMIN

Question 2

Which THREE factors influence the optimizer's choice of an execution plan?

Accepted Answer

Optimizer statistics. The optimizer considers statistics, system parameters, and schema objects.

Answer

The current time of day

Answer

User password strength

Question 3

You need to perform a Rolling Upgrade using Data Guard. What is the minimum required configuration?

Accepted Answer

Physical Standby Database. A physical standby database is required to perform a rolling upgrade using transient logical standby or switchover methods.

Answer

Active Data Guard

Answer

Oracle GoldenGate

Answer

Snapshot Standby

Question 4

Which TWO methods can be used to tune SQL statements?

Accepted Answer

Manual addition of optimizer hints. Manual tuning with hints and automated tuning via advisors are common practices.

Answer

Increasing the number of backups

Answer

Dropping the database

Answer

Changing user roles

Question 5

When using the SQL Tuning Advisor to analyze a SQL statement, which THREE types of recommendations can it provide to improve performance?

Accepted Answer

Creating a SQL profile. The SQL Tuning Advisor can suggest creating new indexes, refreshing optimizer statistics, and creating SQL profiles to alter the execution plan.

Answer

Restructuring the SQL query syntax

Answer

Renaming database tables

Question 6

You are upgrading from 19c to 23ai and need to identify incompatible parameters before the upgrade. Which tool should you use?

Accepted Answer

Pre-Upgrade Information Tool. The Pre-Upgrade Information Tool (preupgrade.jar) is the standard method for identifying parameter incompatibilities.

Answer

Cloud Pre-Migration Advisor Tool

Answer

Oracle Fleet Patching and Provisioning

Answer

DBUA

Question 7

You want to audit only the SELECT statements performed by a specific user on a specific table. How is this achieved?

Accepted Answer

Unified Audit Policy with a WHEN clause. Use a Unified Audit Policy with the 'WHEN' clause to filter the user and the 'OBJECT' clause for the table.

Answer

Traditional audit

Answer

Flashback Data Archive

Answer

Database Trigger

Question 8

How do you ensure that a user cannot connect to the database via SQL*Plus but can connect via an application service?

Accepted Answer

Create a Logon Trigger. You can use a login trigger to check the program name (e.g., 'sqlplus.exe') and reject connections.

Answer

Modify TNSNAMES.ORA

Answer

Use Profile limits

Answer

Revoke CONNECT role

Question 9

Which parameter ensures that the listener uses a wallet for SSL?

Accepted Answer

WALLET_LOCATION. The listener.ora file must be configured with the SSL_CLIENT_AUTHENTICATION and WALLET_LOCATION parameters.

Answer

SECURE_CONTROL_LISTENER

Answer

SSL_CIPHER_SUITES

Answer

SSL_SERVER_CERT_DN

Question 10

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 11

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 12

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 13

Which TWO statements about Unified Auditing are correct?

Accepted Answer

It replaces standard auditing. Unified auditing is enabled by default in some configurations and is the replacement for standard auditing.

Answer

It requires manual setup for all events

Answer

It is only for Linux

Answer

It only works with SYS user

Question 14

Which THREE tasks are performed after an upgrade is finished?

Accepted Answer

Recompile invalid objects. Post-upgrade, you must run the timezone script, recompile invalid objects, and gather dictionary statistics.

Answer

Create new users

Answer

Deinstall old version

Question 15

Which THREE things can prevent an AutoUpgrade process from starting?

Accepted Answer

Existing lock files. Insufficient space, incorrect permissions, or already running processes are common blockers.

Answer

Expired passwords

Answer

Too many users