1Z0-117 Exam Questions

You need to migrate database from oracle Database 10g to 11g. You want the SQL workload to start the 10g plans in the 11g database instance and evolve better plans. Examine the fol...

A database instance is configured in the shared server mode and it supports multiple applications running on a middle tier. These applications connect to the database using differe...

In which three situations must you collect optimizer statistics manually for database objects in addition to automatic statistics collection?

Examine the query and its execution plan: Which two statements are true regarding the execution plan?

An application frequently executed similar types of queries that vary only in the usage of literals in the WHERE clause. You plan to use bind variable in place of literal values. T...

Examine the execution plan: Which two are true regarding the execution plan?

Which two tasks are performed during the optimization stage of a SQL statement?

Examine the Exhibit1 to view the structure of an indexes for the EMPLOYEES table. Examine the query: SQL> SELECT * FROM employees WHERE employees_id IN (7876, 7900, 7902); EMPLOYEE...

You are administering a database supporting a DDS workload in which some tables are updated frequently but not queried often. You have SQL plan baseline for these tables and you do...

Your database has the OLTP_SRV service configured for an OLTP application running on a middle tier. This service is used to connect to the database by using connection pools. The a...

Which statement is true about an automatic SQL task?

Examine the exhibit. Which two are true concerning the execution plan?

You are working on a database that supports an OLTP workload. You see a large number of hard parses occurring and several almost identical SQL statements in the library cache that...

You are administering a database that supports an OLTP workload. Automatic optimizer statistics collection is scheduled in the night maintenance window. Some of the tables get upda...

Examine the exhibit to view the query and its execution plan. Identify the two correct interpretations that can be made from the execution plan.

You are administering a database that supports a DSS workload, where in an application a set of queries use the query rewrite on materialized views. You notice that these queries a...

You are administering a database that supports an OLTP workload in which one of the applications inserts rows in a table until 12 noon every, after which multiple years perform fre...

Examine the query: The RESULT_CACHE_MODE parameter is set to MANUAL for the database. Which two statements are true about the usage of the result cache?

How can you analyze an existing trace file to list the almost resource-intensive statements, aggregation of statistics, and to either exclude recursive call details?

Which statement is true about the usage of the STAR_TRANSFORMATION hint in a query?

Examine the Exhibit to view the structure of and indexes for the EMPLOYEES and DEPARTMENTS tables: EXAMINE the SQL statement and its execution plan: Which two statements are correc...

Which two statements are true about the use of the DYNAMIC_SAMPLING hint in a query?

Your database supports a workload consisting of three categories of SQL statements: - Statements that should execute in less than one minute - Statement that may execute for up to...

Examine the Exhibit. Given two sets of parallel execution processes, SS1 and SS2, which is true?

See the code fragment: You receive the following error message: ORA-12827: insufficient parallel query slaves available. Which three parameter settings could you change to avoid th...

Examine the parallelism parameters for your instance: Examine the Exhibit to view the query and its explain plan output. All sessions use default parallelism settings. What two ste...

Examine the following command: Which query transformation technique is used by the optimizer in this case?

You identified some DSS queries that perform expensive join and aggregation operations. The queries access historical data from noncurrent partition of the fact tables. What three...

Identify two situations in which full table scans will be faster than index range scans.

You are administering a database, where an application frequently executes identical SQL statements with the same syntax. How will you optimize the query results without retrieving...

Which three options are true about MVIEWs?

Partial details of an execution plan. Which statement correctly describes the BITMAP AND operation?

Which two statements are true about index full scans?

An application supplied by a new vendor is being deployed and the SQL statements have plan baselines provided by the supplier. The plans have been loaded from a SQL tuning set. You...

You recently gathered statistics for a table by using the following commands: You noticed that the performance of queries has degraded after gathering statistics. You want to use t...

View the exhibit and examine the plans in the SQL baseline for a given statement. Which interpretation is correct?

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?

While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for a statement that has stale statistics. Automatic optimizer statistics is enabled for the data...

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?

Examine the Exhibit. Which two statements are true about the bloom filter in the execution plan?

Examine the query and its execution plan: Which statement is true regarding the execution plan?

View the exhibit and examine the query and its execution plan from the PLAN_TABLE, Which statement is true about the execution?

Which four statements are correct about communication between parallel execution process?

You have enabled DML by issuing: ALTER session ENABLE PARALLEL DML; The PARELLEL_DEGREE_POLICY initialization parameter is set to AUTO. Which two options true about DML statements...

Examine Exhibit1 to view the query and its AUTOTRACE output. Which two statements are true about tracing?

Which two types of column filtering may benefit from partition pruning?

Which two statements about In-Memory Parallel Execution are true?

Which two are benefits of In-Memory Parallel Execution?

You plan to bulk load data INSERT INTO . . . SELECT FROM statements. Which two situations benefit from parallel INSERT operations on tables that have no materialized views defined...

Which are the two prerequisites for enabling star transformation on queries?