Master Oracle OCP Exam: Tablespaces, Privileges, and RMAN Backup Explained

Question 1: Oracle Tablespace

The first multiple‑choice question tests knowledge of Oracle physical storage structures, specifically the differences between permanent, temporary, and UNDO tablespaces.

A. Incorrect. Permanent tablespaces (e.g., SYSTEM, SYSAUX, USERS) can be taken offline for maintenance or migration.

B. Correct. A temporary tablespace can be associated with only one tempfile ; it cannot have multiple datafiles like a permanent tablespace.

C. Correct. A permanent tablespace may contain multiple datafiles, but each datafile belongs to a single permanent tablespace.

D. Correct. UNDO tablespaces are dedicated to rollback operations and cannot be used for regular user data storage.

Correct answer: B, C, D

Question 2: Object vs. System Privilege

This single‑choice question asks which SQL statement correctly grants the HR user SELECT permission on the EMPLOYEES table.

A. Correct. GRANT SELECT ON EMPLOYEES TO HR; grants an object privilege on the specific table.

B. Incorrect. GRANT SELECT ANY TABLE TO HR; is a system privilege that would allow SELECT on any table, which exceeds the requirement.

C. Incorrect. Syntax error; the proper form is GRANT <privilege> ON <object> TO <user>.

D. Incorrect. System privileges cannot be granted with an ON clause.

Correct answer: A

Question 3: RMAN Hot Backup Command

The scenario‑based question evaluates the best RMAN command for performing a hot (online) backup while ensuring all archived logs are captured.

A. Correct but basic. BACKUP DATABASE; backs up the database and automatically includes archived logs if auto‑archiving is enabled.

B. Correct. BACKUP DATABASE INCREMENTAL LEVEL 0; performs a full incremental backup, effectively a complete backup with the same log handling.

C. Correct and safest. BACKUP DATABASE PLUS ARCHIVELOG; backs up the database and all current archived logs, guaranteeing recoverability even if the server fails during the backup.

D. Correct. BACKUP DATABASE AS BACKUPSET; specifies the backup set format but does not affect backup integrity.

Correct answer: C – using PLUS ARCHIVELOG is the most reliable choice for a hot backup scenario.