Training a whole team for certification? The PDF version doubles as teaching material — printable for classroom-style review and internal sessions. PracticeVCE supports that scenario with 125 verified practice questions for the 1Z0-117 exam.
Oracle 1Z0-117 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g Release 2: SQL Tuning Exam |
| Exam Number: | 1Z0-117 |
| Passing Score: | 61% |
| Certificate Validity Period: | Valid until Oracle retires the exam; typically 2-3 years after discontinuation |
| Available Languages: | English |
| Exam Format: | Multiple Answer, Multiple Choice |
| Exam Duration: | 150 minutes |
| Exam Price: | USD 245 |
| Related Certifications: | Oracle Database 12c Administrator Certified Professional Oracle Database 11g Administrator Certified Professional |
| Real Exam Qty: | 75-80 |
| Recommended Training: | Oracle SQL Tuning for Developers Workshop Oracle Database 11g: SQL Tuning Workshop |
| Exam Registration: | Oracle Certification Portal Pearson VUE Registration |
| Sample Questions: | DOWNLOAD DEMO |
| 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 1Z0-117 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Star Transformation | 5% | - Star schema and query transformation |
| Introduction to the Optimizer | 10% | - Optimizer modes and behavior control - SQL execution process |
| Bind Variables | 7% | - Bind peeking and adaptive cursor sharing - Benefits of bind variables |
| Introduction to SQL Tuning | 8% | - Causes of poor SQL performance - SQL tuning methodology and tools |
| Optimizer Statistics | 12% | - Managing and modifying statistics - Gathering database and system statistics - Setting preferences and using dynamic sampling |
| Optimizer Hints | 5% | - Using hints appropriately - Limitations and risks of hints |
| SQL Access Advisor | 5% | - Recommending indexes, materialized views |
| Interpreting Execution Plans | 12% | - Reading and interpreting plan details - Generating and displaying execution plans |
| Application Tracing | 6% | - Configuring SQL Trace - Using trcsess and tkprof utilities |
| SQL Plan Management | 6% | - Configuring and managing SQL plan baselines - Controlling plan evolution |
| SQL Tuning Advisor | 8% | - Profiling SQL statements - Running and interpreting tuning recommendations |
| Automated SQL Tuning | 4% | - Automatic SQL Tuning task |
| Optimizer Access and Join Operations | 12% | - Join types, methods and order - Other operations: sorts, filters, result cache - Access paths for tables and indexes |
| Parallel Execution | 8% | - Parallel processing concepts - Configuring and tuning parallel queries |
1Z0-117 Exam FAQ
None that matter: downloads are unlimited and there is no meter on usage time, so you can reinstall the engine and practice with the 1Z0-117 questions as often as you need. The software runs on Windows with a standard Java environment and simulates the real exam scenario session after session.
The Oracle Database 11g Release 2: SQL Tuning exam contains 75-80 questions, and you will have 150 minutes minutes to complete them. Unlimited practice sessions are what make this pacing feel natural by exam day.
This package includes 125 practice questions for the Oracle Database 11g Release 2: SQL Tuning exam. Every answer is verified by an experienced team of experts, so you can trust what you study.
You can register for the Oracle Database 11g Release 2: SQL Tuning exam through the official channels:
Recommended: OCP-level knowledge of Oracle Database 11g, SQL development, or database administration experience; no mandatory prerequisites
You can confirm the current eligibility requirements on the official 1Z0-117 exam page before you register.
Many candidates combine practice questions with official training. Recommended options include:
The Oracle Database 11g Release 2: SQL Tuning exam requires a score of 61% to pass, and the official registration fee is USD 245. Budgeting for both the fee and solid preparation avoids paying twice.
Yes. The PDF version works well as training and teaching material: print it for classroom sessions, share it across a certification study group, or use it as handout content during internal courses. Many company buyers choose this version for exactly that purpose, and printing is unlimited.
The Oracle Database 11g Release 2: SQL Tuning practice questions are organized around the official exam objectives. Key topics include:
- SQL Access Advisor (5%)
- Introduction to the Optimizer (10%)
- SQL Tuning Advisor (8%)
Team training sessions can follow this topic list to keep everyone on the same page.
Oracle Database 11g Release 2: SQL Tuning Sample Questions:
Which three options are true about MVIEWs?
- A. All MVIEWs may be configured to support "refresh on commit"
- B. All MVIEWS may be configured to support "refresh on demand".
- C. The defining query of an MVIEW may be based on non_partitioned table.
- D. The defining query of an MVIEWs may be based on a populated table.
- E. Queries that are rewritten to an MVIEW will never obtain results from the result cache.
Correct Answer: B,D,E 🗳️
Explanation: Only visible for PracticeVCE members. You can sign-up / login (it's free).
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. 4, 5, 3, 7, 6
- C. 3, 5, 4, 7, 6
- D. 3, 4, 5, 7, 6
Correct Answer: B 🗳️
You are logged in as the HR user and you execute the following procedure:
SQL > exec DBMS_STATS.SET_TABLE_PREFS ('HR', 'EMPLOYEES', 'PUBLISH', 'FALSE');
SQL> exec DBMS_STATS.GATHER_TABLE_STATS ('HR', 'EMPLOYEES');
Which statement is true about the newly gathered statistics?
- A. They are locked and cannot be overwritten.
- B. They are used by the optimizer for all sessions.
- C. They are marked as pending and stored in the pending statistics table.
- D. They are temporary and purged when the session exits.
Correct Answer: C 🗳️
Explanation: Only visible for PracticeVCE members. You can sign-up / login (it's free).
You want to run SQL Tuning Advisor statements that are not captured by ADDM, AWR, and are not in the library cache.
What is the prerequisite?
- A. Create a SQL plan baseline for each query
- B. Gather statistics for objects used in the application
- C. Create a SQL Tuning Set (STS) containing the SQL statements
- D. Enable SQL plan management
Correct Answer: C 🗳️
Explanation: Only visible for PracticeVCE members. You can sign-up / login (it's free).
You instance has these parameter settings:
Which three statements are true about these settings if no hints are used in a SQL statement?
- A. A statement with any computed degree of parallelism will be queued if the number of busy parallel execution processes exceeds 64.
- B. A statement that executes for more than 10 seconds always has its degree of parallelism computed automatically.
- C. A statement with a computed degree of parallelism of 20 will be queued if the number of available parallel execution processes is less 5.
- D. A statement with a computed degree of parallelism greater than 8 will be queued for a maximum of 10 seconds.
- E. A statement estimated for more than 10 seconds always has its degree of parallelism computed automatically.
- F. A statement with a computed degree of parallelism greater than 8 will raise an error.
Correct Answer: A,B,C 🗳️
Explanation: Only visible for PracticeVCE members. You can sign-up / login (it's free).
Viewing page 1 out of 25 pages.
Viewing questions 1-5 out of 125 questions.
993 Customer Reviews
