1Z0-117 試験問題を無料オンラインアクセス

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 data blocks from the storage?

• A.By ensuring that RESULT_CACHE_MODE parameter is set to MANUAL and using the RESULT_CACHE hint in the queries.
• B.By using the bind variables and setting the CURSOR_SHARING parameter to EXACT.
• C.By creating a SQL plan baseline for the identical statements.
• D.By using the CACHE hint to pin the queries in the library cache
• E.By setting the CURSOR_SHARING parameter to FORCE.

Which two statements are true about index full scans?

• A.An index fast full scan reads the whole index from the lowest value to the higher value.
• B.An index fast full scan reads the index block by block.
• C.An index fast full scan multi block I/O to read the index structure in its entirely.
• D.Index nodes are not retrieved in the index order, and there fore the nodes are not in sequence.

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

• A.It investigates the effect of new or modified indexes on the access paths for a workload and recommends running that statistics through the SQL Access Advisor.
• B.It identifies the syntactic, semantic, or design problems with structure of SQL statements leading to poor performance and suggests restricting the statements.
• C.It picks up resource-intensive SQL statements from the ADDM and recommends the use of materialized views to improve query performance.
• D.It identifies the objects with stale or missing statistics and gathers statistics automatically.
• E.It recommends a SQL profile to help create a better execution plan.
• F.It identifies resource-intensive SQL statements, runs them through the SQL Tuning Advisor, and implements the recommendations automatically.

Which three options are true about MVIEWs?

• A.All MVIEWS may be configured to support "refresh on demand".
• B.The defining query of an MVIEWs may be based on a populated table.
• C.All MVIEWs may be configured to support "refresh on commit"
• D.The defining query of an MVIEW may be based on non_partitioned table.
• E.Queries that are rewritten to an MVIEW will never obtain results from the result cache.

Examine the exhibit to view the query and its execution plan.

Identify the two correct interpretations that can be made from the execution plan.

• A.The DEPT table is driving table and the EMP table join is the driven table.
• B.The rows from the DEPT table are sorted first by the join key and then hashed into memory.
• C.The EMP table is the driving table and the DEPT table us the driven table.
• D.Rows from the DEPT table are first hashed by the join key into memory and then joined to the EMP table on the join key.
• E.Rows from both the tables are sorted by the join key, but only rows from the DEPT table are hashed into memory.