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

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 needs to be set toALLto enable collection of Operating System, Middleware, and storage statistics.

C. The configuration of their databases has disabled collection of important statistics required for OracleDatabase functionality.

D. The configuration of their databases is incorrect and should be set toNOT_TYPICAL.

A. Increase the size of the tablespace.

B. Use smaller database block size.

C. Use larger database block size.

D. IncreasePCTFREEon the table segment.

E. Use direct-path inserts wherepossible.

A. applying a workload from one database release to another database release

B. to find the least-used SQL statement

C. applying workload to an application after an operating system patch

D. moving a workload from a single database instance and applying it to an Oracle Real Application Cluster(RAC)

E. to check and compare if a specific set of SQL statements have regressed between two different databasereleases

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. network I/O

B. concurrent sessions

C. ability to use parallel server processes

D. use of SGA memory and ability to allocate PGA

E. CPU

F. SGA

A. ADDM and AWR are new features of Oracle Database 12c.

B. ADDM analyzes information in RMAN.

C. Automatic Workload Repository (AWR) analyzes information stored in snapshots in tables of ADDM.

D. APEX is required to access ADDM.

E. ADDM analyzes information stored in snapshots in tables of the Automatic Workload Repository (AWR).

A. All tables in the data dictionary are included by defaults.

B. Any fixed objects are disregarded.

C. Any external tables are incorporated.

D. Statistics are gathered after table statistics are marked stale.

E. Statistics are collected during automatic maintenance tasks.

A. It is delivered with Oracle Engineered Systems.

B. It is recommended for Production environments, but not for Development or QA.

C. It is available for Oracle Database Standard and Enterprise Editions.

D. It builds on capabilities built into Oracle databases.

E. It is applicable for Oracle Database 12c and later versions.

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.