Free 1Z0-417 Exam Dumps PDF Preview

Question 1

Multiple choice

Which three are SQL Performance Analyzer capabilities that enable forecasting impact of system changes on a SQL workload?

A
measuring performance before and after the change
B
generating a list of SQL Hints that the Optimizer will use to improve overall performance
C
identifying the SQL statements that regressed or improved
D
providing tuning recommendations for each SQL statement that is regressed
E
measuring performance and comparing to industry benchmarks (TPC-C, TPC-D)
F
measuring a change in user session logins

Reveal answer details Close answer details

Correct answersA, C, E

Question 2

Multiple choice

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

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

Reveal answer details Close answer details

Correct answersA, C

Question 3

Multiple choice

Upon migration to Oracle Database 12c, a customer asked that monitoring at an individualdatabase level be disabled in favor of database performance monitoring consolidated and centralized across their enterprise.

Which are two actions you would take to meet the customer's requirements?

A
Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0.
B
For the always active Oracle Enterprise Manager Database Express process, create a script that willdisable that process upon database boot.
C
Using the appropriate architectureimplement Oracle Enterprise Manager.
D
Delete the "express" directory in Oracle Home to disable Oracle Enterprise Manager Database Express.
E
Changes permissions of the "express" directory to real only by root.
F
Enable SNMP and configure MIBS on each databaseand forward database monitoring SNMP traps.

Reveal answer details Close answer details

Correct answersB, E

Question 4

Multiple choice

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

A
With Diagnostics and Tuning Packs installed, an Oracle database recovers easily from a crash orcorruption.
B
Oracle Databases are constantly changing; more users, data added and deleted, varying SQL
atapplication level.
C
Diagnostics and Tuning Packs are needed to keepOracle Database table and index statistics current.
D
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.
E
Diagnostics and Tuning packs are a prerequisite for a customer to license Oracle Database EnterpriseEdition.

Reveal answer details Close answer details

Correct answersC, E

Question 5

Multiple choice

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
variety of real-time reports once the Business Intelligence option is installed
B
reports in response to critical errors
C
reports with findings and recommendations to resolve problems
D
reports examining memory and process usage
E
historical reports after the Database Diagnostic Repository (DDR) is configured
F
reports examining user and developer SQL programming errors

Reveal answer details Close answer details

Correct answersB, E, F

Question 6

Single choice

At the IT Manager request, you are reviewing the databases that the DBA has implemented. You findSTATISTICS_LEVELconfigured asBASIC.

What finding do you report back to the IT Manager?

A
The configuration of their databases is set up to also provide timed Operating System statistics and planexecution statistics.
B
The configuration of their databases is incorrect and should be set toNOT_TYPICAL.
C
The configuration of their databases has disabled collection of important statistics required for OracleDatabase functionality.
D
The configuration of their databases needs to be set toALLto enable collection of Operating System, Middleware, and storage statistics.

Reveal answer details Close answer details

Correct answerC

Question 7

Multiple choice

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

Reveal answer details Close answer details

Correct answersA, E, F

Question 8

Single choice

As of Oracle Database 12c, which functionality to access database diagnostic and performance has been superseded by Oracle Enterprise Manager Database Express?

A
SQL Developer
B
SQL Plus
C
Database console
D
SQL Express
E
Grid Control

Reveal answer details Close answer details

Correct answerC

Question 9

Single choice

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 Maximum Availability Architecture
C
a Documented Performance Methodology
D
capability to Cloud Burst
E
a Documented Performance Response Method

Reveal answer details Close answer details

Correct answerB

Question 10

Single choice

Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance?

A
lock out user sessions and gather system statistics overnight
B
gather system statistics after a performance issue has been reported
C
gather system statistics for several hours when there is no workload
D
gather system statistics for several hours during normal workload periods
E
shut down any running applications prior to collection

Reveal answer details Close answer details

Correct answerD

Question 11

Multiple choice

You need to limit the resources available to each Pluggable Database (PDB) within a Container Database (CDB).
Utilizing Resource Manager, which are three options that can be managed by a resource plan?

A
memory
B
CPU
C
Parallel Execution Servers
D
shares of systemresources
E
number of users
F
number of tables or indexes
G
number of indexes

Reveal answer details Close answer details

Correct answersB, C, D

Question 12

Single choice

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
DATABASE_MAXCPUS=YES
D
Oracle Database Resource Manager
E
DB_RAC_MAXCPU=YES
F
Oracle Grid Control

Reveal answer details Close answer details

Correct answerD

Question 13

Multiple choice

Which are three use cases in which SQL Performance Analyzer can be used?

A
find and flashback explain plan anomalies
B
simulate Exadata on existing hardware
C
forecast impact of a system change on aSQL workload
D
compare performance of SQL statements before and after a change
E
debug SQL code syntax before and after a change
F
JSQL Heap Memory overflow testing

Reveal answer details Close answer details

Correct answersB, C, E

VOL	TYPE	QUESTIONS
1	Single choice	5
2	Multiple choice	8

Free 1Z0-417 Exam Dumps Preview

Oracle Database

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13