Online Access Free 1Z0-117 Exam Questions

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

• A.Greater than operators on hash-partitioned tables
• B.In-list operators on system-partitioned tables
• C.Equally operates on range-partitioned tables.
• D.Operators on range-partitioned tables
• E.Equality operators on system-partitioned tables

You are administering database that supports an OLTP workloads. Most of the queries use an index range scan or index unique scan as access methods.
Which three scenarios can prevent the index access being used by the queries?

• A.When highly selective filters is applied on an indexed column of a table with sparsely populated blocks.
• B.When the histogram statistics are not collected for the columns used in where clause.
• C.When the statistics for the table are not current.
• D.When a highly selective filter is applied on the indexed column and the index has very low value for clustering factor.
• E.When the rows are filtered with an IS NULL operator on the column with a unique key defined

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 steps could you take to make the query execute in parallel?

• A.Decrease the value of PARALLEL_MIN_PERCENT.
• B.Decrease the value of PARALLEL_MIN_TIMETHRESHOLD.
• C.Add a parallel hint.
• D.Increase the value of PARALLEL_MAX_SERVERS.
• E.Increase the value of PARALLEL_MIN_SERVERS.

You enable auto degree of parallelism (DOP) for your database instance. Examine the following query:

Which two are true about the execution of statement?

• A.The statement will be queued if the number of busy parallel execution servers exceeds PARALLEL_SERVERS_TARGET.
• B.Auto DOP is used to determine the statement DOP only if the estimated serial execution time exceeds PARALLEL_MIN_TIME_THRESHOLD.
• C.The statement will be queued if insufficient parallel execution slaves are available to satisfy the statements DOP.
• D.Dictionary DOP for the objects accessed by the query is used to determine the statement DOP.
• E.The statements may execute serially.
• F.Dictionary DOP is used to determine the statement DOP only if the estimated serial execution time exceeds PARALLEL_MIN_TIME_THRESHOLD.

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

• A.In-List operates on Range-Partitioned Indexes
• B.Equality operates on Hash-Partitioned Indexes
• C.Not Equal operates on a Global Hash-Partitioned Indexes
• D.Equality operates on Range-Partitioned Indexes
• E.Not Equal operates on a local Hash-Partitioned Indexes
• F.Equality operates on System-Partitioned Tables
• G.Equality operates on List-Partitioned Indexes