Free Oracle 1Z0-117 Exam Dumps Questions & Answers

Which three options are true about MVIEWs?

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

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 different services and tracing is enabled for the services. You want to view the detailed tracing setting for particular service.
What would you use to view the tracing information?

• A.Trcsess and tkprof
• B.DBMS_SERVICE package
• C.DBA_ENABLED_TRACES view
• D.DBMS_MONITOR package

---
Your database supports a workload consisting of three categories of SQL statements: Statements that should execute in less than one minute Statement that may execute for up to 15 minutes Statements that may be executed for more than 15 minutes You set PARALLEL_DEGREE_POLICY to Auto.
You plan to prioritize queued statements by using the Database Resource manager.
Which two are true about parallelism prioritization by a consumer group?

• A.Having separate queues for consumer groups requires the use of management attributes (MGMT_P1, MGMT_P2 etc. . . )
• B.Separate queue timeout using PARALLEL_QUEUE_TIMEOUT require the use of management attributes (MGMT_P1, MGMT_P2 etc . . . groups)
• C.PARALLEL_TARGET_PERCENTAGE is used to prioritize a consumer group's use of the overall PARALLEL_SERVER_TARGET.
• D.Queuing is done for a consumer group exceeding its percentage, even if the number of busy PX servers in the instance has not reached PARALLEL_SERVERS_TARGET.
• E.PARALLEL_TARGET_PERCENTAGE us used to prioritize a consumer group's use of the overall SPAN CLASS = 'OracleCode'> PARALLEL_MAX_SERVERS.

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 indexes or materialized views defined on term?

• A.Direct path insert of a million rows into a partitioned, index-organized table containing one million rows.
• B.Direct path insert of a million rows into a nonpartitioned, heap-organized table containing one million rows.
• C.Direct path insert of a million rows into a nonpartitioned, index-organized table containing one million rows.
• D.Direct path insert of a million rows into a nonpartitioned, heap-organized table containing 10 million rows.
• E.Direct path insert of a million rows into a partitioned, index-organized table containing 10 million rows.

Which three are benefits of In-Memory Parallel Execution?

• A.Ability to exploit parallel execution servers on remote instance
• B.Reduction in physical I/O for parallel queries
• C.Reduction in the duplication of block images across multiple buffer caches
• D.Reduction in CPU utilization
• E.Reduction in the number of blocks accessed