1Z0-417 Online Practice Questions and Answers

Which are three use cases in which SQL Performance Analyzer can be used?

A. find and flashback explain plan anomalies

B. simulate Exadata on existing hardware

C. forecast impact of a system change on aSQL workload

D. compare performance of SQL statements before and after a change

E. debug SQL code syntax before and after a change

F. JSQL Heap Memory overflow testing

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

Which are three practices that developers can use to enhance performance, scalability, and availability of Oracle Database-driven applications?

A. Implement primary and foreign keys, enforce database integrity, joins, message queuing, maintenance ofsequencesoutside of the database.

B. Use Big Data to hold everything into one big table.

C. Maintain and analyze performance statistics using AWR and ADDM.

D. Eliminate hot spots in applications, monitor, measure, and optimize SQL statement execution.

E. Perform testing with Real Application Testing.

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

A. The customer has Enterprise Manager installed on a separate server and regularly accesses the Databasehome page of some of its Enterprise Edition databases from its console.

B. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt.

C. A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set toDIAGNOSTIC +TUNING.

D. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer has SQLscripts that access theDBA_HIST_ACTIVE_SESS_HISTORYdatabase view.

E. A customer says that he or she doesn't use theEnterprise Manager, but you learn that the customer usescustomized SQL scripts that accessV$SESSIONandV$SQLviews.

You are reviewing an Automatic Database Diagnostic Monitor report. What is DB Time% a percentage of?

A. total CPU time

B. elapsed response time

C. total time in database calls by all processes

D. total time in V$ views

E. time that users wait for the database to respond

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. After a SQL Profile is created, it will then run efficiently for the life of the database.

C. The SQL Profile rewrites the SQL Statement issued by theapplication so it appears to the Optimizer as aperfectly written SQL statement.

D. You can have only one SQL Profile active at one time for a single SQL statement.

E. You need Oracle Database 12c or later to use SQL Profiles.

F. SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack islicensed.

When reviewing a customer's database configuration, you find thatOPTIMIZER_USE_SQL_PLAN_BASELINESis set asTRUE. What does the Optimizer do?

A. compares plans that itdevelops with accepted plans in baselines

B. develops plans and adds them to baselines as verified

C. doesn't develop an execution plan, but uses an accepted plan from baselines

D. doesn't develop an execution plan, but uses enabled plans in the baseline

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

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

Identify four problems automatically diagnosed by Automatic Database Diagnostics Monitor (ADDM).

A. log file sizing

B. log buffer sizing

C. log file problematic naming

D. Mean Time to recover (MTTR) setting

E. undersized SGA or PGA

F. oversized SGA or PGA

G. Less Time to recover (LTTR) setting