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

質問 1

To isolate performance problem in an Oracle real Application Cluster, for which two abilities would you implement Oracle Diagnostics Pack for Oracle Databases?

（A）ADDM X$ and V$ performance analysis and reports that compare the overall RAC Database to the sum ofits individual database instances.

（B）ADDM recommendations inclusive of SAN and NFS mounted storage to pinpoint issues within the storagecache.

（C）Database-wide analysis of global resources by ADDM for high-load SQL, global cache interconnect traffic,and skew in instance response times.

（D）Cluster-wide performance analysis and reports with ADDM on issues that affect an entire databaseas wellas its individual instances.

（E）ADDM's ability to review SNMP trap error messages and automatically open trouble tickets.

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

質問 2

For which two capabilities would you implement Segment Advisor in order to aid a customer trying to find and fix performance issues related to database space?

（A）to review space usage of individual schema objects or tablespaces

（B）to determine if objects have unusedspace that can be released

（C）to advise if there are any duplicate indexes and automate their removal

（D）to advise if materialized views can be used to reduce size of views

（E）to identify any fragmentation in the database cache or swap space

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

質問 3

When planning an Oracle Database architecture, which are three caching functionalities that would improve application response time and speed up query processing?

（A）Oracle In-Memory Database Cache

（B）Mega Cache

（C）Oracle In-Memory DBSTATS Cache

（D）Result Cache

（E）Database Smart Flash Cache

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

質問 4

Which four use cases could Database Replay be used to test for database performance changes?

（A）check a workload after database parameters have been changed

（B）a change in operating system versions

（C）upgrade an application

（D）check a workload from a single instance on an Oracle RAC database

（E）compare Flashback workload

（F）check a workload from one database release on another database released

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

質問 5

Which is Oracle's architecture and methodology for Oracle Database High Availability (HA)?

（A）Oracle Exadata

（B）Oracle Real Application Clusters

（C）Maximum Availability Architecture for Oracle Database

（D）High Availability High Accessibility Architecture for Oracle Database

（E）Oracle Database 12c

正解：B 解答を投票する

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

質問 6

When managing multiple database instances on a single server, which initialization parameter limits the number of CPU's that an instance can use simultaneously?

（A）NUM_CPU

（B）CPU_NUM

（C）MAX_CPU

（D）LIMIT_CPU

（E）CPU_COUNT

正解：E 解答を投票する

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

質問 7

What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?

（A）The SQL Profile rewrites the SQL Statement issued by theapplication so it appears to the Optimizer as aperfectly written SQL statement.

（B）You need Oracle Database 12c or later to use SQL Profiles.

（C）You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.

（D）You can have only one SQL Profile active at one time for a single SQL statement.

（E）After a SQL Profile is created, it will then run efficiently for the life of the database.

（F）SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack islicensed.

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

質問 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 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験