100+ Free Oracle 1Z0-182 Practice Questions

Oracle Database Architecture and Tools

Covers the Oracle instance and database, SGA components (shared pool, buffer cache, redo log buffer, large pool), PGA, background processes (DBWn, LGWR, CKPT, SMON, PMON, ARCn, MMON), logical storage (tablespace, segment, extent, block) and physical files, the multitenant container architecture, and tools such as SQL*Plus, SQL Developer and Enterprise Manager.

Managing Database Instances

Covers STARTUP NOMOUNT/MOUNT/OPEN and SHUTDOWN modes, managing initialization parameters with SPFILE and PFILE and ALTER SYSTEM, static and dynamic parameters, the data dictionary and V$ dynamic performance views, and diagnosing problems with the alert log and trace files in the Automatic Diagnostic Repository.

Oracle Net and Connectivity

Covers configuring and controlling the Oracle Net listener with lsnrctl, the listener.ora and tnsnames.ora files, dynamic service registration by PMON/LREG, easy connect and local naming, services and the DB service mapping to PDBs, and basic client-to-server connection troubleshooting.

Storage, Tablespaces and Undo

Covers creating and altering tablespaces and datafiles, bigfile vs smallfile tablespaces, Oracle Managed Files, automatic segment space management, temporary tablespaces and temp groups, the SYSAUX tablespace, and Automatic Undo Management including the undo tablespace, UNDO_RETENTION and guaranteed retention.

Users, Privileges, Auditing and Security

Covers creating local and common users, system and object privileges, the difference between roles and privileges, predefined roles, profiles for password and resource limits, schema-only (no-authentication) accounts, the principle of least privilege, and Unified Auditing with audit policies in Oracle Database 23ai.

Multitenant CDB and PDB Management

Covers the CDB root (CDB$ROOT), the seed (PDB$SEED) and pluggable databases, creating PDBs from the seed and by cloning, plugging and unplugging PDBs with XML or PDB archive files, opening and closing PDBs and saving their state, switching containers with ALTER SESSION SET CONTAINER, and common vs local objects and users.

Backup, Recovery and Redo

Covers redo log groups and members and log switches, checkpoints, ARCHIVELOG vs NOARCHIVELOG mode and the archiver process, instance recovery using online redo logs, the Fast Recovery Area, control files, and RMAN fundamentals including full and incremental backups, image copies and restore/recover concepts.

Maintenance, Data Movement and 23ai AI Features

Covers automated maintenance tasks, the Automatic Workload Repository (AWR), ADDM and advisors, moving data with Data Pump (expdp/impdp) and SQL*Loader, external tables, and new Oracle Database 23ai features such as AI Vector Search, the VECTOR data type, vector indexes and similarity search.