1z0-417無料問題集「Oracle Database Performance and Tuning Essentials 2015」

質問 1

Upon migration to Oracle Database 12c, a customer asked that monitoring at an individualdatabase level be disabled in favor of database performance monitoring consolidated and centralized across their enterprise.
Which are two actions you would take to meet the customer's requirements?

（A）Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0.

（B）Changes permissions of the "express" directory to real only by root.

（C）Enable SNMP and configure MIBS on each databaseand forward database monitoring SNMP traps.

（D）For the always active Oracle Enterprise Manager Database Express process, create a script that willdisable that process upon database boot.

（E）Using the appropriate architectureimplement Oracle Enterprise Manager.

（F）Delete the "express" directory in Oracle Home to disable Oracle Enterprise Manager Database Express.

正解：B、D 解答を投票する

質問 2

Which three are benefits of implementing an Oracle Database Performance and Tuning solution?

（A）a performance methodology

（B）the most extensive and up-to-date collection of database monitoring and tuning scripts

（C）monitor and alert on every Oracle Database Database Dictionary view using SNMP MIBS built into theOptimizer

（D）automated database diagnostics based on deep database kernel integration

（E）a library of hundreds of PL/SQL procedures to choose from for writing scripts to instrument the database tocollect performance information

（F）built-in instrumentation, real-time and historical monitoring, and data collection

正解：A、B、F 解答を投票する

質問 3

Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another?

（A）SQL Profiles

（B）Stored Outlines

（C）Stored Profiles

（D）SQLHints

（E）SQL Plan Management

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

Which are two strategies to maintain performance and improve a table segment's compression ratio when you are using Advanced Row Compression on a table segment?

（A）Use direct-path inserts wherepossible.

（B）IncreasePCTFREEon the table segment.

（C）Use larger database block size.

（D）Use smaller database block size.

（E）Increase the size of the tablespace.

正解：D、E 解答を投票する

質問 5

Which are three use cases in which SQL Performance Analyzer can be used?

（A）simulate Exadata on existing hardware

（B）JSQL Heap Memory overflow testing

（C）debug SQL code syntax before and after a change

（D）forecast impact of a system change on aSQL workload

（E）compare performance of SQL statements before and after a change

（F）find and flashback explain plan anomalies

正解：A、C、D 解答を投票する

質問 6

Which three are controllable by a resource plan, when you are using the Oracle Database 12c Multitenant option?

（A）use of SGA memory and ability to allocate PGA

（B）network I/O

（C）concurrent sessions

（D）SGA

（E）ability to use parallel server processes

（F）CPU

正解：C、E、F 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

As of Oracle Database 12c, which functionality to access database diagnostic and performance has been superseded by Oracle Enterprise Manager Database Express?

（A）Database console

（B）SQL Express

（C）SQL Developer

（D）SQL Plus

（E）Grid Control

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 8

You need to limit the resources available to each Pluggable Database (PDB) within a Container Database (CDB). Utilizing Resource Manager, which are three options that can be managed by a resource plan?

（A）number of tables or indexes

（B）memory

（C）CPU

（D）number of indexes

（E）Parallel Execution Servers

（F）number of users

（G）shares of systemresources

正解：C、E、G 解答を投票する

質問 9

Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQL objects?

（A）LGWR

（B）CKPT

（C）MMON

（D）DBWR

（E）MMNL

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

1z0-417 無料問題集「Oracle Database Performance and Tuning Essentials 2015」

弊社を連絡する

関連リンク

トップ試験