1Z0-117 Exam Questions

You instance has these parameter settings: Which three statements are true about these settings if no hints are used in a SQL statement?

Examine the following SQL statement: Examine the exhibit to view the execution plan. Which statement is true about the execution plan?

Which two types of SQL statements will benefit from dynamic sampling?

Examine the following query and execution plan: Which query transformation technique is used in this scenario?

You enabled auto degree of parallelism (DOP) for your instance. Examine the query: Which two are true about the execution of this query?

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 fo...

Examine the Exhibit to view the structure of an indexes for the SALES table. The SALES table has 4594215 rows. The CUST_ID column has 2079 distinct values. What would you do to inf...

Which three are tasks performed in the hard parse stage of a SQL statement executions?

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. Ex...

Which two are the fastest methods for fetching a single row from a table based on an equality predicate?

An application user complains about statement execution taking longer than usual. You find that the query uses a bind variable in the WHERE clause as follows: You want to view the...

Which statement is true about an SQL plan baselines that are fixed?

Examine the initializing parameters: An index exists on the column used in the WHERE of a query. You execute the query for the first time today and notice that the query is not usi...

You have created some materialized views to improve the performance of several queries. Which four must be true to enable sessions to benefit from improved response time made possi...

View the code sequence: Which three statements are true about the execution of this query?

View the code sequence: Examine the Exhibit to view the execution plan. Which two statements are true about the query execution?

Examine the parallelism parameters for your instance: What are true about the execution of the query?

You execute the following query: Which statement is true about the usage of these hints in the query?

Examine the initialization parameters for a database an OLTP overload. What is the effect of changing the value of the parameter?

You executed the following statements: Which two statements are true about the query execution?

How can you reduce fragmentation of an index without affecting the current transactions that are using the index?

Examine the Following Query and execution plan: Which query transformation technique is used by the optimizer?

Examine the Exhibit and view the structure of an indexes for the EMPLOYEES table. Which two actions might improve the performance of the query?

Examine the parallel parameters for your instance. All parallel execution servers are available and the session use default parallelism settings. In which two cases will the degree...

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 by using diff...

Examine the statements being executed for the first time: Steps followed by a SQL statement during parsing: 1. Search for a similar statement in the shared pool. 2. Search for an i...

You execute the following query for the first time: Examine the SQL statement processing steps: 1. The value of the variable SAL is obtained to run the query. 2. The syntax of the...

You plan to bulk load data using INSERT /*+PARALLEL*/ INTO . . . . SELECT FROM statements. Which four types of operations can execute in parallel on tables that have no bitmapped i...

Which three options are true about parallel queries when PARALLEL_DEGREE_POLICY is set to MANUAL and the session is using the default settings for parallel query, DDL, and DML?

Exhibit A table has three distinct values in its ID column. In the ID column, values 10 and 20 have more than 20000 rows each and value 30 has only five rows. The statistics for th...

See the table below: All parallel execution servers are available and sessions use default settings for parallelism. Which three are true about parallel execution in your instance?

An application issues many expensive join aggregations type queries. Examine the Exhibit to view the queries. Which two could help improve the performance of these SQL statements w...

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 y...

You ran a high load SQL statement that used an index through the SQL Tuning Advisor and accepted its recommendation for SQL profile creation. Subsequently you noticed that there ha...

Auto DOP is enabled for your instance. You execute the following statements: Which three are true about the execution of the join?

Which two statements are true about the trcsess utility?

The following parameter values are set for the instance: OPTIMIZER_CAPTURE_SQL_BASELINE = FALSE OPTIMIZER_USESQL_PLAN_BASELINE = TRUE The SQL plan baseline for a SQL statement cont...

Examine the Exhibit and view the query and its execution plan. Which statement is correct about the parallel executions plan?

Which three statements are true the Automatic Tuning Optimizer (ATO)?

In your database, the CURSOR_SHARING parameter is set to FORCE. A user issues the following SQL statement: Select * from SH.CUSTOMERS where REIGN='NORTH' Which two statements are c...

Examine Exhibit 1 to view the query and its execution plan. Examine Exhibit 2 to view the structure and indexes for the EMPLOYEES and DEPARTMENTS tables. Examine Exhibit 3 to view...

Which four types of column filtering may benefit from partition pruning when accessing tables via partitioned indexes?

You executed the following statement: Which three statements are true about EXPLAIN PLAN?

Which three factors does the estimator depend on for overall cost estimation of a given execution plan?

Examine the parallelism parameters for you instance. Now examine the DSS_PLAN with parallel statement directives: Which two are true about the DSS_PLAN resource manager plan?

Which three statements are true about the usage of optimizer hints?

Which three tasks are performed by the parallel execution coordinator process?

You need to upgrade you Oracle Database 10g to 11g. You want to ensure that the same SQL plans that are currently in use in the 10g database are used in the upgraded database initi...

You are administering a database supporting an OLTP workload where the users perform frequent queries for fetching a new rows as possible, involving join operations on recently ins...

See the table below: All execution servers are currently available and the sessions use defaults for all parallel settings. In which two cases will statements execute in parallel?