1Z0-417 Online Practice Questions and Answers

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.

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

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

A. It is available for Oracle Database Standard and Enterprise Editions.

B. It is applicable for Oracle Database 12c and later versions.

C. It builds on capabilities built into Oracle databases.

D. It is recommended for Production environments, but not for Development or QA.

E. It is delivered with Oracle Engineered Systems.

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

A. Linux Operating system

B. 8 GB of memory

C. Oracle Database Enterprise Edition

D. Oracle Enterprise Manager

E. deep knowledge of Oracle Storage subsystems

Which four use cases could Database Replay be used to test for database performance changes?

A. a change in operating system versions

B. compare Flashback workload

C. check a workload from a single instance on an Oracle RAC database

D. check a workload after database parameters have been changed

E. check a workload from one database release on another database released

F. upgrade an application

Which product technology can assist an Application Developer to capture a full production workload and replay on a test system database?

A. Oracle Database Diagnostics Pack for Oracle Database

B. Oracle Database Replay and Testing Suite

C. Oracle SQL Developer

D. Oracle Real Application Testing

E. Oracle Real Tuning Pack for Oracle Database

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

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

A. SQL Tuning Advisor

B. Automatic Workload Repository

C. Automatic Diagnostic Monitor

D. SQL Tuning SetE. SQL Error