http://https://www.examslabs.com/Oracle/Oracle-Database-12c/best-1z0-417-exam-dumps.html (85 Q&As Dumps, 30%OFF Special Discount: bmzblwH7 )

NEW QUESTION NO: 6
Which four use cases could Database Replay be used to test for database performance changes?
A. check a workload after database parameters have been changed
B. check a workload from a single instance on an Oracle RAC database
C. check a workload from one database release on another database released
D. a change in operating system versions
E. upgrade an application
F. compare Flashback workload
Answer: A,B,C,D

NEW QUESTION NO: 7
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
Answer: C
Explanation/Reference:
Reference: http://dbaora.com/enterprise-manager-database-express-oracle-database-12c-release-1-12-1/

NEW QUESTION NO: 8
Which functionality should be used to recommend materialized views and view logs, indexes, SQL profiles, and partitions for a specific workload use?
A. SQL Performance Analyzer
B. Top SQL
C. SQL Tuning Advisor
D. SQL Access Advisor
E. Workload Advisor
Answer: D
Explanation/Reference:
Reference: http://docs.oracle.com/cd/E25054_01/fusionapps.1111/e14496/monitor_db.htm (12.2.4.5 Using SQL Access Advisor)

NEW QUESTION NO: 9
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 what the DBAs told him - Its OK since they licensed Oracle Database Enterprise Edition and not the Standard Edition. Which is the correct response for this scenario?
A. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers need to be licensed for the Oracle Diagnostic Pack for Oracle Databases.
B. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers need to be licensed for the Advanced Analytic Pack for Oracle Databases.
C. With an Oracle Database Enterprise Edition license, an Oracle customer can access AWR snapshots by using SQL. If you use anything else, then you need an additional license.
D. With an Oracle Enterprise Edition Database license, a customer can use any Oracle option they want, at any of their worldwide locations, without additional licensing.
E. With an Oracle Database Enterprise Edition license, an Oracle customer can use any Oracle option they want, at that location, without additional licensing.
Answer: E

NEW QUESTION NO: 10
When providing partition and index recommendations, which one would SQL Access Advisor source input from?
A. SQL Tuning Advisor
B. Automatic Workload Repository
C. SQL Tuning Set
D. Automatic Database Diagnostic Monitor
Answer: C

NEW QUESTION NO: 11
Which two could Oracle Database Replay is used to validate performance?
A. applying a workload from one database release to another database release
B. applying workload to an application after an operating system patch
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 database releases
E. to find the least-used SQL statement
Answer: B,C

NEW QUESTION NO: 12
To isolate performance problem in an Oracle real Application Cluster, for which two abilities would you implement Oracle Diagnostics Pack for Oracle Databases?
A. ADDM X$ and V$ performance analysis and reports that compare the overall RAC Database to the sum of its individual database instances.
B. Database-wide analysis of global resources by ADDM for high-load SQL, global cache interconnect traffic, and skew in instance response times.
C. ADDM's ability to review SNMP trap error messages and automatically open trouble tickets.
D. ADDM recommendations inclusive of SAN and NFS mounted storage to pinpoint issues within the storage cache.
E. Cluster-wide performance analysis and reports with ADDM on issues that affect an entire database as well as its individual instances.
Answer: B,D

NEW QUESTION NO: 13
To use Automatic Database Diagnostic Management capability on a database using a SQL script, command line, database views, or from a GUI, which option needs to be licensed?
A. Oracle ADDM Pack
B. Oracle Diagnostics Pack for Oracle Databases
C. Nothing else needs to be licensed.
D. Oracle Diagnostics and Tuning Pack for Oracle Databases
E. Oracle Tuning Pack for Oracle Databases
Answer: D

NEW QUESTION NO: 14
You need to limit the resources available to each Pluggable Database (PDB) within a Container Database (CDB). Utilizing Resource Manager, which are three options that can be managed by a resource plan?
A. CPU
B. Parallel Execution Servers
C. number of tables or indexes
D. shares of system resources
E. memory
F. number of users
G. number of indexes
Answer: A,B,D

NEW QUESTION NO: 15
What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?
A. You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.
B. You can have only one SQL Profile active at one time for a single SQL statement.
C. After a SQL Profile is created, it will then run efficiently for the life of the database.
D. SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack is licensed.
E. The SQL Profile rewrites the SQL Statement issued by the application so it appears to the Optimizer as a perfectly written SQL statement.
F. You need Oracle Database 12c or later to use SQL Profiles.
Answer: A,B

NEW QUESTION NO: 16
Which three are benefits of implementing an Oracle Database Performance and Tuning solution?
A. the most extensive and up-to-date collection of database monitoring and tuning scripts
B. monitor and alert on every Oracle Database Database Dictionary view using SNMP MIBS built into the Optimizer
C. built-in instrumentation, real-time and historical monitoring, and data collection
D. automated database diagnostics based on deep database kernel integration
E. a performance methodology
F. a library of hundreds of PL/SQL procedures to choose from for writing scripts to instrument the database to collect performance information
Answer: A,C,E