We're so confident of our products that we provide no hassle product exchange.
Oracle 1Z1-117 Exam Overview:
| Certification Vendor: | Oracle |
| Exam Name: | Oracle Database 11g Release 2: SQL Tuning |
| Exam Number: | 1Z0-117 |
| Real Exam Qty: | 125 (approximate; based on community data, not official) |
| Exam Format: | Multiple choice, Multiple select |
| Passing Score: | Not publicly disclosed (Oracle does not publish official passing score for this exam) |
| Related Certifications: | Oracle Certified Expert, Oracle Database 11g Release 2 SQL Tuning |
| Available Languages: | English |
| Exam Price: | USD pricing varies by region (typically around $245 USD per Oracle standard exam fee) |
| Exam Duration: | 90–120 |
| Sample Questions: | Oracle 1Z1-117 Sample Questions |
| Exam Way: | Delivered via Oracle testing partners (e.g., Pearson VUE) in proctored testing centers or online proctored delivery where available. |
| Pre Condition: | Recommended: strong SQL knowledge and hands-on experience with Oracle Database; no formal prerequisite exam required to register. |
| Official Syllabus URL: | https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-117 |
Oracle 1Z1-117 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: SQL Performance Management | - Implement automatic SQL tuning - Manage SQL Plan Baselines and profiles |
| Topic 2: SQL Statement Processing and Tuning Concepts | - Describe execution steps of a SQL statement - Explain memory structures and optimizer components |
| Topic 3: Optimizer Behavior and Statistics | - Gather and use optimizer statistics effectively - Control optimizer behavior |
| Topic 4: Advanced Optimization Techniques | - Use optimizer hints where appropriate - Parallel execution and performance tuning |
| Topic 5: SQL Tuning Tools and Advisors | - Use SQL Access Advisor - Use SQL Tuning Advisor |
By Murphy
