최신Oracle Database Performance and Tuning Essentials 2015 - 1z1-417무료샘플문제

A. Analyze transient performance problems that have happened in the database since it has been started.

B. Compare database performance between two periods of time, and resolve performance degradation thatmay happen from one time period to another.

C. Analyze transient performance problems with the database that are short-lived and do not appear in theADDM analysis.

D. Optimize the performance of data access paths by creating the proper set of materialized views,materialized view logs, and indexes for a given workload.

A. Diagnostics and Tuning Packs are needed to keepOracle Database table and index statistics current.

B. Oracle Databases are constantly changing; more users, data added and deleted, varying SQL atapplication level.

C. With Diagnostics and Tuning Packs installed, an Oracle database recovers easily from a crash orcorruption.

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.

A. to advise if there are any duplicate indexes and automate their removal

B. to determine if objects have unusedspace that can be released

C. to review space usage of individual schema objects or tablespaces

D. to identify any fragmentation in the database cache or swap space

E. to advise if materialized views can be used to reduce size of views

A. replay and test actual workloads to assure database performance and consolidatios.

B. outsource database operations

C. perform global database backup

D. standardize database troubleshooting and diagnostics

E. automate database performance management

F. control database clouds.

A. a parallelized SQL statement

B. any DDL statement

C. a statement that consumes at least 1 second of CPU or I/O time.

D. a statement that consumes at least 5 second of CPU or I/O time.

E. any DML statement

F. any SQL statement run

A. gather system statistics for several hours during normal workload periods

B. gather system statistics for several hours when there is no workload

C. shut down any running applications prior to collection

D. gather system statistics after a performance issue has been reported

E. lock out user sessions and gather system statistics overnight

A. Oracle SQL Developer, which helps develop and test the SQL prior to putting it into production

B. SQL Performance Analyzer which helps predict and prevent SQL execution performance problems causedby environment changes

C. Complete Oracle Enterprise Manager suite

D. SQL Plan Manager which uses system histograms to extrapolate future SQL execution performance

E. Oracle Database Backup & Recovery

A. Oracle Real Application Testing

B. Oracle Tuning Pack for Oracle Database

C. Oracle SQL Developer

D. Oracle Performance Pack for Oracle Database

E. SQL Tuning Pack for Oracle Database

F. STATSPACK

G. Oracle Diagnostics Pack for Oracle Database

A. SQL Access Advisor

B. Top SQL

C. SQL Performance Analyzer

D. SQL Tuning Advisor

E. Workload Advisor