1Z0-031 Exam Dumps
Oracle9i database:fundamentals i 1Z0-031 real exam questions and online practice test engine by FreeCram. Try 1Z0-031 exam questions for free. You can also download a free demo of the 1Z0-031 exam PDF version.
Oracle's 1Z0-031 actual exam materials brought to you by FreeCram group of Oracle certification experts.
View all 1Z0-031 actual exam questions & answers and explanations for free.
If you like our product, you can request full access to all the latest Oracle9i database:fundamentals i 1Z0-031 exam premium questions.
| Certification Provider: | Oracle |
|---|---|
| Exam Code / Number: | 1Z0-031 |
| Exam Name: | Oracle9i database:fundamentals i |
| Exam Questions: | 172 |
| Last Updated: | Aug 04, 2026 |
| Corresponding Certification: | 9i DBA |
(205 Up Votes)Oracle 1Z0-031 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Security & User Administration | 15% | - Password file authentication - Roles and privilege management - User accounts and profiles - System and object privileges |
| Topic 2: Globalization Support | 10% | - NLS parameters and settings - Character sets and language configuration - Retrieving NLS information |
| Topic 3: Database Creation & File Management | 15% | - Database creation via DBCA and manual method - Control files multiplexing and management - Redo log files configuration - Oracle-Managed Files (OMF) |
| Topic 4: Schema Objects Management | 20% | - Indexes creation and maintenance - Creating and altering tables - Data types and row structure - Constraints and data integrity |
| Topic 5: Tablespaces & Storage Structures | 20% | - Automatic Undo Management - Data files and storage allocation - Temporary and permanent segments - Creating and managing tablespaces |
| Topic 6: Oracle Architecture & Instance Management | 20% | - Initialization parameter files - Oracle9i architecture components - Starting and shutting down instances - Diagnostic and alert files |