1Z0-417 | The Far out Guide To 1Z0-417 vce
Q41. You are reviewing an Automatic Database Diagnostic Monitor report. What is DB Time% a percentage of?
A. total CPU time
B. elapsed response time
C. total time in database calls by all processes
D. total time in V$ views
E. time that users wait for the database to respond
Answer: C
Q42. For which two capabilities would you implement Segment Advisor in order to aid a customer trying to find and fix performance issues related to database space?
A. to determine if objects have unusedspace that can be released
B. to advise if materialized views can be used to reduce size of views
C. to review space usage of individual schema objects or tablespaces
D. to advise if there are any duplicate indexes and automate their removal
E. to identify any fragmentation in the database cache or swap space
Answer: A,C
Q43. 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
Answer: D
Q44. Which three are benefits of implementing an Oracle Database Performance and Tuning solution?
A. automated database diagnostics based on deep database kernel integration
B. a library of hundreds of PL/SQL procedures to choose from for writing scripts to instrument the database tocollect performance information
C. monitor and alert on every Oracle Database Database Dictionary view using SNMP MIBS built into theOptimizer
D. the most extensive and up-to-date collection of database monitoring and tuning scripts
E. built-in instrumentation, real-time and historical monitoring, and data collection
F. a performance methodology
Answer: D,E,F
Q45. 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.
Answer: C
Q46. 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
Answer: D
Reference: http://www.oracle.com/technetwork/database/performance/resource-manager-twp-133705.pdf
Q47. The IT team said that a system appeared OK based on their third-party network and systems management tool; yet customers continue to complain of database performance-related issues. Which two would you implement to find and fix the problem?
A. Oracle Real User Experience Insight
B. Oracle Application Testing Suite
C. Oracle Exadata
D. Oracle Real Application Clusters
E. Oracle Diagnostic and Tuning Pack for Oracle Database
Answer: D,E
Q48. You need to load SQL statements from a time period of optimal performance to compare against a time period that performance was reported as poor. Which functionality would you use to accomplish that task?
A. Optimizer Statistics Comparator
B. Dynamic Baseline Advisor
C. Automatic Workload Repository Baselines
D. SQL Tuning Sets
E. Database Replay
Answer: D
Q49. 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
Answer: A