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

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.LIMIT_CPU
• C.CPU_COUNT
• D.MAX_CPU
• E.CPU_NUM

Which option would you use to validate performance when migrating an Oracle Database from HPUX Itanium to Oracle Linux 6 architecture?

• A.Oracle Migration Performance Advisor
• B.Oracle Diagnostic Pack for Database
• C.Oracle Migration Pack for Databases
• D.Real Application Testing
• E.SQL Performance Testing Suite

IT Operations had observed short CPU spikes and I/O storms prior to a retail website outage. Which functionality of Diagnostics Pack for Oracle Databases would you implement to diagnose and resolve the customers issue?

• A.SQL Performance Analyzer to capture the information in the SGA, the sessions active, and analyze theSQL executing.
• B.Active SQL History Analyzer to doperform a comparison of SQL statements before and after.
• C.Active Session History to capture sessions and dump the SQL executing, performance attributes andrelevant information into a buffer for analysis.
• D.Oracle Workload Advisor that automatically turns on and captures the offending SQL Statements whenthresholds are reached.
• E.Oracle Exadata, as it already includes Diagnostic Pack for Oracle Database.
• F.Active Workload History to collect SQL at the time of its execution.

A customer asked you about Database Time (DB Time). Which are two correct statements you would include in your description of it?

• A.It is the overall response time.
• B.It is the total time spent in database calls by all sessions in the database.
• C.It includes login, idle, background, and Zombie session wait time.
• D.It is the total time spent in database calls by foreground sessions in the database.
• E.It includes non-idle wait time.
• F.It is the total time spent in database calls by background sessions in the database.

Which option do customers need to license in order to implement SQL Performance Analyzer and Database Replay functionalities?

• A.Oracle Database Replay and Testing Suite
• B.Oracle Database Diagnostics Pack for Oracle Database
• C.Oracle SQL Tuning Pack for Oracle Database
• D.Oracle SQL Developer
• E.Oracle Real Application Testing