Online Access Free 1z1-417 Exam Questions

Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQL objects?

• A.MMNL
• B.DBWR
• C.LGWR
• D.MMON
• E.CKPT

Starting with Oracle Database 11gR2, which are two additional partitioning capabilities that aid Oracle Database Performance and Tuning?

• A.Hash Partitioning
• B.Reference Partitioning
• C.Interval Partitioning
• D.Composite Partitioning
• E.Disk Partitioning

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

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

Which one is a type of user session and client request supported by Database Replay?

• A.XA transactions
• B.Flashback queries
• C.SQL-based object access
• D.Oracle Call Interface (OCI) based object navigations
• E.Database Resident Connection Pooling (DRCP)

When performing performance analysis of Oracle Real Application Cluster (RAC) databases, what are three Automatic Database Diagnostics Monitoring (ADDM) analysis modes that are available?

• A.Instance
• B.Sample
• C.Database
• D.Partial
• E.Average