1Z0-417 Online Practice Questions and Answers

Which is a capability that Active Session History (ASH) reports enable you to perform?

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

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

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

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

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

As of Oracle Database 12c, which functionality to access database diagnostic and performance has been superseded by Oracle Enterprise Manager Database Express?

A. SQL Developer

B. SQL Plus

C. Database console

D. SQL Express

E. Grid Control

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

Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another?

A. SQLHints

B. Stored Outlines

C. Stored Profiles

D. SQL Plan Management

E. SQL Profiles

When planning an Oracle Database architecture, which are three caching functionalities that would improve application response time and speed up query processing?

A. Result Cache

B. Mega Cache

C. Oracle In-Memory Database Cache

D. Database Smart Flash Cache

E. Oracle In-Memory DBSTATS Cache

Which are two characteristics of "invisible" index functionality that would help tune a database having thousands of legacy indexes?

A. An invisible index is ignored by the optimizer.

B. After an index becomes invisible, it is no longer maintained during insertsand updates.

C. I/O bottlenecks are easy to spot when invisible indexes are used.

D. An index only needs to be rebuilt for it to be visible again.

E. The session or system parameter needs to be changed toOPTIMIZER_USE_INVISIBLE_INDEXEStoTRUEfor an invisible index to become visible to the Optimizer.

Which statement about Oracle Enterprise Manager Database Expressis correct?

A. Oracle Enterprise Manager Database Control must be configured first.

B. The listener needs to be running for it to be accessed.

C. A Oracle Enterprise Manager Database Express WebLogic Server must be configured first.

D. Oracle Internet Application Server needs to be installed to use it.

E. Oracle Enterprise Manager Database Express can be used only from a command-line.

Which is a true statement about Automatic Database Diagnostic Monitor (ADDM)?

A. ADDM analyzes information in RMAN.

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

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

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

E. APEX is required to access ADDM.

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

A. It is a part of the database, which means no added installations, configurations, extra user accounts,privilege granting, etc.

B. It eliminates the need to reverify compatibility, upgrade third-party tools, or rewrite scripts after a patch ordatabase upgrade.

C. It has the largest library of custom scripts and procedures and includes an assembly builder to maintainthem and add more.

D. Results come from the Oracle Database Optimizer and not rules or heuristics trying to predict what theoptimizer may do.

E. It is the most inexpensive tool in the market.