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 with the database that are short-lived and do not appear in theADDM analysis.

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 that have happened in the database since it has been started.

What are three activities an Oracle Database Performance and Tuning solution enables a customer to perform?

A. standardize database troubleshooting and diagnostics

B. control database clouds.

C. automate database performance management

D. perform global database backup

E. outsource database operations

F. replay and test actual workloads to assure database performance and consolidatios.

Which are three practices that developers can use to enhance performance, scalability, and availability of Oracle Database-driven applications?

A. Implement primary and foreign keys, enforce database integrity, joins, message queuing, maintenance ofsequencesoutside of the database.

B. Use Big Data to hold everything into one big table.

C. Maintain and analyze performance statistics using AWR and ADDM.

D. Eliminate hot spots in applications, monitor, measure, and optimize SQL statement execution.

E. Perform testing with Real Application Testing.

Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another?

A. SQLHints

B. Stored Outlines

C. Stored Profiles

D. SQL Plan Management

E. SQL Profiles

You are reviewing an Automatic Database Diagnostic Monitor report. What is DB Time% a percentage of?

A. total CPU time

B. elapsed response time

C. total time in database calls by all processes

D. total time in V$ views

E. time that users wait for the database to respond

When reviewing a customer's database configuration, you find thatOPTIMIZER_USE_SQL_PLAN_BASELINESis set asTRUE. What does the Optimizer do?

A. compares plans that itdevelops with accepted plans in baselines

B. develops plans and adds them to baselines as verified

C. doesn't develop an execution plan, but uses an accepted plan from baselines

D. doesn't develop an execution plan, but uses enabled plans in the baseline

Which are two characteristics of "invisible" index functionality that would help tune a database having thousands of legacy indexes?

A. An invisible index is ignored by the optimizer.

B. After an index becomes invisible, it is no longer maintained during insertsand updates.

C. I/O bottlenecks are easy to spot when invisible indexes are used.

D. An index only needs to be rebuilt for it to be visible again.

E. The session or system parameter needs to be changed toOPTIMIZER_USE_INVISIBLE_INDEXEStoTRUEfor an invisible index to become visible to the Optimizer.

Which three issues can be addressed with an Oracle Database Performance and Tuning solution?

A. erratic or inconsistent database performance

B. declining database responsiveness

C. unlimited I/O

D. fragmented database tables

E. database registry errors

F. database replication

Which two statements are true about Automatic Statistics collection by the Optimizer?

A. Statistics are collected during automatic maintenance tasks.

B. Any fixed objects are disregarded.

C. Any external tables are incorporated.

D. All tables in the data dictionary are included by defaults.

E. Statistics are gathered after table statistics are marked stale.

Which issue can be avoided by configuring the PCTFREE parameter?

A. row chaining and setting it has been superseded by Automatic Segment Space Management

B. table fragmentation, and has been superseded by Automatic Storage Management

C. column fragmentation

D. sort operations on disk

E. keeping a reserve area for backup