OCP Practice Test 12 — 15 Questions

Question 1

You are migrating a non-CDB database to a PDB in a 23ai CDB using the remote cloning method. Which condition must be met for the non-CDB to be successfully plugged in?

Accepted Answer

The non-CDB must be in READ ONLY mode. When plugging in a non-CDB, it must be opened in READ ONLY mode to ensure consistency during the cloning process, and the non-CDB must be at a version compatible with the CDB.

Answer

The non-CDB must be in MOUNTED state

Answer

The non-CDB must be in ARCHIVELOG mode

Answer

The non-CDB must have an identical DBID to the CDB

Question 2

You are migrating an Oracle 23ai database to a different platform with different endianness. Which RMAN command is used to convert the datafiles to the target platform format?

Accepted Answer

RMAN> CONVERT DATAFILE '...' TO PLATFORM '...' FROM PLATFORM '...';. The CONVERT DATAFILE command is required when the source and destination platforms have different endian formats.

Answer

RMAN> CONVERT DATABASE ON TARGET PLATFORM;

Answer

RMAN> RESTORE DATAFILE FROM PLATFORM;

Answer

ALTER DATABASE CONVERT TO PLATFORM;

Question 3

You want to perform a point-in-time recovery to a specific timestamp. Which RMAN command is used to set the target time?

Accepted Answer

SET UNTIL TIME '2023-10-10:10:00:00'. SET UNTIL TIME is the standard way to define the recovery point.

Answer

FLASHBACK DATABASE TO TIME '2023-10-10:10:00:00'

Answer

SET TIME '2023-10-10 10:00:00'

Answer

RECOVER DATABASE TO '2023-10-10:10:00:00'

Question 4

When managing local and common users in a 23ai CDB, which TWO of the following statements are correct?

Accepted Answer

Common users can only be created in the root container.. Common users must be created in the root (CDB$ROOT) and local users are specific to individual PDBs.

Answer

Local users are automatically created in all PDBs by default.

Answer

Common users can grant local roles to other common users.

Answer

Local users can grant privileges to common users.

Question 5

Which command is used to move a PDB from one CDB to another without using Data Pump?

Accepted Answer

ALTER PLUGGABLE DATABASE UNPLUG. The unplug/plug method using an XML metadata file is the standard for PDB transport.

Answer

CREATE PDB AS CLONE

Answer

DBMS_PDB.COPY

Answer

MOVE PLUGGABLE DATABASE

Question 6

Which privilege is required to perform a PDB unplug operation?

Accepted Answer

SYSDBA. SYSDBA or SYSOPER at the CDB root is required.

Answer

RESOURCE

Answer

CONNECT

Answer

PDB_DBA

Question 7

You are configuring a PDB. What happens to the PDB if you drop the CDB?

Accepted Answer

All PDBs are dropped. All PDBs are automatically removed when the CDB is dropped.

Answer

PDBs remain as standalone

Answer

PDBs become unusable orphans

Answer

PDBs are migrated to another CDB

Question 8

Which TWO actions are required to enable Flashback Database on a production environment?

Accepted Answer

Ensure the database is in ARCHIVELOG mode.. Flashback Database requires the database to be in ARCHIVELOG mode and the recovery area to be configured.

Answer

Restart the database in UPGRADE mode.

Answer

Set DB_RECOVERY_FILE_DEST_SIZE to zero.

Answer

Drop all existing restore points.

Question 9

You are investigating an RMAN backup failure. The log indicates that RMAN is unable to access the recovery area. Which view should you query to check the current space usage of the Fast Recovery Area?

Accepted Answer

V$RECOVERY_FILE_DEST. V$RECOVERY_FILE_DEST provides the directory, space limit, and space used for the FRA.

Answer

V$FLASHBACK_DATABASE_LOG

Answer

V$DATABASE_BLOCK_CORRUPTION

Answer

V$RMAN_STATUS

Question 10

You have a standby database and want to offload backups to it. What is the recommended way to register the standby's backups in the recovery catalog?

Accepted Answer

Connect RMAN to the standby and the catalog.. The standby database should be connected to the recovery catalog to register its own backups.

Answer

Run the register command on the primary.

Answer

Export the primary catalog metadata to the standby.

Answer

Use the import command in RMAN.

Question 11

Which THREE tasks are required when preparing for a database recovery using a new control file?

Accepted Answer

Perform RECOVER DATABASE USING BACKUP CONTROLFILE.. You need to restore, mount, and recover.

Answer

Delete all existing archivelogs.

Answer

Open the database resetlogs.

Question 12

A PDB is in 'READ WRITE' mode. You need to perform a maintenance task that requires the PDB to be in 'RESTRICTED' mode. Which command achieves this?

Accepted Answer

ALTER PLUGGABLE DATABASE PDB1 CLOSE IMMEDIATE; ALTER PLUGGABLE DATABASE PDB1 OPEN RESTRICTED;. To move a PDB into restricted mode, you must use ALTER PLUGGABLE DATABASE ... CLOSE followed by OPEN RESTRICTED.

Answer

ALTER SYSTEM SET RESTRICTED_SESSION=TRUE;

Answer

ALTER PLUGGABLE DATABASE PDB1 UPGRADE;

Answer

ALTER DATABASE PDB1 RESTRICTED;

Answer

ALTER PLUGGABLE DATABASE PDB1 OPEN RESTRICTED

Question 13

Which THREE of the following are prerequisites for performing an RMAN backup to an Oracle Cloud Infrastructure (OCI) Object Storage bucket?

Accepted Answer

A backup configuration file defining the bucket and compartment.. You need the OCI SDK, a configuration file, and the correct library.

Answer

The database must be migrated to 23ai.

Answer

The database must be in NOARCHIVELOG mode.

Question 14

Which RMAN configuration must be set to ensure that backups are automatically deleted when they are no longer needed?

Accepted Answer

CONFIGURE RETENTION POLICY. CONFIGURE RETENTION POLICY defines the criteria for what is obsolete.

Answer

CONFIGURE AUTO DELETE ON

Answer

SET RETENTION POLICY

Answer

CONFIGURE OBSOLETE ON

Question 15

Which TWO commands allow you to check for block corruption in a database?

Accepted Answer

BACKUP VALIDATE DATABASE. ANALYZE TABLE and RMAN validate are the primary methods.

Answer

SELECT * FROM V$LOG

Answer

ALTER SYSTEM CHECK

Answer

RECOVER DATABASE