Certification: Oracle Certified Expert, Oracle Database 11g Release 2 SQL Tuning
Certification Full Name: Oracle Certified Expert, Oracle Database 11g Release 2 SQL Tuning
Certification Provider: Oracle
Exam Code: 1z0-117
Exam Name: Oracle Database 11g Release 2: SQL Tuning

Pass Your Oracle Certified Expert, Oracle Database 11g Release 2 SQL Tuning Exam - 100% Money Back Guarantee!

Get Certified Fast With Latest & Updated 1z0-117 Preparation Materials

125 Questions and Answers with Testing Engine
"Oracle Database 11g Release 2: SQL Tuning Exam", also known as 1z0-117 exam, is a Oracle certification exam.

Pass your tests with the always up-to-date 1z0-117 Exam Engine. Your 1z0-117 training materials keep you at the head of the pack!


PDF Version of 1z0-117 Questions & Answers with Explanations

PDF Version

Now you can practice your study skills and test your knowledge anytime and anywhere you happen to be with PDF Version of your 1z0-117 exam.

Questions & Answers with Explanations PDF Version file has an industry standard file format .pdf. You can use any .pdf reader application like Adobe Acrobat Reader or many other readers to view your PDF file.

Printable 1z0-117 Questions & Answers with Explanations PDF Version gives you comfort to read at leasure without using your computer or gadget.

* PDF Version cannot be purchased without the main product (1z0-117 Questions & Answers with Explanations) and is an add on.

Money Back Guarantee

Test-King has a remarkable Oracle Candidate Success record. We're confident of our products and provide a no hassle money back guarantee. That's how confident we are!

Was: $137.49
Now: $124.99

Certification overview

In an industry that is growing at a speed that is almost too fast to be real, the demand for IT workers grows higher and higher with each passing moment. Nevertheless, the competition within the industry is far from being stalemate, but rather rising progressively in time with the demand. Although this may seem dire and undesirable, competition always proves positive for the winning player. There are always ways to be the one that the employer wants and one of the sure-fire ways to ensure an elevated standing amongst your peers is to get certified with Oracle.

Earning the certification of Oracle Certified Expert, Oracle Database 11g Release 2 SQL Tuning can help you bump out the opposition and get you to that finish line first, with your colleagues still running miles behind you! Preparing and sitting the certification exam will give you a level of expertise in a wide area of topics, Like identifying and fine-tuning SQL statements that are inefficient, using SQL tuning that are automatic in nature, Keeping track of statistics on database objects, analyzing queries and implementing partitioning.

Who can do this certification

This certification has been designed for Developer, DBAs, and SQL developers who are apt in tuning efficient SQL statements.


Almost all of the Global Fortune 500 companies currently have Oracle Software in place. During the hiring process, they look to discover employees who they are positive will be able to handle and manipulate these complex technical systems. This is when your Oracle certification becomes your life-saver. Nothing will make you more attractive to your future employer like a guaranteed certification of your expert skills.

According to a recently conducted survey, 87% of those who have been certified by Oracle agree that they have seen a definite increase in their professional credibility. More than 80% believe that they have had opportunities presented to them in their field that they wouldn't have been able to imagine before, and they find they are now equipped to be better in their work, as the road to attain their certification prepared them to deal with complex issues in the most efficient of ways.

Associated Exam

This certification consists of one exam, called the Oracle Database 11g Release 2: SQL Tuning exam, which makes up the 2nd step of the certification path. This exam must be passed before the certification can be attained.


It is recommended that all candidates possess up to date training and field experience before beginning the steps necessary to attain this certification.

Topics Covered: Oracle Database 11g Release 2: SQL Tuning exam

This exam covers 27 topics.

  1. SQL Statement Tuning
  2. Exploring the Oracle Database Architecture
  3. Introduction to SQL Tuning
  4. Introduction to the Optimizer
  5. Interpreting Execution Plans
  6. Application Tracing
  7. Optimizer Operations
  8. Optimizer: Join Operations
  9. Other Optimizer Operations
  10. Case Study: Star Transformation
  11. Optimizer Statistics
  12. Using Bind Variables
  13. SQL Tuning Advisor
  14. Using SQL Access Advisor
  15. Automating SQL Tuning
  16. SQL Plan Management
  17. Using Optimizer Hints
  18. Parallel Queries
  19. Parallel Processing Concepts
  20. Basics of Parallel Execution
  21. Manual DOP Management
  22. Simplified Auto DOP
  23. Statement Queuing
  24. In-Memory Parallel execution
  25. Data Warehouse Administration
  26. Partitioning Concepts
  27. Materialized Views

The exam goes for a duration of 150 minutes (or two and a half hours), with a total of 80 multiple choice questions.

Validity of the Certification

The validity of this certification will remain current right up until the introduction or release of a newer version, at which point the certification will retire and certification holders should presume to upgrade their existing certifications. It is advisable that all candidates recertify periodically as new software is issued so as to ensure that their skills are up-to-date with their tools of the trade.

Steps involved in the certification

Step-wise, this certification two steps 5 steps, which are:

  1. Training: To complete one of the approved courses outlined by the provider's website (recommended but not required).
  2. Exam: Oracle Database 11g Release 2: SQL Tuning Exam

Expert Review

"Certification has helped my career, simply because I have more perspectives, more possibilities, and I'm looked upon by my peers as some who has the knowledge and skills to do the job right."

Sergey Demidenko

"Oracle Certification is an objective assessment of my technical skills and is an asset when I work with my clients who are all very knowledgeable on Oracle technology."

Heather Fewell, Alliant Techsystems Inc
Hefei, China.

Frequently Asked Questions

How can I get the products after purchase?

All products are available for download immediately from your Member's Area. Once you have made the payment, you will be transferred to Member's Area where you can login and download the products you have purchased to your computer.

How long can I use my product? Will it be valid forever?

Test-King products have a validity of 90 days from the date of purchase. This means that any updates to the products, including but not limited to new questions, or updates and changes by our editing team, will be automatically downloaded on to computer to make sure that you get latest exam prep materials during those 90 days.

Can I renew my product if when it's expired?

Yes, when the 90 days of your product validity are over, you have the option of renewing your expired products with a 30% discount. This can be done in your Member's Area.

Please note that you will not be able to use the product after it has expired if you don't renew it.

How often are the questions updated?

We always try to provide the latest pool of questions, Updates in the questions depend on the changes in actual pool of questions by different vendors. As soon as we know about the change in the exam question pool we try our best to update the products as fast as possible.

How many computers I can download Test-King software on?

You can download the Test-King products on the maximum number of 2 (two) computers or devices. If you need to use the software on more than two machines, you can purchase this option separately. Please email support@test-king.com if you need to use more than 5 (five) computers.

What is a PDF Version?

PDF Version is a pdf document of Questions & Answers product. The document file has standart .pdf format, which can be easily read by any pdf reader application like Adobe Acrobat Reader, Foxit Reader, OpenOffice, Google Docs and many others.

Can I purchase PDF Version without the Testing Engine?

PDF Version cannot be purchased separately. It is only available as an add-on to main Question & Answer Testing Engine product.

What operating systems are supported by your Testing Engine software?

Our testing engine is supported by Windows. Andriod and IOS software is currently under development.


Download Free Oracle 1z0-117 Testing Engine Demo

Experience Test-King Oracle 1z0-117 exam Q&A testing engine for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your Oracle 1z0-117 exam.

  • Customizable, interactive testing engine
  • Simulates real exam environment
  • Instant download
Email Address
You will use this to log in to your account
* Our demo shows only a few questions from Oracle 1z0-117 exam for evaluating purposes

Summer Sale! 15% Discount for All Exams!

This is a ONE TIME OFFER. You will never see this Again

Instant Discount
Test-King Testing Engine

15% OFF

Enter Your Email Address to Receive Your 15% OFF Discount Code Plus... Our Exclusive Weekly Deals

A confirmation link will be sent to this email address to verify your login.

* We value your privacy. We will not rent or sell your email address.


Your 15% Discount on Your Purchase

Save 15%. Today on all IT exams. Instant Download

Test-King Testing Engine

Use the following Discount Code during the checkout and get 15% discount on all your purchases:

Start Shopping