1Z0-417 Online Practice Questions and Answers

You need to load SQL statements from a time period of optimal performance to compare against a time period that performance was reported as poor. Which functionality would you use to accomplish that task?

A. Optimizer Statistics Comparator

B. Dynamic Baseline Advisor

C. Automatic Workload Repository Baselines

D. SQL Tuning Sets

E. Database Replay

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.

A customer not familiar with Active Session History (ASH) asked you what it was used for. Which are two statements you can use to accurately describe (ASH) capabilities?

A. It enables you to conduct performance analysis of long-running sessions.

B. It enables you to conduct performance analysis of transient issues.

C. In memory, active sessions are sampled every second.

D. It accesses database kernel structures indirectly via the buffer cache.

E. It enables you to look at all database sessions since the database was created.

Which is a feature of an Oracle Database Performance and Tuning implemented solution?

A. a Documented Set of X$ and V$ Query Scripts

B. a Maximum Availability Architecture

C. a Documented Performance Methodology

D. capability to Cloud Burst

E. a Documented Performance Response Method

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.

Select two scenarios that an Oracle Database Performance and Tuning solution implementation addresses.

A. After migration off a legacy system, an ERP team complains that they have no ability to isolate performanceproblems in the new distributed Oracle Database architecture.

B. An HR Team claims that it can hire staff fast enough to meet business demands.

C. Development Team members demand that their SQL should run fast while the DBAs blame SQL as theroot of performance issues.

D. To prepare for an upcoming code audit, developers need to review their SQL and PL/SQL code for syntaxand runtime errors.

E. Systems and Storage teams report that over the past 12 month, it is taking 40% longer time to back up theservers with Oracle databaseson them.

Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database. Which would you configure for that to occur?

A. SetOPTIMIZER_USE_PENDING_STATISTICStoTRUE.

B. SetAUTO_UPDATE_STATISTICStoFALSE.

C. Use aHOLD HINTin the SQL.

D. SetAUTOMATIC_WORKLOAD_REPOSITORY_COLLECTIONtoPAUSE.

When providing partition and index recommendations, which one would SQL Access Advisor source input from?

A. SQL Tuning Advisor

B. Automatic Workload Repository

C. Automatic Database Diagnostic Monitor

D. SQL Tuning Set

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.