1z0-417 by Oracle Valid Free Exam Practice Test

Question 1

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

A. Automatic Workload Repository B. SQL Tuning Advisor C. SQL Tuning Set D. Automatic Diagnostic Monitor E. SQL Error

Correct Answer: B

Question 2

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. SQL Tuning Sets B. Database Replay C. Dynamic Baseline Advisor D. Optimizer Statistics Comparator E. Automatic Workload Repository Baselines

Correct Answer: A

Question 3

Which two could Oracle Database Replay is used to validate performance?

A. moving a workload from a single database instance and applying it to an Oracle Real Application Cluster(RAC) B. to find the least-used SQL statement C. to check and compare if a specific set of SQL statements have regressed between two different databasereleases D. applying a workload from one database release to another database release E. applying workload to an application after an operating system patch

Correct Answer: A,E

Question 4

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

A. a Documented Set of X$ and V$ Query Scripts B. a Documented Performance Methodology C. a Documented Performance Response Method D. capability to Cloud Burst E. a Maximum Availability Architecture

Correct Answer: E

Question 5

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

A. View real-time and historical Oracle Database performance information. B. Launch and view STATSPACK reports. C. View health status and performance of an Oracle Database instance via Database Control. D. View only real-time Oracle Database performance information. E. View only historical Oracle Database performance information. F. Consolidate ADDM, AWR, and ASH repositories within an enterprise and enable centralized performancereporting.

Correct Answer: A

Question 6

When managing multiple database instances on a single server, which initialization parameter limits the number of CPU's that an instance can use simultaneously?

A. CPU_NUM B. CPU_COUNT C. NUM_CPU D. MAX_CPU E. LIMIT_CPU

Correct Answer: B

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

Question 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. DB_RAC_MAXCPU=YES B. Oracle Database Resource Manager C. Oracle Job Scheduler D. Exadata E. Oracle Grid Control F. DATABASE_MAXCPUS=YES

Correct Answer: B

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

Question 8

When providing partition and index recommendations, which one would SQL Access Advisor source input from?

A. Automatic Database Diagnostic Monitor B. Automatic Workload Repository C. SQL Tuning Advisor D. SQL Tuning Set

Correct Answer: D

Question 9

When reviewing a customer's database configuration, you find thatOPTIMIZER_USE_SQL_PLAN_BASELINESis set asTRUE. What does the Optimizer do?

A. compares plans that itdevelops with accepted plans in baselines B. doesn't develop an execution plan, but uses enabled plans in the baseline C. develops plans and adds them to baselines as verified D. doesn't develop an execution plan, but uses an accepted plan from baselines

Correct Answer: C

Oracle Database Performance and Tuning Essentials 2015 - 1z0-417 Exam Practice Test