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

What are two reasons for which the Diagnostics and Tuning packs are essential to ongoing maintenance of an Oracle Database?

• A.Diagnostics and Tuning Packs are needed to keepOracle Database table and index statistics current.
• B.Diagnostics and Tuning packs are a prerequisite for a customer to license Oracle Database EnterpriseEdition.
• C.Inefficient "Bad" application SQL can be detected by Diagnostics Pack and then optimized utilizing TuningPack SQL Profiles, even if it can't be changed at the application end.
• D.Oracle Databases are constantly changing; more users, data added and deleted, varying SQL atapplication level.
• E.With Diagnostics and Tuning Packs installed, an Oracle database recovers easily from a crash orcorruption.

Which one would SQL Access Advisor use as input to provide a recommendation on a partition or index?

• A.Automatic Diagnostic Monitor
• B.SQL Error
• C.Automatic Workload Repository
• D.SQL Tuning Advisor
• E.SQL Tuning Set

What are three reasons an implementation of an Oracle Database Performance and Tuning solution is superior to that of scripts or third-party tools?

• A.It is the most inexpensive tool in the market.
• B.It eliminates the need to reverify compatibility, upgrade third-party tools, or rewrite scripts after a patch ordatabase upgrade.
• C.It has the largest library of custom scripts and procedures and includes an assembly builder to maintainthem and add more.
• D.Results come from the Oracle Database Optimizer and not rules or heuristics trying to predict what theoptimizer may do.
• E.It is a part of the database, which means no added installations, configurations, extra user accounts,privilege granting, etc.

Which is a true statement about Automatic Database Diagnostic Monitor (ADDM)?

• A.APEX is required to access ADDM.
• B.ADDM analyzes information stored in snapshots in tables of the Automatic Workload Repository (AWR).
• C.ADDM and AWR are new features of Oracle Database 12c.
• D.Automatic Workload Repository (AWR) analyzes information stored in snapshots in tables of ADDM.
• E.ADDM analyzes information in RMAN.

Which two statements are true about Oracle Enterprise Manager Database Express?

• A.It uses internal infrastructure components, such as XDB and SQL*NET.
• B.It is not supported on Oracle Standard Edition or Express Edition.
• C.It can perform actions inside and outside the database.
• D.Performance Hub and Composite Active Reports are its key functionalities.
• E.It replaces Oracle Grid Control.