1Z0-417 Exam Questions

You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%. Which two sources should you check for the...

Which are two strategies to maintain performance and improve a table segment's compression ratio when you are using Advanced Row Compression on a table segment?

Upon migration to Oracle Database 12c, a customer asked that monitoring at an individual database level be disabled in favor of database performance monitoring consolidated and cen...

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

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

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

Which option would you use to validate performance when migrating an Oracle Database from HPUX Itanium to Oracle Linux 6 architecture?

Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?

Which two statements are true regarding the database control file? (Choose two.)

Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are executing. You want to analyze the queries that are currentl...

Which product technology can assist an Application Developer to capture a full production workload and replay on a test system database?

Which is Oracle's architecture and methodology for Oracle Database High Availability (HA)?

In which two formats does Automatic Workload Repository (AWR) provide statistics?

In an Active Session History report, which response is correct?

At the IT Manager request, you are reviewing the databases that the DBA has implemented. You find configured as BASIC. What finding do you report back to the IT Manager? STATISTICS...

Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics f...

When preparing a new database installation, you want to ensure automatic collection of timed statistics. Which three configuration parameters are applicable?

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

Which two statements are true about viewing the details of Real-Time Database Operations? (Choose two.)

A DBA informs you that an Oracle instance has started. What does this imply?

For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality?

Which four use cases could Database Replay be used to test for database performance changes?

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

Which is a true statement about the difference in the functionality of Active Session History (ASH) and SQL Trace/TKPROF?

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 enti...

Which two are functionalities of Oracle Real Application Testing?

DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the Operation...

Which one is a type of user session and client request supported by Database Replay?

DBAs use scripts and a third-party tool that access Automatic Workload Repository (AWR) snapshot reports, but don't use Oracle Enterprise Manager. The IT Manager seeks to confirm w...

Which three are controllable by a resource plan, when you are using the Oracle Database 12c Multitenant option?

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

Which functionality should be used to recommend materialized views and view logs, indexes, SQL profiles, and partitions for a specific workload use?

To analyze all database instances in an Oracle Real Application Cluster, in which mode would you run Automatic Database Diagnostic Monitor?

Which three are benefits of implementing an Oracle Database Performance and Tuning solution?

Which two statements are true about Oracle Enterprise Manager Database Express?

A customer asked you about Database Time (DB Time). Which are two correct statements you would include in your description of it?

IT Operations had observed short CPU spikes and I/O storms prior to a retail website outage. Which functionality of Diagnostics Pack for Oracle Databases would you implement to dia...

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