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

SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations?

• A.Hints
• B.Materialized views
• C.Tablespaces
• D.Indexes
• E.Partitions
• F.V$ performance views

Which is a prerequisite for using an Oracle Database Performance and Tuning solution?

• A.Linux Operating system
• B.8 GB of memory
• C.deep knowledge of Oracle Storage subsystems
• D.Oracle Database Enterprise Edition
• E.Oracle Enterprise Manager

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

• A.SQL Developer
• B.Grid Control
• C.Database console
• D.SQL Plus
• E.SQL Express

DBAs use scripts and a third-party tool that access Automatic Workload Repository (AWR) snapshot reports, but don't use Oracle Enterprise Manager. The IT Manager seeks to confirm what the DBAs told him - Its OK since they licensed Oracle Database Enterprise Edition and not the Standard Edition. Which is the correct response for this scenario?

• A.No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needtobe licensed for the Advanced Analytic Pack for Oracle Databases.
• B.With an Oracle Enterprise Edition Database license, a customer can use any Oracle option they want, atany of their worldwide locations, without additional licensing.
• C.No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needto be licensed for the Oracle Diagnostic Pack for Oracle Databases.
• D.With an Oracle Database Enterprise Edition license, an Oracle customer can use any Oracle option theywant, at that location, without additional licensing.
• E.With an Oracle Database Enterprise Edition license, an Oracle customer can access AWR snapshots byusing SQL. If you use anything else, then you need an additional license.

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.After a SQL Profile is created, it will then run efficiently for the life of the database.
• B.SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack islicensed.
• C.You need Oracle Database 12c or later to use SQL Profiles.
• D.The SQL Profile rewrites the SQL Statement issued by theapplication so it appears to the Optimizer as aperfectly written SQL statement.
• E.You can have only one SQL Profile active at one time for a single SQL statement.
• F.You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.