1Z0-417 Online Practice Questions and Answers

What are three activities an Oracle Database Performance and Tuning solution enables a customer to perform?

A. standardize database troubleshooting and diagnostics

B. control database clouds.

C. automate database performance management

D. perform global database backup

E. outsource database operations

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

A customer has database performance issues within their Oracle Real Application Cluster. What is the next step?

A. Run the V$RAC script to dump all the RAC statistics and look for what has the highest metric accumulation.

B. Use the application load testing utility to overload a copy of their application in development to flush out theissue.

C. Turnoff RAC interconnects to isolate any network issues impacting database performance problems.

D. Use a third-party RAC tool to identify the bad SQL and then rewrite it.

E. Utilize the Oracle Database Performance Method to help identify and correct issue.

Starting with Oracle Database 11gR2, which are two additional partitioning capabilities that aid Oracle Database Performance and Tuning?

A. Hash Partitioning

B. Reference Partitioning

C. Composite Partitioning

D. Interval Partitioning

E. Disk Partitioning

When performing performance analysis of Oracle Real Application Cluster (RAC) databases, what are three Automatic Database Diagnostics Monitoring (ADDM) analysis modes that are available?

A. Database

B. Instance

C. Partial

D. Sample

E. Average

Which is the default statistics gatheringperiod for Automatic Database Diagnostics Monitoring (ADDM)?

A. every 30 seconds

B. every 60 minutes

C. every 30 minutes

D. every 24 hoursE. every 40 hours

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 two could Oracle Database Replay is used to validate performance?

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

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

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

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

E. to find the least-used SQL statement

Which option would you use to capture workloads from one or more systems concurrently and then play them back?

A. Automatic Workload Repository

B. Enterprise Manager Cloud Control

C. Consolidated Database Replay

D. Consolidation Planner

E. Workload Consolidator and Playback

Which two statements are true about Automatic Statistics collection by the Optimizer?

A. Statistics are collected during automatic maintenance tasks.

B. Any fixed objects are disregarded.

C. Any external tables are incorporated.

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

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

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.