- Exam Code: 1Z1-117
- Exam Name: Oracle Database 11g Release 2: SQL Tuning Exam
- Updated: Sep 21, 2026
- Q & A: 125 Questions and Answers
Earning the Oracle Database 11g Release 2: SQL Tuning tells employers your skills meet Oracle standards, which is exactly why the exam is demanding. Actual4Dumps prepares you for the 1Z1-117 exam with 125 practice questions aligned to the official 2026 objectives.
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g Release 2: SQL Tuning Exam |
| Exam Number: | 1Z0-117 |
| Certificate Validity Period: | Valid until Oracle retires the exam; typically 2-3 years after discontinuation |
| Exam Price: | USD 245 |
| Real Exam Qty: | 75-80 |
| Available Languages: | English |
| Exam Format: | Multiple Answer, Multiple Choice |
| Related Certifications: | Oracle Database 11g Administrator Certified Professional Oracle Database 12c Administrator Certified Professional |
| Exam Duration: | 150 minutes |
| Passing Score: | 61% |
| Recommended Training: | Oracle Database 11g: SQL Tuning Workshop Oracle SQL Tuning for Developers Workshop |
| Exam Registration: | Oracle Certification Portal Pearson VUE Registration |
| 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 |
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: SQL Plan Management | 6% | - Configuring and managing SQL plan baselines - Controlling plan evolution |
| Topic 2: SQL Access Advisor | 5% | - Recommending indexes, materialized views |
| Topic 3: Introduction to the Optimizer | 10% | - SQL execution process - Optimizer modes and behavior control |
| Topic 4: Bind Variables | 7% | - Bind peeking and adaptive cursor sharing - Benefits of bind variables |
| Topic 5: Automated SQL Tuning | 4% | - Automatic SQL Tuning task |
| Topic 6: Interpreting Execution Plans | 12% | - Generating and displaying execution plans - Reading and interpreting plan details |
| Topic 7: Optimizer Hints | 5% | - Using hints appropriately - Limitations and risks of hints |
| Topic 8: SQL Tuning Advisor | 8% | - Profiling SQL statements - Running and interpreting tuning recommendations |
| Topic 9: Application Tracing | 6% | - Configuring SQL Trace - Using trcsess and tkprof utilities |
| Topic 10: Parallel Execution | 8% | - Parallel processing concepts - Configuring and tuning parallel queries |
| Topic 11: Introduction to SQL Tuning | 8% | - SQL tuning methodology and tools - Causes of poor SQL performance |
| Topic 12: Optimizer Access and Join Operations | 12% | - Access paths for tables and indexes - Join types, methods and order - Other operations: sorts, filters, result cache |
| Topic 13: Optimizer Statistics | 12% | - Managing and modifying statistics - Gathering database and system statistics - Setting preferences and using dynamic sampling |
| Topic 14: Star Transformation | 5% | - Star schema and query transformation |
The Oracle Database 11g Release 2: SQL Tuning is the official Oracle exam that leads to the Oracle Certified Expert, Oracle Database 11g Release 2: SQL Tuning certification at the Expert level. Passing it validates your skills against Oracle standards and proves your qualification to current and future employers. The credential is also connected with related certifications such as Oracle Database 11g Administrator Certified Professional, Oracle Database 12c Administrator Certified Professional, so it can serve as a solid step in a broader certification path.
The 1Z1-117 exam has 75-80 questions in total and must be completed within 150 minutes. That leaves only a narrow time budget per item, so train yourself to flag a difficult question, move on, and circle back later instead of getting stuck. A week or two before your test date, run at least one full timed mock exam in the Actual4Dumps desktop or online test engine under the same 150 minutes limit, and repeat until you can finish with a few minutes left for review.
The passing score for the 1Z1-117 exam is 61%, and the official registration fee is USD 245. Keep in mind that a failed attempt is not discounted — retaking the exam means paying the full fee again — so it is wise not to book your seat until your practice scores sit comfortably above the passing mark. Working through the 125 questions at Actual4Dumps in timed mode is a reliable way to judge when you are truly ready.
Oracle sets the following requirement for the 1Z1-117 exam: Recommended: OCP-level knowledge of Oracle Database 11g, SQL development, or database administration experience; no mandatory prerequisites. Eligibility rules can change from time to time, so always confirm the current prerequisites on the official exam page at https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-117 before you register.
You can register for the Oracle Database 11g Release 2: SQL Tuning through the following official channels:
The 1Z1-117 exam is delivered as Online proctored or onsite at authorized Pearson VUE testing centers, so review the technical and check-in requirements for that format when you schedule your appointment.
Oracle recommends the following official training options for the Oracle Database 11g Release 2: SQL Tuning:
Official courses build the theory, and pairing them with the 125 practice questions from Actual4Dumps turns that knowledge into exam-ready answers.
Yes. Actual4Dumps offers a free PDF demo for the Oracle Database 11g Release 2: SQL Tuning, so you can review real sample questions and judge the quality before paying anything. After your purchase, you receive 365 days of free updates — whenever the question pool changes, you get the latest version at no cost. Once that period expires, you can extend your update service at a 50% discount from your member zone.
If you take the 1Z1-117 exam within 60 days of your purchase and do not pass, you can apply for a full refund under our 100% Money Back Guarantee. To qualify, submit a scanned copy of your exam enrollment slip together with your official Score Report (PDF) within 2 days after the exam date, and your claim will be processed within 7 days. Note that the guarantee applies only to the corresponding exam: attempts taken within 3 days of purchase, downloaded-but-unused materials, free resources, and expired orders are not eligible, and the candidate name must match the purchaser name. If you would rather not refund, you can exchange the product for two free exam products of equal value while keeping the update service on your original purchase.
Delivery is instant: your files are available to download right after payment and are also sent to your email within one minute. If nothing arrives within 2 hours, contact our support team (and check your spam folder first). There is no limit on the number of computers you can install the product on.
The Oracle Database 11g Release 2: SQL Tuning is organized into 14 domains. Among the first ones are Application Tracing (6%), SQL Access Advisor (5%), Optimizer Access and Join Operations (12%), and the remaining domains cover the rest of the official objectives. For the complete topic breakdown with every subtopic, see the full 1Z1-117 exam outline above on this page.
Over 45369+ Satisfied Customers
Actual4Dumps 1Z1-117 practice questions are my best helper.
I passed exam today with 97%. I just studied 1Z1-117 dump file but it is not difficult to pass.
Valid and latest 1Z1-117 exam questions. 95% questions is found on the real exam. Only 3 is out. You can trust me. Every detail is perfect.
Just passed the 1Z1-117Oracle Databaseexam. I used your Actual4Dumps 1Z1-117 exam software and was skilled to do even better
I must say that Actual4Dumps's 1Z1-117 Practice Tests for exam hugely helped me out in doing a productive exam preparation. These unique mock tests were made on the pattern of the real exam
It really has changed my professional career , your 1Z1-117 exam quite helpful, and I passed 1Z1-117 with 92%.
Passed the 1Z1-117 exam with 98% marks! I have never gained so high marks in the exams. Thanks!
Actual4Dumps brought to me the most blissful moment of my life!
I cleared my 1Z1-117 exam and I feel great!
Thank you team. Just passed 1Z1-117 exam and had same questions from your dumps!
I could never imagine that 1Z1-117 exam preparation as easy as Actual4Dumps's very effective and productive guide made it for me.
Before purchasing the 1Z1-117 exam dump, i was struggling with the topics. now, i am stress free as i have score really high marks in last week’s exam.
1Z1-117 exam dumps have been great at providing me with the skills that I needed to prepare for my exam and get maximum score. Thank you!
Thank you so much for your 1Z1-117 help.
Actual4Dumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
If you prepare for the exams using our Actual4Dumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Actual4Dumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.