Oracle Database Performance and Tuning Essentials 2015 - 1z1-417 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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

A. Oracle Enterprise Manager B. Linux Operating system C. deep knowledge of Oracle Storage subsystems D. Oracle Database Enterprise Edition E. 8 GB of memory

Discussion 0

Correct Answer: D Vote an answer

Question 2

Which functionality should be used to recommend materialized views and view logs, indexes, SQL profiles,and partitions for a specific workload use?

A. SQL Tuning Advisor B. SQL Access Advisor C. Workload Advisor D. Top SQL E. SQL Performance Analyzer

Discussion 0

Correct Answer: B Vote an answer

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

Question 3

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

A. It is recommended for Production environments, but not for Development or QA. B. It builds on capabilities built into Oracle databases. C. It is applicable for Oracle Database 12c and later versions. D. It is available for Oracle Database Standard and Enterprise Editions. E. It is delivered with Oracle Engineered Systems.

Discussion 0

Correct Answer: E Vote an answer

Question 4

DBAs use scripts and a third-party tool that access Automatic Workload Repository (AWR) snapshot reports, but don't use Oracle Enterprise Manager. The IT Manager seeks to confirm what the DBAs told him - Its OK since they licensed Oracle Database Enterprise Edition and not the Standard Edition. Which is the correct response for this scenario?

A. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needtobe licensed for the Advanced Analytic Pack for Oracle Databases. B. With an Oracle Enterprise Edition Database license, a customer can use any Oracle option they want, atany of their worldwide locations, without additional licensing. C. With an Oracle Database Enterprise Edition license, an Oracle customer can use any Oracle option theywant, at that location, without additional licensing. D. With an Oracle Database Enterprise Edition license, an Oracle customer can access AWR snapshots byusing SQL. If you use anything else, then you need an additional license. E. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needto be licensed for the Oracle Diagnostic Pack for Oracle Databases.

Discussion 0

Correct Answer: C Vote an answer

Question 5

An advanced fault diagnostic infrastructure introduced as of Oracle Database 11g, assigns an incidentnumber and diagnostic data when a critical error occurs. What is the feature and where does it store that data?

A. Oracle Enterprise Manager. Data is stored in the OEM Repository. B. Automatic Diagnostic Repository. Data is stored in a file-based repository outside the database. C. Automatic Workload Repository. Data is stored in views inside the Oracle database. D. MyOracle Support. Data is stored in Oracle Cloud. E. Automatic Diagnostic Repository. Data is stored in views inside the Oracle database.

Discussion 0

Correct Answer: B Vote an answer

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

Question 6

You have been asked to provide a "technology update" to a long time Oracle Database customer. During the meeting, you are asked about Oracle Enterprise ManagerDatabase Express in Oracle Database 12c.
Identify three of its capabilities you would share with the customer.

A. The Database Express Performance HUB displays Oracle RAC specific metrics. B. The Oracle enterprise Manager Database Express Performance Hub displays Oracle RAC specific metricswhen the optional RAC Pack is licensed. C. Oracle Enterprise Manager Database Express does not require any separate middle-tier componentsbecause it uses XDB and SQL*NET. D. Oracle Enterprise Manager Database Express can be extended by the user to also display Oracle 7-10gdatabases. E. Once Oracle Database 12c is installed, a DBA runs the separate Oracle Enterprise Manager DatabaseExpress installer to add it into the database console. F. The Oracle Enterprise Manager Database Express Performance HUB organizes and provides aconsolidated viewof real-time and historical performance data.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 7

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

A. CLUSTER B. ALL C. INSTANCE D. FULL E. PARTIAL F. DATABASE

Discussion 0

Correct Answer: C Vote an answer

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

Question 8

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

A. Hash Partitioning B. Interval Partitioning C. Reference Partitioning D. Disk Partitioning E. Composite Partitioning

Discussion 0

Correct Answer: B,E Vote an answer

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

Discussion 0

Correct Answer: B Vote an answer