Online Access Free 1Z0-117 Practice Test

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 on them?

• A.Direct path insert of a million rows into a partitioned, index-organized table containing one million rows and a conventional B*tree secondary index.
• B.Direct path insert of 10 rows into a partitioned, index-organized table containing one million rows and conventional B* tree secondary index.
• C.Conventional path insert of a million rows into a nonpartitioned, heap-organized containing 10 rows and having a conventional B* tree index.
• D.Direct path insert of 10 rows into a partitioned, index-organized table containing 10 rows and a bitmapped secondary index
• E.Direct path insert of a million rows into a partitioned, index-organized table containing 10 rows and a bitmapped secondary index.
• F.Conventional path insert of 10 rows into a nonpartitioned, heap-organized table one million rows and a bitmapped index.

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

• A.Plan SYS_SQL_bbedc741a57b5fc2 can be used by the optimizer if the cost of the query is less than plan SYS_SQL_PLAN_bbedc741f554c408.
• B.Plan SYS_SQL_PLAN_bbdc741f554c408 will always be used by the optimizer for the query.
• C.A new plan must be evolved using the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function before it can be used.
• D.Plan SYS_SQL_PLAN_bbedc741f554c408 will not be used until it is fixed by using the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function.
• E.A new plan cannot be evolved because SYS_SQL_bbedc41f554c408 is accepted.

In Your Database, The Cursor_Shareing Parameter is set to EXACT. In the Employees table, the data is significantly skewed in the DEPTNO column. The value 10 is found in 97% of rows.
Examine the following command and out put.

Which three statements are correct?

• A.The value for the bind variable will considered by the optimizer to determine the execution plan.
• B.The same execution plan will always be used irrespective of the bind variable value.
• C.The instance collects statistics and based on the pattern of executions creates a histogram on the column containing the bind value.
• D.Bind peeking will take place only for the first execution of the statement and subsequent execution will use the same plan.
• E.The DEPTNO column will become bind aware once histogram statistics are collected.

What are three common reasons for SQL statements to perform poorly?

• A.OPTIMIZER_MODE parameter set to ALL_ROWS for DSS workload
• B.High index clustering factor
• C.Stale or missing optimizer statistics
• D.Full table scans for queries with highly selective filters
• E.Histograms not existing on columns with evenly distributed data

Examine the initialization parameters for a database an OLTP overload.

What is the effect of changing the value of the parameter?

• A.It influenced the optimizer to use bitmap indexes as the estimated cost conversion from bimap is rowed us reduced.
• B.It influences the optimizer to use indexes instead of full table scans as the estimated cost of the using index is reduced.
• C.It influences the optimizer to use full table scans instead of index scans as the estimated cost of full table scan is reduced.
• D.It influences the optimizer to always use the value of the parameter?