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

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.IncreasePCTFREEon the table segment.
• B.Use direct-path inserts wherepossible.
• C.Use smaller database block size.
• D.Use larger database block size.
• E.Increase the size of the tablespace.

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

Which issue can be avoided by configuring the PCTFREE parameter?

• A.table fragmentation, and has been superseded by Automatic Storage Management
• B.keeping a reserve area for backup
• C.sort operations on disk
• D.row chaining and setting it has been superseded by Automatic Segment Space Management
• E.column fragmentation

Oracle databases come with a built-in health monitor to run diagnostic checks on components of the database. Which three capabilities can be used to automate reporting?

• A.historical reports after the Database Diagnostic Repository (DDR) is configured
• B.variety of real-time reports once the Business Intelligence option is installed
• C.reports examining user and developer SQL programming errors
• D.reports examining memory and process usage
• E.reports in response to critical errors
• F.reports with findings and recommendations to resolve problems

An Oracle Database customer's VP of Development mentions that they've moved to AGILE development methodology and DevOps requires an ability to view, test, or validate performance in their own development environment. Which two do you implement?

• A.Oracle Application Testing Suite
• B.Oracle Testing Pack
• C.SQL Developer
• D.APEX and SQL Developer
• E.Oracle Application Infrastructure Tester
• F.Oracle Real Application Testing