Free Oracle 1z1-064 Exam Dumps Questions & Answers

In which three situations can dynamic statistics be used? (Choose three.)

• A.  when extended statistics are not available for SQL statements that use complex predicates
• B.  when a query is on a partitioned table with a global index
• C.  when the sampling time is a small fraction of the total time for a query
• D.  when index statistics are missing on a column that is used in SQL statements with highly selective filters
• E.  when an execution plan is suboptimal because of complex predicates

You are administrating a database that supports a mixed workload. Given are the details of the workload:
During the day, short transactions and syntactically similar queries are repeatedly issued.
At night, DSS batch queries and jobs are executed with large sort operations.
Examine the parameters set for the database instance:

To automate memory requirements for both workloads, which three changes to parameters would you recommend?

• A.  Set the SGA_TARGET parameter to the value of the SGA_MAX_SIZE parameter.
• B.  Set the MEMORY_TARGET parameter to the value of SGA_MAX_SIZE.
• C.  Set DB_CACHE_SIZE, SHARED_POOL_SIZE, and LARGE_POOL_SIZE to their minimum required values.
• D.  Set the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to a value greater than the sum of SGA_MAX_SIZE and PGA_AGGREGATE_TARGET.
• E.  Set the SGA_TARGET and PGA_AGGREGATE_TARGET parameters to their minimum required values.

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 alert information when either the warning or the critical threshold is exceeded? (Choose two.)

• A.  DBA_ACTIVE_SESSION_HISTORY
• B.  Oracle Enterprise Manager Cloud Control
• C.  DBA_OUTSTANDING_ALERTS
• D.  DBA_ALERT_HISTORY
• E.  DBA_THRESHOLDS
• F.  the alert log

Examine the partial Activity Over Time section of an Active Session History (ASH) report:

Which two inferences are correct? (Choose two.)

• A.  In the second time slot, out of the nine sampled sessions connected to the database instance, only one sampled session was idle at the time of report generation.
• B.  In the first time slot, only one sampled session was using the CPU.
• C.  In the second time slot, five different sampled sessions were using the CPU.
• D.  In the first time slot, five different sampled sessions were connected to the database instance.
• E.  In the second time slot, 0.14% of the time was spent on the CPU.

As part of an application upgrade, new objects are being added to an application schem a. You want to check the effect of the new schema objects on the performance of the SQL workload generated by the application.
How would you accomplish this?

• A.  Capture the workload in an STS and submit to SQL Access Advisor as an input to generate recommendations for indexes and materialized views.
• B.  Capture the workload, set the OPTIMIZER_USE_PENDING_STATISTICS to FALSE, and then replay the workload.
• C.  Set the PUBLISH statistic preference to FALSE, gather statistics, capture the workload in a SQL Tuning Set (STS), and submit the STS to SQL Tuning Advisor.
• D.  Capture the workload in an STS and submit to SQL Tuning Advisor as an input to generate recommendations for indexes and SQL profiles.