1Z0-417 Free Practice Test

Which three issues can be addressed with an Oracle Database Performance and Tuning solution?

1. A. erratic or inconsistent database performance
2. B. declining database responsiveness
3. C. unlimited I/O
4. D. fragmented database tables
5. E. database registry errors
6. F. database replication

Correct Answer: CDF

What are three reasons an implementation of an Oracle Database Performance and Tuning solution is superior to that of scripts or third-party tools?

1. A. It is a part of the database, which means no added installations, configurations, extra user accounts,privilege granting, etc.
2. B. It eliminates the need to reverify compatibility, upgrade third-party tools, or rewrite scripts after a patch ordatabase upgrade.
3. C. It has the largest library of custom scripts and procedures and includes an assembly builder to maintainthem and add more.
4. D. Results come from the Oracle Database Optimizer and not rules or heuristics trying to predict what theoptimizer may do.
5. E. It is the most inexpensive tool in the market.

Correct Answer: BDE

Which three are SQL Performance Analyzer capabilities that enable forecasting impact of system changes on a SQL workload?

1. A. measuring performance before and after the change
2. B. generating a list of SQL Hints that the Optimizer will use to improve overall performance
3. C. identifying the SQL statements that regressed or improved
4. D. providing tuning recommendations for each SQL statement that is regressed
5. E. measuring performance and comparing to industry benchmarks (TPC-C, TPC-D)
6. F. measuring a change in user session logins

Correct Answer: ACE

Which three are benefits of implementing an Oracle Database Performance and Tuning solution?

1. A. automated database diagnostics based on deep database kernel integration
2. B. a library of hundreds of PL/SQL procedures to choose from for writing scripts to instrument the database tocollect performance information
3. C. monitor and alert on every Oracle Database Database Dictionary view using SNMP MIBS built into theOptimizer
4. D. the most extensive and up-to-date collection of database monitoring and tuning scripts
5. E. built-in instrumentation, real-time and historical monitoring, and data collection
6. F. a performance methodology

Correct Answer: DEF

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?

1. A. to determine if objects have unusedspace that can be released
2. B. to advise if materialized views can be used to reduce size of views
3. C. to review space usage of individual schema objects or tablespaces
4. D. to advise if there are any duplicate indexes and automate their removal
5. E. to identify any fragmentation in the database cache or swap space

Correct Answer: AC