Online Access Free 1z1-417 Practice Test

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.CKPT
• B.DBWR
• C.MMON
• D.MMNL
• E.LGWR

To use Automatic Database Diagnostic Management capability on a database using a SQL script, command line, database views, or from a GUI, which option needs to be licensed?

• A.Nothing else needs to be licensed.
• B.Oracle Tuning Pack for Oracle Databases
• C.Oracle Diagnostics and Tuning Pack for Oracle Databases
• D.Oracle Diagnostics Pack for Oracle Databases
• E.Oracle ADDM Pack

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.CPU
• D.ability to use parallel server processes
• E.SGA
• F.use of SGA memory and ability to allocate PGA

As of Oracle Database 12c, which functionality to access database diagnostic and performance has been superseded by Oracle Enterprise Manager Database Express?

• A.Database console
• B.SQL Developer
• C.SQL Express
• D.SQL Plus
• E.Grid Control

Identify four problems automatically diagnosed by Automatic Database Diagnostics Monitor (ADDM).

• A.log file problematic naming
• B.log buffer sizing
• C.undersized SGA or PGA
• D.log file sizing
• E.Mean Time to recover (MTTR) setting
• F.oversized SGA or PGA
• G.Less Time to recover (LTTR) setting