For which one would you use an index fast full scan to improve performance? A. a query having all the columns of an index in the where clause B. a query that does not need to access table rows C.…

Oracle databases come with a built-in health monitor to run diagnostic checks on components of the database. Which three capabilities can be used to automate reporting? A. variety of real-time reports once the Business Intelligence option is installed B. reports…

Which is a true statement about Automatic Database Diagnostic Monitor (ADDM)? A. ADDM analyzes information in RMAN. B. Automatic Workload Repository (AWR) analyzes information stored in snapshots in tables of ADDM. C. ADDM analyzes information stored in snapshots in tables…

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

Which are three use cases in which SQL Performance Analyzer can be used? A. find and flashback explain plan anomalies B. simulate Exadata on existing hardware C. forecast impact of a system change on a SQL workload D. compare performance…

An Oracle Database customer’s VP of Development mentions that they’ve moved to AGILE development methodology and DevOps requires an ability to view, test, or validate performance in their own development environment. Which two do you implement? A. Oracle Application Infrastructure…

To isolate performance problem in an Oracle real Application Cluster, for which two abilities would you implement Oracle Diagnostics Pack for Oracle Databases? A. Cluster-wide performance analysis and reports with ADDM on issues that affect an entire database as well…

Which is the default statistics gathering period for Automatic Database Diagnostics Monitoring (ADDM)? A. every 30 seconds B. every 60 minutes C. every 30 minutes D. every 24 hours E. every 40 hours E. every 40 hours

Which three are SQL Performance Analyzer capabilities that enable forecasting impact of system changes on a SQL workload? A. measuring performance before and after the change B. generating a list of SQL Hints that the Optimizer will use to improve…

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. Composite Partitioning D. Interval Partitioning E. Disk Partitioning