We're so confident of our products that we provide no hassle product exchange.
IBM 000-302 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 9 Database and Application Fundamentals - Academic Initiative |
| Exam Number: | 000-302 |
| Related Certifications: | IBM Certified Database Associate - DB2 9 Fundamentals (000-730) |
| Exam Price: | Free for eligible Academic Initiative participants; ~$100-$150 USD for others |
| Certificate Validity Period: | Lifetime (no expiration) |
| Exam Duration: | 90 minutes |
| Passing Score: | 59% / 60% |
| Available Languages: | Spanish, Portuguese (Brazil), English, German, French, Italian |
| Real Exam Qty: | 60-64 |
| Exam Format: | Multiple response, Multiple choice |
| Recommended Training: | DB2 9 Academic Curriculum IBM DB2 9 Fundamentals Education |
| Exam Registration: | IBM Academic Initiative Pearson VUE Registration |
| Sample Questions: | IBM 000-302 Sample Questions |
| Exam Way: | Onsite at Pearson VUE test centers; online proctored exam available |
| Pre Condition: | Open only to students and educators participating in IBM Academic Initiative program; no prior certification required |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM 000-302 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Application Development | 13.5% | - DB2 client connectivity - Error handling - SQL in application code - Performance basics |
| Topic 2: Planning and DB2 Products | 14% | - DB2 9 editions and components - Database architecture and instances - Installation and configuration basics - DB2 tools and utilities |
| Topic 3: Data Access with SQL and XQuery | 23.5% | - Basic XQuery usage - Stored procedures and functions - Transactions: COMMIT, ROLLBACK - INSERT, UPDATE, DELETE - SELECT, JOIN, sorting, grouping |
| Topic 4: Security | 11% | - Privileges and authorities - GRANT and REVOKE statements - Authentication and authorization - Data and network encryption |
| Topic 5: Maintenance and Recovery | 10% | - Problem determination - Statistics and optimization - Basic backup and restore |
| Topic 6: Data Concurrency | 11% | - Isolation levels - Lock escalation and deadlocks - Locking mechanisms and modes - Transaction control |
| Topic 7: Working with Databases and Objects | 17% | - XML storage options - Data types and constraints - Connecting to databases - DDL statements - Schemas, tables, views, indexes |
By Marguerite
