Free Oracle 1z1-064 Exam Dumps Questions & Answers

Which two statements are true about server-generated alerts? (Choose two.)

• A.  They are generated only when the STATISTICS_LEVEL initialization parameter is set to ALL.
• B.  They appear in the DBA_ALERT_HISTORY view whenever corrective action is taken for an alert.
• C.  They are always logged in the alert log.
• D.  They can be generated for user-defined metric thresholds.
• E.  They are written to a trace file if the TRACE_ENABLED initialization parameter is set to TRUE.

Which two statements are true about wait events?

• A.  Wait event countries are incremented by the server process that waits.
• B.  A wait event can be defined in multiple wait classes.
• C.  Wait event statistics are cumulatively collected only at the instance level.
• D.  Wait events for an instance include statistics for both background and foreground processes.
• E.  A single resource wait event may be recorded as multiple waits, depending on the number of session timeouts during that wait.

In which three scenarios would you recommend the use of the SQL Performance Analyzer?

• A.  to identify SQL statements in an application whose performance may have regressed due to migration from Oracle Database 11g to 12c
• B.  to analyze the impact of using bind variables for syntactically similar SQL statements
• C.  to analyze the impact of new indexes and materialized views on the SQL statements executed by an application
• D.  to identify SQL statements whose performance may have regressed due to a hardware upgrade
• E.  to analyze the impact of network and interconnect changes on database workload
• F.  to identify SQL statements that require SQL profiles

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

• A.  In V$SQL_MONITOR monitoring, statistics are cumulative over several executions of the SQL statement that is being monitored in a session.
• B.  SQL Developer can be used to view running database operations.
• C.  When the SQL statement that is being monitored is executing, V$SQL_MONITOR is refreshed once every minute. After the execution ends, the monitoring information in V$SQL_MONITOR is deleted immediately.
• D.  Oracle Enterprise Manager Cloud Control can be used to view running database operations.
• E.  Oracle Enterprise Manager Database Express can be used to view running database operations.

A parallel SQL statement is taking a long time to execute. You want to verify how the server processes are dividing work.
How should you determine this?

• A.  by using SQL Tuning Advisor
• B.  by using Real-Time ADDM
• C.  by using services
• D.  by using ASH
• E.  by using Real-Time SQL monitoring