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

Question 1

To analyze all database instances in an Oracle Real Application Cluster, in which mode would you run Automatic Database Diagnostic Monitor?

A. ALL

B. CLUSTER

C. DATABASE

D. PARTIAL

E. FULL

F. INSTANCE

Correct Answer: F

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

Question 2

DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the Operations Team. What would you implement to resolve this problem?

A. Oracle Database Backup & Recovery

B. SQL Performance Analyzer which helps predict and prevent SQL execution performance problems causedby environment changes

C. Oracle SQL Developer, which helps develop and test the SQL prior to putting it into production

D. SQL Plan Manager which uses system histograms to extrapolate future SQL execution performance

E. Complete Oracle Enterprise Manager suite

Correct Answer: B

Question 3

When performing performance analysis of Oracle Real Application Cluster (RAC) databases, what are three Automatic Database Diagnostics Monitoring (ADDM) analysis modes that are available?

A. Average

B. Instance

C. Sample

D. Partial

E. Database

Correct Answer: B,D,E

Question 4

SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations?

A. V$ performance views

B. Partitions

C. Tablespaces

D. Materialized views

E. Hints

F. Indexes

Correct Answer: A,C,F

Question 5

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. SetAUTOMATIC_WORKLOAD_REPOSITORY_COLLECTIONtoPAUSE.

C. SetAUTO_UPDATE_STATISTICStoFALSE.

D. Use aHOLD HINTin the SQL.

Correct Answer: A

Question 6

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

A. Perform testing with Real Application Testing.

B. Eliminate hot spots in applications, monitor, measure, and optimize SQL statement execution.

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

D. Maintain and analyze performance statistics using AWR and ADDM.

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

Correct Answer: A,C,D

Question 7

Which action can beperformed by using Oracle Enterprise Manager Database Express Performance Hub?

A. Launch and view STATSPACK reports.

B. View health status and performance of an Oracle Database instance via Database Control.

C. View only real-time Oracle Database performance information.

D. Consolidate ADDM, AWR, and ASH repositories within an enterprise and enable centralized performancereporting.

E. View real-time and historical Oracle Database performance information.

F. View only historical Oracle Database performance information.

Correct Answer: E

Question 8

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

A. Consolidated Database Replay

B. Workload Consolidator and Playback

C. Consolidation Planner

D. Automatic Workload Repository

E. Enterprise Manager Cloud Control

Correct Answer: A

Question 9

Starting with Oracle Database 11gR2, which are two additional partitioning capabilities that aid Oracle Database Performance and Tuning?

A. Composite Partitioning

B. Hash Partitioning

C. Disk Partitioning

D. Reference Partitioning

E. Interval Partitioning

Correct Answer: A,E

Welcome to TestSimulate

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