Free Oracle 1z0-417 Exam Dumps Questions & Answers

Which option would you use to capture workloads from one or more systems concurrently and then play them back?

• A.  Automatic Workload Repository
• B.  Workload Consolidator and Playback
• C.  Consolidation Planner
• D.  Enterprise Manager Cloud Control
• E.  Consolidated Database Replay

Which are two kinds of statistics collected and processed by the Automatic Workload Repository (AWR) you would utilize when tuning an Oracle Database instance?

• A.  Wait Event statistics
• B.  Standby Database throughput statistics
• C.  Interconnect statistics
• D.  User privileges statistics
• E.  Session and System statistics

Which is a capability that Active Session History (ASH) reports enable you to perform?

• A.  Compare database performance between two periods of time, and resolve performance degradation thatmay happen from one time period to another.
• B.  Analyze transient performance problems that have happened in the database since it has been started.
• C.  Optimize the performance of data access paths by creating the proper set of materialized views,materialized view logs, and indexes for a given workload.
• D.  Analyze transient performance problems with the database that are short-lived and do not appear in theADDM analysis.

Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?

• A.  A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set toDIAGNOSTIC +TUNING.
• B.  The customer has Enterprise Manager installed on a separate server and regularly accesses the Databasehome page of some of its Enterprise Edition databases from its console.
• C.  A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt.
• D.  A customer says that he or she doesn't use theEnterprise Manager, but you learn that the customer usescustomized SQL scripts that accessV$SESSIONandV$SQLviews.
• E.  A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer has SQLscripts that access theDBA_HIST_ACTIVE_SESS_HISTORYdatabase view.

When implementing an Oracle Database Performance and Tuning solution, which are three product technologies recommended for use as your base configuration?

• A.  STATSPACK
• B.  SQL Tuning Pack for Oracle Database
• C.  Oracle Performance Pack for Oracle Database
• D.  Oracle Tuning Pack for Oracle Database
• E.  Oracle Real Application Testing
• F.  Oracle Diagnostics Pack for Oracle Database
• G.  Oracle SQL Developer