100+ Free Oracle Database Administration I Practice Questions

Understanding Oracle Database Architecture

Distinguish an instance (SGA plus background processes) from a database (data files, control files, online redo logs); identify SGA components such as the buffer cache, shared pool, and redo log buffer and the role of the PGA; and know background processes DBWn, LGWR, CKPT, SMON, PMON, and ARCn plus the block, extent, segment, and tablespace hierarchy.

Managing Database Instances

Start and stop the instance through NOMOUNT, MOUNT, and OPEN, choosing the right shutdown mode; manage initialization parameters using an SPFILE versus a PFILE and ALTER SYSTEM scope options; query V$PARAMETER; and locate diagnostics in the Automatic Diagnostic Repository and alert log via DIAGNOSTIC_DEST.

Managing Tablespaces and Datafiles

Create and manage SYSTEM, SYSAUX, undo, temporary, smallfile, and bigfile tablespaces; add, resize, autoextend, move online, and rename datafiles; use locally managed tablespaces with bitmap extent management, Automatic Segment Space Management, and Oracle Managed Files; and monitor free space.

Managing Users, Roles, and Privileges

Create users with default tablespaces and quotas, grant CREATE SESSION and other system and object privileges, build and grant roles, apply profiles for password and resource limits, use WITH ADMIN and WITH GRANT OPTION correctly, and enforce least privilege with Privilege Analysis.

Managing Storage and Undo

Understand segment types, extents, deferred segment creation, and space reclamation; configure automatic undo management with UNDO_TABLESPACE and UNDO_RETENTION; use RETENTION GUARANTEE; differentiate undo from redo; and resolve ORA-01555 and out-of-space conditions.

Moving and Loading Data

Move data with Data Pump expdp and impdp using directory objects, export modes, REMAP_SCHEMA, and network mode; load flat files with SQL*Loader using conventional and direct path; and query external tables with the ORACLE_LOADER and ORACLE_DATAPUMP access drivers.

Configuring Oracle Net Services

Configure and administer the listener with listener.ora and lsnrctl, resolve net service names with tnsnames.ora, understand dynamic service registration and SERVICE_NAME versus SID, and troubleshoot errors such as ORA-12541 (TNS:no listener).

Oracle Supplied Tools and Backup Concepts

Use SQL*Plus to run SQL, PL/SQL, and administrative commands and connect AS SYSDBA; and understand backup and recovery concepts including RMAN, incremental backups, the Fast Recovery Area, ARCHIVELOG mode, instance versus media recovery, and Flashback Database.