1Z0-417 Online Practice Questions and Answers

Which is a capability that Active Session History (ASH) reports enable you to perform?

A. Compare database performance between two periods of time, and resolve performance degradation thatmay happen from one time period to another.

B. Analyze transient performance problems with the database that are short-lived and do not appear in theADDM analysis.

C. Optimize the performance of data access paths by creating the proper set of materialized views,materialized view logs, and indexes for a given workload.

D. Analyze transient performance problems that have happened in the database since it has been started.

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.

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.

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.

What are three activities an Oracle Database Performance and Tuning solution enables a customer to perform?

A. standardize database troubleshooting and diagnostics

B. control database clouds.

C. automate database performance management

D. perform global database backup

E. outsource database operations

F. replay and test actual workloads to assure database performance and consolidatios.

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

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

B. Instance

C. Partial

D. Sample

E. Average

When planning an Oracle Database architecture, which are three caching functionalities that would improve application response time and speed up query processing?

A. Result Cache

B. Mega Cache

C. Oracle In-Memory Database Cache

D. Database Smart Flash Cache

E. Oracle In-Memory DBSTATS Cache

Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQL objects?

A. LGWR

B. DBWR

C. CKPT

D. MMON

E. MMNL

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

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

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

A. Automatic Workload Repository

B. Enterprise Manager Cloud Control

C. Consolidated Database Replay

D. Consolidation Planner

E. Workload Consolidator and Playback

Identify four problems automatically diagnosed by Automatic Database Diagnostics Monitor (ADDM).

A. log file sizing

B. log buffer sizing

C. log file problematic naming

D. Mean Time to recover (MTTR) setting

E. undersized SGA or PGA

F. oversized SGA or PGA

G. Less Time to recover (LTTR) setting

An Oracle Database customer's VP of Development mentions that they've moved to AGILE development methodology and DevOps requires an ability to view, test, or validate performance in their own development environment. Which two do you implement?

A. Oracle Application Infrastructure Tester

B. Oracle Application Testing Suite

C. SQL Developer

D. Oracle Real Application Testing

E. APEX and SQL Developer

F. Oracle Testing Pack

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. Complete Oracle Enterprise Manager suite

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

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

D. Oracle Database Backup and Recovery

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