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

Examine the parallelism parameter for your instance:

parallel_servers_target
Now examine the resource plan containing parallel statement directives:
Consumer Group resource plan containing parallel statement directives:

Which two are true about parallel statement queuing when this plan is active?

• A.A single ETL_GROUP session can consume up to eight parallel execution servers.
• B.A single OTHER_GROUPS session will execute serially once it is queued for six minutes.
• C.A single OTHER_GROUPS session will execute in parallel once it is queued for six minutes.
• D.ETL_GROUP sessions can collectively consume up to 64 parallel execution servers before the queuing starts for this consumer.
• E.A single ETL_GROUP session can consume up to 32 parallel execution servers.
• F.Urgent_group sessions collectively can consume up to 64 parallel execution servers before queuing starts for this consumer group.

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
inserted data. In addition at night, a few DSS queries are also performed. Examine the initialization parameters for the instance:

Which two options would you use for the optimizer?

• A.Add the hint ALL_ROWS in the DOS queries.
• B.Set the OPTIMIZER_INDEX_COST_ADJ initialization parameter to 100.
• C.Set the OPTIMIZER_INDEX_CACHING initialization parameter to 0.
• D.Set the OPTIMIZER_MODE initialization parameter to FIRST_ROWS_n.
• E.Add a hint INDEX_COMBINE in all DSS queries.

Which three options are true about MVIEWs?

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

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

• A.A query executing in parallel on a partitioned table with partitioned indexes.
• B.A query fetching less number of blocks than value specified by DB_FILE_MULTIBLOCK_READ_COUNT.
• C.A highly selective query on a table having high clustering factor for an index.
• D.A query on a table with sparsely populated table blocks.
• E.A query with a highly selective filter fetching less than 5 percent of the rows from a table.

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 contains an accepted plan.
You want to add a new plan automatically as an accepted plan to the existing SQL plan baseline.
Examine the following tasks.
1.Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINE parameter to TRUE.
2.Evolve the new plan.
3.Fix the existing accepted plan.
4.Manually load the new plan.
Identify the task(s) that must be performed to accomplish this.

• A.4 and 3
• B.1, 2, 4, and 3
• C.Only 4
• D.1, 2, and 3
• E.1 and 2
• F.1, 4, and 3