PDF Version DemoWhy wait to start? ActualPDF emails the complete Oracle Database 11g Release 2: SQL Tuning package, 125 1Z1-117 practice questions included, about a minute after payment, with customer service answering around the clock if anything goes wrong.
Oracle 1Z1-117 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g Release 2: SQL Tuning Exam |
| Exam Number: | 1Z0-117 |
| Available Languages: | English |
| Exam Format: | Multiple Choice, Multiple Answer |
| Certificate Validity Period: | Valid until Oracle retires the exam; typically 2-3 years after discontinuation |
| Related Certifications: | Oracle Database 12c Administrator Certified Professional Oracle Database 11g Administrator Certified Professional |
| Exam Duration: | 150 minutes |
| Exam Price: | USD 245 |
| Real Exam Qty: | 75-80 |
| Passing Score: | 61% |
| Recommended Training: | Oracle Database 11g: SQL Tuning Workshop Oracle SQL Tuning for Developers Workshop |
| Exam Registration: | Pearson VUE Registration Oracle Certification Portal |
| Sample Questions: |  |
| Exam Way: | Online proctored or onsite at authorized Pearson VUE testing centers |
| Pre Condition: | Recommended: OCP-level knowledge of Oracle Database 11g, SQL development, or database administration experience; no mandatory prerequisites |
| 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 | Weight | Objectives |
|---|---|---|
| Topic 1: SQL Tuning Advisor | 8% | - Profiling SQL statements - Running and interpreting tuning recommendations |
| Topic 2: Optimizer Hints | 5% | - Using hints appropriately - Limitations and risks of hints |
| Topic 3: Optimizer Statistics | 12% | - Setting preferences and using dynamic sampling - Gathering database and system statistics - Managing and modifying statistics |
| Topic 4: Star Transformation | 5% | - Star schema and query transformation |
| Topic 5: Optimizer Access and Join Operations | 12% | - Access paths for tables and indexes - Other operations: sorts, filters, result cache - Join types, methods and order |
| Topic 6: SQL Plan Management | 6% | - Configuring and managing SQL plan baselines - Controlling plan evolution |
| Topic 7: Application Tracing | 6% | - Configuring SQL Trace - Using trcsess and tkprof utilities |
| Topic 8: Introduction to SQL Tuning | 8% | - Causes of poor SQL performance - SQL tuning methodology and tools |
| Topic 9: Automated SQL Tuning | 4% | - Automatic SQL Tuning task |
| Topic 10: Introduction to the Optimizer | 10% | - SQL execution process - Optimizer modes and behavior control |
| Topic 11: Bind Variables | 7% | - Bind peeking and adaptive cursor sharing - Benefits of bind variables |
| Topic 12: SQL Access Advisor | 5% | - Recommending indexes, materialized views |
| Topic 13: Parallel Execution | 8% | - Parallel processing concepts - Configuring and tuning parallel queries |
| Topic 14: Interpreting Execution Plans | 12% | - Reading and interpreting plan details - Generating and displaying execution plans |
Questions and Answers About Oracle Database 11g Release 2: SQL Tuning
Oracle Database 11g Release 2: SQL Tuning is an official Oracle exam, listed under exam code 1Z1-117. A passing result earns you the Oracle Certified Expert, Oracle Database 11g Release 2: SQL Tuning certification at the Expert level. It also ties into Oracle Database 11g Administrator Certified Professional, Oracle Database 12c Administrator Certified Professional, extending its value across your certification roadmap. Employers read this credential as verified competence, which is why it keeps appearing in job requirements.
Expect 75-80 questions inside 150 minutes on the Oracle Database 11g Release 2: SQL Tuning exam. That pace punishes hesitation, so rehearse it: the ActualPDF software engine simulates the real exam scene, reminds you of the questions you got wrong, and pushes you to re-practice them until the clock stops being your enemy.
Passing Oracle Database 11g Release 2: SQL Tuning requires 61%, and the official registration fee is USD 245. Retakes charge the full USD 245 again, which is why experienced candidates treat preparation as the cheaper exam fee. Verify your readiness with repeated ActualPDF practice scores above the requirement before you commit to a date.
Recommended: OCP-level knowledge of Oracle Database 11g, SQL development, or database administration experience; no mandatory prerequisites
Requirements evolve, so confirm the current conditions before registering on the official exam page.
Registration for Oracle Database 11g Release 2: SQL Tuning goes through the official channels listed here.
When you schedule, note that the exam is delivered Online proctored or onsite at authorized Pearson VUE testing centers.
Oracle recommends the following training for Oracle Database 11g Release 2: SQL Tuning candidates.
Follow any course with the 125 practice questions in the ActualPDF 1Z1-117 package; the software engine will even remind you which mistakes need another round.
Yes. ActualPDF provides a free download demo of the Oracle Database 11g Release 2: SQL Tuning material, so you can check the content before choosing a version. After purchase, a one-year warranty covers you: the latest version is sent to you as it releases, free for 365 days, and after expiry you can extend the update service at a 50% discount.
Your purchase is covered by a 100% money-back guarantee with clear conditions. Take the Oracle Database 11g Release 2: SQL Tuning exam within 60 days of purchase; if you fail, provide your unqualified result by submitting a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and the full refund is processed within 7 days. The exam must match your product, candidate and payer names must match, and attempts within 3 days of purchase, unused downloads, free materials, and expired orders are not covered. Alternatively, exchange for two other exam products of equal value, free, or wait for updates while keeping your original product's update service.
Delivery is instant: files unlock for download at payment and are emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, which works 7/24 and normally replies within two hours. Installation is unlimited across your computers.
The Oracle Database 11g Release 2: SQL Tuning syllabus spans 14 domains, led by SQL Access Advisor (5%), Automated SQL Tuning (4%), and Optimizer Access and Join Operations (12%). The complete topic list is published above; candidates who study the map first rarely get lost later.
