Online Access Free 1z0-417 Practice Test

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

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

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.V$ performance views
• B.Materialized views
• C.Indexes
• D.Tablespaces
• E.Partitions
• F.Hints

For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality?

• A.to test performance just after a database reboot
• B.to test performance after an upgrade to an Oracle Real Application Cluster
• C.to test effect of new Optimizer statistics
• D.to test performance after a database upgrade
• E.to test performance of an Operating System patch

Which is the default statistics gatheringperiod for Automatic Database Diagnostics Monitoring (ADDM)?

• A.every 30 minutes
• B.every 24 hoursE. every 40 hours
• C.every 60 minutes
• D.every 30 seconds

Which three are controllable by a resource plan, when you are using the Oracle Database 12c Multitenant option?

• A.concurrent sessions
• B.network I/O
• C.SGA
• D.CPU
• E.use of SGA memory and ability to allocate PGA
• F.ability to use parallel server processes