10 Tips For Renewal 1Z0-417 vce

Q1. SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations? 

A. Materialized views 

B. Indexes 

C. Partitions 

D. Tablespaces 

E. V$ performance views 

F. Hints 

View Answer

Q2. A customer has database performance issues within their Oracle Real Application Cluster. What is the next step? 

A. Run the V$RAC script to dump all the RAC statistics and look for what has the highest metric accumulation. 

B. Use the application load testing utility to overload a copy of their application in development to flush out theissue. 

C. Turnoff RAC interconnects to isolate any network issues impacting database performance problems. 

D. Use a third-party RAC tool to identify the bad SQL and then rewrite it. 

E. Utilize the Oracle Database Performance Method to help identify and correct issue. 

View Answer

Q3. A customer not familiar with Active Session History (ASH) asked you what it was used for. Which are two statements you can use to accurately describe (ASH) capabilities? 

A. It enables you to conduct performance analysis of long-running sessions. 

B. It enables you to conduct performance analysis of transient issues. 

C. In memory, active sessions are sampled every second. 

D. It accesses database kernel structures indirectly via the buffer cache. 

E. It enables you to look at all database sessions since the database was created. 

View Answer

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

View Answer

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

View Answer

Q6. To use Automatic Database Diagnostic Management capability on a database using a SQL script, command line, database views, or from a GUI, which option needs to be licensed? 

A. Oracle Diagnostics Pack for Oracle Databases 

B. Oracle Tuning Pack for Oracle Databases 

C. Oracle Diagnostics and Tuning Pack for Oracle Databases 

D. Oracle ADDM Pack 

E. Nothing else needs to be licensed. 

View Answer

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

View Answer

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

View Answer

Q9. When managing multiple database instances on a single server, which initialization parameter limits the number of CPU's that an instance can use simultaneously? 

A. CPU_NUM 

B. NUM_CPU 

C. MAX_CPU 

D. LIMIT_CPU 

E. CPU_COUNT 

View Answer

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

View Answer