What is the feature and where does it store that data?

An advanced fault diagnostic infrastructure introduced as of Oracle Database 11g, assigns an incidentnumber and diagnostic data when a critical error occurs. What is the feature and where does it store thatdata? A. Oracle Enterprise Manager. Data is stored in the OEM Repository. B. MyOracle Support. Data is stored in Oracle Cloud. C. Automatic Workload […]

Read More

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

Which two could Oracle Database Replay is used to validate performance? A. applying workload to an application after an operating system patch 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. to […]

Read More

Which is the correct response for this scenario?

DBAs use scripts and a third-party tool that access Automatic Workload Repository (AWR) snapshotreports, but don’t use Oracle Enterprise Manager. The IT Manager seeks to confirm what the DBAs told him­ Its OK since they licensed Oracle Database Enterprise Edition and not the Standard Edition. Which is the correct response for this scenario? A. With […]

Read More

Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a

Which background process performs Automatic Workload Repository (AWR) tasks such as writing when ametric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQLobjects? A. LGWR B. DBWR C. CKPT D. MMON E. MMNL Explanation: The manageability monitor process (MMON) performs many tasks related to the AutomaticWorkload Repository (AWR). For example, MMON […]

Read More

Which three configuration parameters are applicable?

When preparing a new database installation, you want to ensure automatic collection of timed statistics.Which three configuration parameters are applicable? A. STATISTICS_LEVEL parameter set to TYPICAL B. STATISTICS_LEVEL parameter set to All C. TIMED_STATISTICS parameter set to true D. ALL_TIMED_STATISTICS parameter set to TRUE E. AUTO_STATS parameter set to TRUE F. STATISTICS_LEVEL parameter set to […]

Read More

When planning Oracle Database Architecture, which option can be used to reduce the number of Oracle

When planning Oracle Database Architecture, which option can be used to reduce the number of Oracleprocesses waiting in the Operating System run queue and to ensure that database CPU load is healthy? A. Exadata B. Oracle Job Scheduler C. DATABASE_MAXCPUS=YES D. Oracle Database Resource Manager E. DB_RAC_MAXCPU=YES F. Oracle Grid Control Explanation: Reference: http://www.oracle.com/technetwork/database/performance/resource-manager-twp-133705.pdf Show […]

Read More