OCP Practice Test 20 — 15 Questions

Question 1

Which TWO methods can be used to copy a PDB?

Accepted Answer

Cloning. Cloning and unplugging/plugging are standard methods.

Answer

Export/Import

Answer

SQL*Loader

Answer

Flashback

Question 2

Which TWO security features can be applied specifically to a PDB?

Accepted Answer

TDE (Encryption). Encryption and Auditing can be PDB-specific.

Answer

Instance Parameters

Answer

RMAN Backup Policy

Answer

Network ACLs

Question 3

Which THREE statements are true regarding the use of the 'ALTER PLUGGABLE DATABASE' command in a 23ai environment?

Accepted Answer

It can be used to define a service for the PDB. The command is versatile, allowing for state changes, file management, and resource plan applications, but it cannot be used for tasks like creating the CDB itself.

Answer

It can be used to upgrade the CDB dictionary

Answer

It can be used to delete the root container

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

Which THREE tools can be used to manage security settings?

Accepted Answer

Oracle Security Dashboard. SQL*Plus, EM, and the Oracle Security Dashboard are standard management tools.

Answer

AutoUpgrade

Answer

RMAN

Question 6

You need to perform a full database restore and recovery. The control file is lost. What is the correct sequence of operations?

Accepted Answer

STARTUP NOMOUNT; RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT; RESTORE DATABASE; RECOVER DATABASE; ALTER DATABASE OPEN RESETLOGS;. After losing the control file, you must restore it from an autobackup before you can restore the datafiles and perform recovery.

Answer

RESTORE DATABASE; RECOVER DATABASE; ALTER DATABASE OPEN RESETLOGS;

Answer

RESTORE SPFILE; STARTUP MOUNT; RECOVER DATABASE; ALTER DATABASE OPEN;

Answer

FLASHBACK DATABASE TO RESTORE POINT; ALTER DATABASE OPEN;

Question 7

Which component of the Oracle Database uses the Automatic Diagnostic Repository (ADR) to store critical errors and performance incidents?

Accepted Answer

Automatic Diagnostic Repository (ADR). ADR is the centralized location for all diagnostic data, including alert logs and incident dumps.

Answer

Automatic Database Diagnostic Monitor (ADDM)

Answer

AWR

Answer

SQL Plan Management

Question 8

You are creating a new PDB from an existing one using the CREATE PLUGGABLE DATABASE command. Which clause must you include to ensure the new PDB has a different name and storage location?

Accepted Answer

FILE_NAME_CONVERT. The CREATE PLUGGABLE DATABASE statement requires the file_name_convert clause to define the directory structure for the new PDB datafiles.

Answer

MOVE DATAFILES

Answer

USING STORAGE MAP

Answer

SNAPSHOT COPY

Question 9

What happens when you execute 'ALTER PLUGGABLE DATABASE ALL OPEN'?

Accepted Answer

Opens all PDBs in read-write mode. All PDBs in the CDB are opened in READ WRITE mode.

Answer

Opens only PDB$SEED

Answer

Opens all PDBs in read-only mode

Answer

Starts the CDB instance

Question 10

If you want to use a PDB as a template for other PDBs, what state must the template PDB be in?

Accepted Answer

READ ONLY. The PDB must be open in READ ONLY mode to be used as a template.

Answer

MOUNTED

Answer

RESTRICTED

Answer

READ WRITE

Question 11

Which THREE components are shared between a CDB and its PDBs?

Accepted Answer

Background processes. The SGA, background processes, and redo logs are shared.

Answer

Undo tablespace

Answer

Datafiles

Question 12

Which TWO tools can be used to perform PDB point-in-time recovery?

Accepted Answer

RMAN. RMAN and SQL*Plus are used to manage PDB PITR operations.

Answer

Data Pump

Answer

Net Manager

Answer

DBCA

Question 13

You observe that a PDB is consuming excessive UNDO tablespace. You want to implement 'Local Undo' mode for the CDB. What is the consequence of this change?

Accepted Answer

All PDBs must be closed before switching to local undo. Enabling Local Undo mode means each PDB manages its own undo tablespace. This is a CDB-wide setting that requires all PDBs to be closed before the CDB can be switched to this mode.

Answer

Local Undo is enabled by default in 23ai

Answer

Shared undo tablespace will be automatically deleted

Answer

Only new PDBs will use local undo

Question 14

You are performing a SQL tuning exercise. How do you create a SQL Tuning Set (STS) to be used as input for the SQL Tuning Advisor?

Accepted Answer

DBMS_SQLTUNE.CREATE_SQLSET. DBMS_SQLTUNE.CREATE_SQLSET is the required procedure to initialize an STS container.

Answer

DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT

Answer

DBMS_SPM.CREATE_BASELINE

Answer

DBMS_STATS.CREATE_STAT_TABLE

Question 15

You have a query that is being incorrectly optimized because the statistics are not representative of the actual data distribution. What is the best method to handle this without changing the global statistics?

Accepted Answer

Use DBMS_STATS.SET_TABLE_PREFS. Table-specific statistics collection with specific parameters or using preference settings can help.

Answer

Run the SQL Tuning Advisor

Answer

Modify the init.ora parameter

Answer

Create a SQL Plan Baseline