1Z0-082 Cheat Sheet 2026

The 30 highest-yield 1Z0-082 facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. What is a synonym in Oracle Database? → An alias for another schema object
2. Which Oracle feature provides automatic detection and correction of performance issues? → Automatic Database Diagnostic Monitor (ADDM)
3. What is a materialized view in Oracle Database? → A physical copy of query results stored as a table and refreshable on demand or schedule
4. A DBA is using the Oracle Net Manager (netmgr) graphical tool. Which of the following tasks can be accomplished using this utility? → Configuring listeners, naming methods, and network profiles.
5. What is the primary purpose of a sequence object in Oracle Database? → To generate unique numeric values automatically
6. How does TRUNCATE TABLE differ from DELETE without a WHERE clause in Oracle? → TRUNCATE removes all rows quickly without generating undo and cannot be rolled back
7. Which clause must be included in the CREATE DATABASE statement to create a Container Database (CDB)? → ENABLE PLUGGABLE DATABASE
8. What is a 'local user' in Oracle Multitenant Architecture? → A user created within a specific PDB and accessible only in that PDB
9. Where does Oracle Database write critical error messages, startup and shutdown information, and background process messages? → The Alert Log
10. Which component of the Oracle Database architecture is responsible for managing memory structures and background processes? → Oracle Instance
11. When AUDIT_TRAIL is set to DB, where are standard audit records stored? → In the SYS.AUD$ table in the database
12. How is an AWR report typically generated from the Oracle command line using SQL*Plus? → By running the awrrpt.sql script from $ORACLE_HOME/rdbms/admin/
13. Which dynamic performance view shows ALL containers in a CDB, including CDB$ROOT and PDB$SEED? → V$CONTAINERS
14. When a table is dropped using the DROP TABLE command in Oracle, where does it go by default? → It is moved to the Recycle Bin
15. Which view should be queried to check the real-time OPEN_MODE of all PDBs in a CDB? → V$PDBS
16. Which Oracle feature is primarily used for monitoring database performance in real-time? → Automatic Workload Repository (AWR)
17. What is the purpose of the Oracle Data Dictionary? → To hold metadata that describes the database structure
18. What is an Index-Organized Table (IOT) in Oracle? → A table whose rows are stored in primary key order within a B-tree index structure
19. Which Oracle object type stores a precompiled SQL SELECT statement and can be queried like a table? → View
20. What is the purpose of Oracle's Control File? → To maintain the metadata of the database's physical structure
21. Which Oracle tool is primarily used for performing database maintenance tasks such as backup and recovery? → Oracle Enterprise Manager (OEM)
22. Which SQL statement opens all PDBs in a CDB at once? → ALTER PLUGGABLE DATABASE ALL OPEN
23. What information does the V$SESSION_WAIT view provide to a DBA? → The current or last wait event, wait class, and time waited for each session
24. Which Oracle Enterprise Manager feature provides real-time SQL execution monitoring showing active SQL plan steps? → SQL Monitor (Real-Time SQL Monitoring)
25. Which dynamic performance view shows all currently connected sessions in an Oracle database? → V$SESSION
26. Which Oracle tool is used to capture and analyze SQL execution plans? → SQL Trace and TKPROF
27. Which Oracle utility is used to reorganize tables and indexes to reclaim unused space? → DBMS_REDEFINITION
28. Which of the following is an example of a system privilege? → CREATE TABLE
29. Which initialization parameter must be set to 'AUTO' to enable Automatic Undo Management (AUM)? → UNDO_MANAGEMENT
30. Which dynamic performance view provides detailed wait event information for each current session in Oracle? → V$SESSION_WAIT