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. MyOracle Support. Data is stored in Oracle Cloud.
C. Automatic Workload Repository. Data is stored in views inside the Oracle database.
D. Automatic Diagnostic Repository. Data is stored in views inside the Oracle database.
E. Automatic Diagnostic Repository. Data is stored in a file-based repository outside the database.
Which option would you use to validate performance when migrating an Oracle Database from HPUX Itanium to Oracle Linux 6 architecture?
A. Oracle Diagnostic Pack for Database
B. Real Application Testing
C. Oracle Migration Pack for Databases
D. Oracle Migration Performance Advisor
E. SQL Performance Testing Suite
Which two are functionalities of Oracle Real Application Testing?
A. Database Replay
B. SQL Query Sets (SQS)
C. SQL Tuning Analyzer
D. SQL Performance Analyzer (SPA)
E. Real Application Cluster Replay
For which one would you use an index fast full scan to improve performance?
A. a query having all the columns of an index in the where clause
B. a query that does not need to access table rows
C. a query that needs to access table rows along with an index
D. a column in an index that is compressed
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.
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.
Which two would automatically create an entry inV$SQL_MONITOR?
A. a parallelized SQL statement
B. any SQL statement run
C. any DML statement
D. a statement that consumes at least 1 second of CPU or I/O time.
E. a statement that consumes at least 5 second of CPU or I/O time.
F. any DDL statement
Which is a true statement about the difference in the functionality of Active Session History (ASH) and SQL Trace/TKPROF?
A. ASH provides time based data, SQL Trace/TKPROF does not
B. ASH provides detailed session level data, SQL Trace/TKPROF does not
C. ASH is always on, SQL Trace/TKPROF is not
D. ASH identifies Bind variables that are available, SQL Trace/TKPROF does not
E. ASH counts and has occurrence data, SQL Trace/TKPROF does not
In which two formats does Automatic Workload Repository (AWR) provide statistics?
A. Persistent
B. Temporary
C. Unlimited
D. Basic
E. Full
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.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-417 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.