Oracle 1Z0-076 study plan

Install Oracle Database 19c on a lab VM and document each step of the install with screenshots in your notes

Create a container database (CDB) with two pluggable databases (PDBs) using DBCA and record the non-default parameters you chose

Configure the listener and tnsnames.ora, then prove connectivity with sqlplus from both local and remote sessions

Start and stop the instance using SQL*Plus and lsnrctl, and write down which files are read at each startup stage

Create and manage tablespaces, including a bigfile tablespace and one with automatic segment space management

Create users with quotas, assign default and temporary tablespaces, and demonstrate profile-based password and resource limits

Grant and revoke system and object privileges and test the results with a second user account

Query the data dictionary views (DBA_USERS, DBA_TABLESPACES, DBA_DATA_FILES, DBA_ROLE_PRIVS) to verify every change you made

Configure ARCHIVELOG mode and set the fast recovery area size and location

Take a full RMAN backup of the CDB plus one PDB and store the command in a reusable script

Perform a point-in-time recovery after deliberately dropping a table, using RMAN and flashback as alternative paths

Explain in your notes the difference between restoring and recovering, and when each is required

Move data with Data Pump: export one schema, import it into a second PDB, and compare row counts

Set up a database link and copy a table between two PDBs over the link

Diagnose and resolve a failed Data Pump job by reading the log and fixing the cause

Load a CSV file with SQL*Loader and verify the loaded rows

Tune a slow query by reading the execution plan from DBMS_XPLAN and adding an index

Gather optimizer statistics on a table and show how the plan changes after statistics are refreshed

Configure the Automatic Workload Repository retention and generate an AWR report for a workload window

Identify the top wait events in the AWR report and state one action for each of the two largest

Create and manage an Automatic Storage Management (ASM) instance and add a disk group

Configure and test Oracle Net for a shared server connection and resolve a simulated listener failure

Change a database parameter with ALTER SYSTEM and decide whether SCOPE=MEMORY, SPFILE, or BOTH is correct

Monitor space usage and resolve a simulated tablespace-full condition without downtime

Create a PDB from an existing PDB using a cloning method and verify both operate independently

Unplug and plug a PDB into a second CDB, then resolve any compatibility or file-path issue

Configure the multitenant features you are most likely to be tested on, such as PDB lockdown profiles and common versus local users

Review your notes on CDB/PDB architecture and write a short summary of the key differences from non-CDB databases

Take two full-length practice exams under timed conditions and log every missed question by topic

Re-study the three topics with the most misses and re-run the relevant lab exercise for each

Build a one-page command reference of the SQL and RMAN syntax you most often got wrong

Schedule the exam and complete a final review of your lab notes and troubleshooting log