[2026] Oracle Database Performance and Tuning Essentials 2015

문제1

Which one is a type of user session and client request supported by Database Replay?

A. SQL-based object access

B. Flashback queries

C. Database Resident Connection Pooling (DRCP)

D. XA transactions

E. Oracle Call Interface (OCI) based object navigations

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제2

What are two reasons for which the Diagnostics and Tuning packs are essential to ongoing maintenance of an Oracle Database?

A. Inefficient "Bad" application SQL can be detected by Diagnostics Pack and then optimized utilizing TuningPack SQL Profiles, even if it can't be changed at the application end.

B. With Diagnostics and Tuning Packs installed, an Oracle database recovers easily from a crash orcorruption.

C. Diagnostics and Tuning packs are a prerequisite for a customer to license Oracle Database EnterpriseEdition.

D. Oracle Databases are constantly changing; more users, data added and deleted, varying SQL atapplication level.

E. Diagnostics and Tuning Packs are needed to keepOracle Database table and index statistics current.

정답: C,E

문제3

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

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

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

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.

정답: B,C,E

문제4

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

A. total time in database calls by all processes

B. total CPU time

C. total time in V$ views

D. elapsed response time

E. time that users wait for the database to respond

정답: A

문제5

Which one would SQL Access Advisor use as input to provide a recommendation on a partition or index?

A. SQL Error

B. SQL Tuning Set

C. SQL Tuning Advisor

D. Automatic Workload Repository

E. Automatic Diagnostic Monitor

정답: C

문제6

In an Active Session History report, which response is correct?

A. 60 minutes of ASH data can be held in memory, but more than 1 hour can be reported.

B. ASH data is available 24 hoursbecause AWR snapshots refresh every night.

C. 60 minutes of ASH data can be held in memory, so only 1 hour can be reported.

D. As ASH data is flushed every 60 seconds, you need to set up a snapshot withDBA_JOBSfor what you want to keep.

정답: C

문제7

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

D. DB_RAC_MAXCPU=YES

E. DATABASE_MAXCPUS=YES

F. Oracle Grid Control

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제8

The IT team said that a system appeared OK based on their third-party network and systems management tool; yet customers continue to complain of database performance-related issues. Which two would you implement to find and fix the problem?

A. Oracle Real Application Clusters

B. Oracle Exadata

C. Oracle Application Testing Suite

D. Oracle Real User Experience Insight

E. Oracle Diagnostic and Tuning Pack for Oracle Database

정답: A,E

문제9

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. Dynamic Baseline Advisor

B. Optimizer Statistics Comparator

C. SQL Tuning Sets

D. Database Replay

E. Automatic Workload Repository Baselines

정답: C

Oracle Database Performance and Tuning Essentials 2015 - 1z0-417무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트