NEW QUESTION 1
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. Oracle Diagnostics Pack for Oracle Databases
• B. Oracle Tuning Pack for Oracle Databases
• C. Oracle Diagnostics and Tuning Pack for Oracle Databases
• D. Oracle ADDM Pack
• E. Nothing else needs to be licensed.

Answer: C

NEW QUESTION 2
For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality?

• A. to test performance after an upgrade to an Oracle Real Application Cluster
• B. to test performance of an Operating System patch
• C. to test effect of new Optimizer statistics
• D. to test performance after a database upgrade
• E. to test performance just after a database reboot

Answer: A

NEW QUESTION 3
When reviewing a customer's database configuration, you find that OPTIMIZER_USE_SQL_PLAN_BASELINES is 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

Answer: B

NEW QUESTION 4
Which is the default statistics gatheringperiod 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

Answer: A

NEW QUESTION 5
When planning Oracle Database Architecture, which option can be used to reduce the number of Oracle processes 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

Answer: D

Explanation:
Reference: http://www.oracle.com/technetwork/database/performance/resource-manager- twp-133705.pdf

NEW QUESTION 6
Which are two kinds of statistics collected and processed by the Automatic Workload Repository (AWR) you would utilize when tuning an Oracle Database instance?

• A. Wait Event statistics
• B. Session and System statistics
• C. User privileges statistics
• D. Standby Database throughput statistics
• E. Interconnect statistics

Answer: AD

Explanation:
Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027

NEW QUESTION 7
Which two are functionalities of Oracle Real Application Testing?

• A. Database Replay
• B. SQL Query Sets (SQS)
• C. SQL Tuning Analyzer
• D. SQL Performance Analyzer (SPA)
• E. Real Application Cluster Replay

Answer: AE

NEW QUESTION 8
Which is a prerequisite for using an Oracle Database Performance and Tuning solution?

• A. Linux Operating system
• B. 8 GB of memory
• C. Oracle Database Enterprise Edition
• D. Oracle Enterprise Manager
• E. deep knowledge of Oracle Storage subsystems

Answer: C

NEW QUESTION 9
Upon migration to Oracle Database 12c, a customer asked that monitoring at an individualdatabase level be disabled in favor of database performance monitoring consolidated and centralized across their enterprise.
Which are two actions you would take to meet the customer's requirements?

• A. Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0.
• B. For the always active Oracle Enterprise Manager Database Express process, create a script that willdisable that process upon database boot.
• C. Using the appropriate architectureimplement Oracle Enterprise Manager.
• D. Delete the “express” directory in Oracle Home to disable Oracle Enterprise Manager Database Express.
• E. Changes permissions of the “express” directory to real only by root.
• F. Enable SNMP and configure MIBS on each databaseand forward database monitoring SNMP traps.

Answer: BE

NEW QUESTION 10
Which option would you use to validate performance when migrating an Oracle Database from HPUX Itanium to Oracle Linux 6 architecture?

• A. Oracle Diagnostic Pack for Database
• B. Real Application Testing
• C. Oracle Migration Pack for Databases
• D. Oracle Migration Performance Advisor
• E. SQL Performance Testing Suite

Answer: C

NEW QUESTION 11
Which is a true statement about the difference in the functionality of Active Session History (ASH) and SQL Trace/TKPROF?

• A. ASH provides time based data, SQL Trace/TKPROF does not
• B. ASH provides detailed session level data, SQL Trace/TKPROF does not
• C. ASH is always on, SQL Trace/TKPROF is not
• D. ASH identifies Bind variables that are available, SQL Trace/TKPROF does not
• E. ASH counts and has occurrence data, SQL Trace/TKPROF does not

Answer: B

NEW QUESTION 12
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 databaseas wellas its individual instances.
• B. Database-wide analysis of global resources by ADDM for high-load SQL, global cache interconnect traffic,and skew in instance response times.
• C. ADDM X$ and V$ performance analysis and reports that compare the overall RAC Database to the sum ofits individual database instances.
• D. ADDM recommendations inclusive of SAN and NFS mounted storage to pinpoint issues within the storagecache.
• E. ADDM's ability to review SNMP trap error messages and automatically open trouble tickets.

Answer: CD

NEW QUESTION 13
Reviewing Automatic Workload Repository (AWR) reports for CPU and I/O exceptions, the
time model displays SQL execution elapsed time as a major component of DB Time. Which two are next steps to diagnose the problem further?

• A. Review Operating System processes for any zombies.
• B. Review SQL statistics from the Automatic Workload Repository (AWR).
• C. Run a STATSPACK report.
• D. Review Automatic Database Diagnostic (ADDM) recommendations.
• E. Review all system configuration parameters.

Answer: CD

NEW QUESTION 14
Select two scenarios that an Oracle Database Performance and Tuning solution implementation addresses.

• A. After migration off a legacy system, an ERP team complains that they have no ability to isolate performanceproblems in the new distributed Oracle Database architecture.
• B. An HR Team claims that it can hire staff fast enough to meet business demands.
• C. Development Team members demand that their SQL should run fast while the DBAs blame SQL as theroot of performance issues.
• D. To prepare for an upcoming code audit, developers need to review their SQL and PL/SQL code for syntaxand runtime errors.
• E. Systems and Storage teams report that over the past 12 month, it is taking 40% longer time to back up theservers with Oracle databaseson them.

Answer: BC

NEW QUESTION 15
Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database. Which would you configure for that to occur?

• A. SetOPTIMIZER_USE_PENDING_STATISTICStoTRUE.
• B. SetAUTO_UPDATE_STATISTICStoFALSE.
• C. Use aHOLD HINTin the SQL.
• D. SetAUTOMATIC_WORKLOAD_REPOSITORY_COLLECTIONtoPAUSE.

Answer: A

NEW QUESTION 16
IT Operations had observed short CPU spikes and I/O storms prior to a retail website outage. Which functionality of Diagnostics Pack for Oracle Databases would you implement to diagnose and resolve the customers issue?

• A. Active Workload History to collect SQL at the time of its execution.
• B. SQL Performance Analyzer to capture the information in the SGA, the sessions active, and analyze theSQL executing.
• C. Oracle Workload Advisor that automatically turns on and captures the offending SQL Statements whenthresholds are reached.
• D. Active Session History to capture sessions and dump the SQL executing, performance attributes andrelevant information into a buffer for analysis.
• E. Active SQL History Analyzer to doperform a comparison of SQL statements before and after.
• F. Oracle Exadata, as it already includes Diagnostic Pack for Oracle Database.

Answer: F

NEW QUESTION 17
Which are two strategies to maintain performance and improve a table segment's compression ratio when you are using Advanced Row Compression on a table segment?

• A. Use smaller database block size.
• B. Use larger database block size.
• C. Use direct-path inserts wherepossible.
• D. IncreasePCTFREEon the table segment.
• E. Increase the size of the tablespace.

Answer: AE

NEW QUESTION 18
At the IT Manager request, you are reviewing the databases that the DBA has implemented. You findSTATISTICS_LEVELconfigured asBASIC. What finding do you report back to the IT Manager?

• A. The configuration of their databases is set up to also provide timed Operating System statistics and planexecution statistics.
• B. The configuration of their databases is incorrect and should be set toNOT_TYPICAL.
• C. The configuration of their databases has disabled collection of important statistics required for OracleDatabase functionality.
• D. The configuration of their databases needs to be set toALLto enable collection of Operating System, Middleware, and storage statistics.

Answer: C

NEW QUESTION 19
For which two capabilities would you implement Segment Advisor in order to aid a customer trying to find and fix performance issues related to database space?

• A. to determine if objects have unusedspace that can be released
• B. to advise if materialized views can be used to reduce size of views
• C. to review space usage of individual schema objects or tablespaces
• D. to advise if there are any duplicate indexes and automate their removal
• E. to identify any fragmentation in the database cache or swap space

Answer: AC

NEW QUESTION 20
Which three are benefits of implementing an Oracle Database Performance and Tuning solution?

• A. automated database diagnostics based on deep database kernel integration
• B. a library of hundreds of PL/SQL procedures to choose from for writing scripts to instrument the database tocollect performance information
• C. monitor and alert on every Oracle Database Database Dictionary view using SNMP MIBS built into theOptimizer
• D. the most extensive and up-to-date collection of database monitoring and tuning scripts
• E. built-in instrumentation, real-time and historical monitoring, and data collection
• F. a performance methodology

Answer: DEF

NEW QUESTION 21
......