2018 Jan Oracle Official New Released 1z0-417
100% Free Download! 100% Pass Guaranteed!

Database Performance and Tuning Essentials 2015

Question No: 41

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

  1. log file sizing

  2. log buffer sizing

  3. log file problematic naming

  4. Mean Time to recover (MTTR) setting

  5. undersized SGA or PGA

  6. oversized SGA or PGA

  7. Less Time to recover (LTTR) setting

Answer: D,E,F,G

Question No: 42

When implementing an Oracle Database Performance and Tuning solution, which are three product technologies recommended for use as your base configuration?

  1. SQL Tuning Pack for Oracle Database

  2. Oracle Tuning Pack for Oracle Database

  3. Oracle Performance Pack for Oracle Database

  4. Oracle Diagnostics Pack for Oracle Database

  5. Oracle Real Application Testing

  6. Oracle SQL Developer


Answer: B,D,E

Reference: tuning-study-guide2138991.pdf (See page #03, Application product technology subject areas include).

Question No: 43

Which is a feature of an Oracle Database Performance and Tuning implemented solution?

  1. a Documented Set of X$ and V$ Query Scripts

  2. a Maximum Availability Architecture

  3. a Documented Performance Methodology

  4. capability to Cloud Burst

  5. a Documented Performance Response Method

Answer: B

Question No: 44

Which option would you use to capture workloads from one or more systems concurrently and then play them back?

  1. Automatic Workload Repository

  2. Enterprise Manager Cloud Control

  3. Consolidated Database Replay

  4. Consolidation Planner

  5. Workload Consolidator and Playback

Answer: C

Question No: 45

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

  1. erratic or inconsistent database performance

  2. declining database responsiveness

  3. unlimited I/O

  4. fragmented database tables

  5. database registry errors

  6. database replication

Answer: C,D,F

Question No: 46

Which statement about Oracle Enterprise Manager Database Expressis correct?

  1. Oracle Enterprise Manager Database Control must be configured first.

  2. The listener needs to be running for it to be accessed.

  3. A Oracle Enterprise Manager Database Express WebLogic Server must be configured first.

  4. Oracle Internet Application Server needs to be installed to use it.

  5. Oracle Enterprise Manager Database Express can be used only from a command-line.

Answer: A

Reference: ed/ gettingstarted.htm

Question No: 47

Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?

  1. The customer has Enterprise Manager installed on a separate server and regularly accesses the Databasehome page of some of its Enterprise Edition databases from its console.

  2. A customer says that he or she doesn#39;t use Enterprise Manager, but you learn that the customer routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt.

  3. A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set toDIAGNOSTIC TUNING.

  4. A customer says that he or she doesn#39;t use Enterprise Manager, but you learn that the customer has SQLscripts that access theDBA_HIST_ACTIVE_SESS_HISTORYdatabase view.

  5. A customer says that he or she doesn#39;t use theEnterprise Manager, but you learn that the customer usescustomized SQL scripts that accessV$SESSIONandV$SQLviews.

Answer: C,D

Question No: 48

In which two formats does Automatic Workload Repository (AWR) provide statistics?

  1. Persistent

  2. Temporary

  3. Unlimited

  4. Basic

  5. Full

Answer: A,B

Reference: repositpry-awrperformance-monitoring-tool-basics/

Question No: 49

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?

  1. variety of real-time reports once the Business Intelligence option is installed

  2. reports in response to critical errors

  3. reports with findings and recommendations to resolve problems

  4. reports examining memory and process usage

  5. historical reports after the Database Diagnostic Repository (DDR) is configured

  6. reports examining user and developer SQL programming errors

Answer: B,E,F

Question No: 50

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

  1. Linux Operating system

  2. 8 GB of memory

  3. Oracle Database Enterprise Edition

  4. Oracle Enterprise Manager

  5. deep knowledge of Oracle Storage subsystems

Answer: C

100% Free Download!
Download Free Demo:1z0-417 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-417 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE

Comments are closed.