Oracle Database Performance and Tuning Essentials 2015 (1z0-417) Free Practice Test

Question 1

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

A. erratic or inconsistent database performance

B. fragmented database tables

C. unlimited I/O

D. database replication

E. database registry errors

F. declining database responsiveness

Correct Answer: B,C,D

Question 2

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. reports examining user and developer SQL programming errors

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

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

D. reports in response to critical errors

E. reports with findings and recommendations to resolve problems

F. reports examining memory and process usage

Correct Answer: A,C,D

Question 3

Which is Oracle's architecture and methodology for Oracle Database High Availability (HA)?

A. Oracle Database 12c

B. High Availability High Accessibility Architecture for Oracle Database

C. Oracle Real Application Clusters

D. Oracle Exadata

E. Maximum Availability Architecture for Oracle Database

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

You need to load SQL statements from a time period of optimal performance to compare against a time period that performance was reported as poor. Which functionality would you use to accomplish that task?

A. Database Replay

B. SQL Tuning Sets

C. Dynamic Baseline Advisor

D. Optimizer Statistics Comparator

E. Automatic Workload Repository Baselines

Correct Answer: B

Question 5

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

A. total CPU time

B. total time in V$ views

C. time that users wait for the database to respond

D. total time in database calls by all processes

E. elapsed response time

Correct Answer: D

Question 6

Which two statements are true about Oracle Enterprise Manager Database Express?

A. It replaces Oracle Grid Control.

B. It uses internal infrastructure components, such as XDB and SQL*NET.

C. It is not supported on Oracle Standard Edition or Express Edition.

D. It can perform actions inside and outside the database.

E. Performance Hub and Composite Active Reports are its key functionalities.

Correct Answer: B,E

Question 7

A customer has database performance issues within their Oracle Real Application Cluster. What is the next step?

A. Turnoff RAC interconnects to isolate any network issues impacting database performance problems.

B. Run the V$RAC script to dump all the RAC statistics and look for what has the highest metric accumulation.

C. Use the application load testing utility to overload a copy of their application in development to flush out theissue.

D. Use a third-party RAC tool to identify the bad SQL and then rewrite it.

E. Utilize the Oracle Database Performance Method to help identify and correct issue.

Correct Answer: E

Question 8

Which statement is true about implementation of an Oracle Database Performance and Tuning solution?

A. It builds on capabilities built into Oracle databases.

B. It is applicable for Oracle Database 12c and later versions.

C. It is available for Oracle Database Standard and Enterprise Editions.

D. It is recommended for Production environments, but not for Development or QA.

E. It is delivered with Oracle Engineered Systems.

Correct Answer: E

Question 9

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. Oracle Database Resource Manager

B. DATABASE_MAXCPUS=YES

C. Exadata

D. Oracle Job Scheduler

E. Oracle Grid Control

F. DB_RAC_MAXCPU=YES

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Database Performance and Tuning Essentials 2015 (1z0-417) Free Practice Test