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

Which two would automatically create an entry inV$SQL_MONITOR?

• A.any DDL statement
• B.any SQL statement run
• C.a statement that consumes at least 1 second of CPU or I/O time.
• D.a parallelized SQL statement
• E.a statement that consumes at least 5 second of CPU or I/O time.
• F.any DML statement

Which two could Oracle Database Replay is used to validate performance?

• A.applying a workload from one database release to another database release
• B.applying workload to an application after an operating system patch
• C.to check and compare if a specific set of SQL statements have regressed between two different databasereleases
• D.moving a workload from a single database instance and applying it to an Oracle Real Application Cluster(RAC)
• E.to find the least-used SQL statement

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

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

• A.SQL Plan Management
• B.Stored Profiles
• C.SQL Profiles
• D.Stored Outlines
• E.SQLHints

For which one would you use an index fast full scan to improve performance?

• A.a query that needs to access table rows along with an index
• B.a query having all the columns of an index in the where clause
• C.a query that does not need to access table rows
• D.a column in an index that is compressed