- Exam Code: 1Z0-117
- Exam Name: Oracle Database 11g Release 2: SQL Tuning Exam
- Updated: Aug 30, 2026
- Q & A: 125 Questions and Answers
Short on time before your 1Z0-117 exam date? Actual4Dumps packs 125 focused practice questions for the Oracle Database 11g Release 2: SQL Tuning into a format you can work through whenever a spare hour appears, so even a busy schedule is no excuse.
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g Release 2: SQL Tuning Exam |
| Exam Number: | 1Z0-117 |
| Exam Format: | Multiple Answer, Multiple Choice |
| Passing Score: | 61% |
| Related Certifications: | Oracle Database 12c Administrator Certified Professional Oracle Database 11g Administrator Certified Professional |
| Real Exam Qty: | 75-80 |
| Certificate Validity Period: | Valid until Oracle retires the exam; typically 2-3 years after discontinuation |
| Available Languages: | English |
| Exam Price: | USD 245 |
| Exam Duration: | 150 minutes |
| 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 |
| Section | Weight | Objectives |
|---|---|---|
| Parallel Execution | 8% | - Parallel processing concepts - Configuring and tuning parallel queries |
| Interpreting Execution Plans | 12% | - Reading and interpreting plan details - Generating and displaying execution plans |
| SQL Plan Management | 6% | - Controlling plan evolution - Configuring and managing SQL plan baselines |
| Bind Variables | 7% | - Benefits of bind variables - Bind peeking and adaptive cursor sharing |
| Automated SQL Tuning | 4% | - Automatic SQL Tuning task |
| Introduction to SQL Tuning | 8% | - Causes of poor SQL performance - SQL tuning methodology and tools |
| Application Tracing | 6% | - Using trcsess and tkprof utilities - Configuring SQL Trace |
| SQL Access Advisor | 5% | - Recommending indexes, materialized views |
| Optimizer Statistics | 12% | - Managing and modifying statistics - Setting preferences and using dynamic sampling - Gathering database and system statistics |
| Optimizer Access and Join Operations | 12% | - Join types, methods and order - Access paths for tables and indexes - Other operations: sorts, filters, result cache |
| Star Transformation | 5% | - Star schema and query transformation |
| Introduction to the Optimizer | 10% | - Optimizer modes and behavior control - SQL execution process |
| Optimizer Hints | 5% | - Limitations and risks of hints - Using hints appropriately |
| SQL Tuning Advisor | 8% | - Running and interpreting tuning recommendations - Profiling SQL statements |
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 1Z0-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 1Z0-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 1Z0-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 1Z0-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 1Z0-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 Parallel Execution (8%), Introduction to SQL Tuning (8%), Introduction to the Optimizer (10%), and the remaining domains cover the rest of the official objectives. For the complete topic breakdown with every subtopic, see the full 1Z0-117 exam outline above on this page.
Question 1
Which two statements are true about the trcsess utility?
A. It merges multiple trace files and produces a formatted output file.
B. It produces multiple files only for DBA sessions, which can be consolidated into one formatted file using the tkprof utility.
C. It produces multiple files for a service, which can be consolidated into one formatted file using the tkprof utility.
D. It merges multiple trace files from a particular session into one single trace file.
E. It merges files pertaining to a user session scattered across different processes in a shared server configuration.
Question 2
Refer to the Exhibit.
Execution plan:
What must be the correct order of steps that the optimizer executes based on the ID column the execution plan?
A. 3, 5, 4, 6, 7
B. 3, 4, 5, 7, 6
C. 3, 5, 4, 7, 6
D. 4, 5, 3, 7, 6
Question 3
View the exhibit and examine the findings provided by the SQL Tuning Advisor for SELECT Statement.
A SWL plan baseline already exists for the execution plan.
What two methods can you use to ensure that an alternate plan becomes an accepted plan?
A. Use the DBMS_SPM.LOAD_PLANS_FROM_SQLSET function.
B. Use the DBMS_SPM.ALTER_SQL_PLAN_BASELINE function.
C. Use the DBMS_SQLTUNE.CREATE_SQL_PLAN_BASELINE function.
D. Use the DBMS_SQLTUNE.CREATE_SQL_PLAN_BASELINE function and run the DBMS_STATS to manually refresh stale statistics.
Question 4
View Exhibit1 and examine the structure and indexes for the MYSALES table.
The application uses the MYSALES table to insert sales record. But this table is also extensively used for generating sales reports. The PROD_ID and CUST_ID columns are frequently used in the WHERE clause of the queries. These columns have few distinct values relative to the total number of rows in the table. The MYSALES table has 4.5 million rows.
View exhibit 2 and examine one of the queries and its autotrace output.
Which two methods can examine one of the queries and its autotrace output?
A. Drop the current standard balanced B* Tree indexes on the CUST_ID and PROD_ID columns and re-create as bitmapped indexes.
B. Create a composite index involving the CUST_ID and PROD_ID columns.
C. Collect histogram statistics for the CUST_ID and PROD_ID columns.
D. Use the INDEX_COMBINE hint in the query.
E. Rebuild the index to rearrange the index blocks to have more rows per block by decreasing the value for PCTFRE attribute.
Question 5
You are administering a database supporting an OLTP application. The application runs a series of extremely similar queries the MYSALES table where the value of CUST_ID changes.
Examine Exhibit1 to view the query and its execution plan.
Examine Exhibit 2 to view the structure and indexes for the MYSALES table. The MYSALES table has 4 million records.
Data in the CUST_ID column is highly skewed. Examine the parameters set for the instance:
Which action would you like to make the query use the best plan for the selectivity?
A. Decrease the value of the OPTIMIZER_DYNAMIC_SAMPLING parameter to 0.
B. Us the /*+ INDEX(CUST_ID_IDX) */ hint in the query.
C. Drop the existing B* -tree index and re-create it as a bitmapped index on the CUST_ID column.
D. Collect histogram statistics for the CUST_ID column and use a bind variable instead of literal values.
Solutions:
| Question 1 Answer: A,D | Question 2 Answer: D | Question 3 Answer: A,D | Question 4 Answer: B,D | Question 5 Answer: D |
Over 45369+ Satisfied Customers
With 1Z0-117 exam questions, my preparation time was saved and i was able to spend some time relaxing before the 1Z0-117 exams. I passed the 1Z0-117 exam easily. The 1Z0-117 practice dumps are good guides, certainly.
I passed highly in my 1Z0-117 exam. Thank you for the help on how to get ready for the exam, It is perfect 1Z0-117 exam questions!
I am very satisfied with my purchases. Share my news with you.
1Z0-117 practice dumps here are valid. Try them out, you won’t be disappointed. I just passed my exam last week.
Thanks for your good 1Z0-117 exam braindumps! With the help of them, i have achieved my goal-certification and get the best in life.
Thank you so much Actual4Dumps for making my success possible in my 1Z0-117 exam. I could not have done it without your help.
1Z0-117 dump saves my a lot of money. The function is useful. We can do games on free website too.
I found Actual4Dumps Dumps for exam 1Z0-117 as the most effective and exam oriented. They not only increased my knowledge on the certification topics but also made me passed
I passed the 1Z0-117 exam last week with your help. If there are someone looking for a good material to guide your certification exam, this is a good choice.
I bought the 1Z0-117 PDF exam dumps, i was so excited that the questions of the actual test were nearly the same as your Oracle 1Z0-117. Certaily, i got a high score.
Excellent question answers pdf for the 1Z0-117 certification exam. Prepared me well for the exam. Scored 94% in the first attempt. Highly recommend Actual4Dumps to everyone.
My friends passed 1Z0-117 exam with your dumps pdf, so i want to have a try with your dumps, wish me a good luck.
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.