1Z0_064 questions • Exam prepare

Exam contains 84 questions

Page 14 of 14

Question 79 🔥

Your database supports an online transaction processing (OLTP) workload. The database uses ASM storage. One of the ASM disks goes offline because of hardware failure. When the disk is replaced and then added back to the diskgroup, database performance is affected by rebalance operations.Which two actions would you recommend to lower the impact of rebalance operations on the performance of the database? (Choose two.)

Which database solution meets these requirements?

A. Increase the number of ASMB processes.

B. Decrease the value of the ASM_POWER_LIMIT parameter.

C. Set the DISK_REPAIR_TIME disk attribute to a lower value.

D. Specify the POWER clause with a lower value in an ALTER DISKGROUP statement.

E. Set the DISK_REPAIR_TIME disk attribute to a higher value.

Discussion of the question

Question 80 🔥

Examine the parameters:Your database supports a mixed workload and users have dedicated server connections. Users complain about the increased response time of a few queries that are performing large sort operations. On investigation, you notice an increase in the number of multipass work area executions and high number of direct path wait events. writeWhich two actions could improve the performance? (Choose two.)

Which database solution meets these requirements?

A. increasing the value of the SORT_AREA_SIZE parameter

B. increasing the value of the PGA_AGGREGATE_TARGET parameter

C. enabling Automatic Memory Management for the instance

D. increasing the size of the default temporary tablespace

E. using parallel hint in queries performing large sort operations

F. enabling Automatic Shared Memory Management for the instance

Discussion of the question

Question 81 🔥

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

Which database solution meets these requirements?

A. They are always logged in the alert log.

B. They are written to a trace file if the TRACE_ENABLED initialization parameter is set to TRUE.

C. They are generated only when the STATISTICS_LEVEL initialization parameter is set to ALL.

D. They can be generated for user-defined metric thresholds.

E. They appear in the DBA_ALERT_HISTORY view whenever corrective action is taken for an alert.

Discussion of the question

Question 82 🔥

Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are competing for resources? (Choose four.)

Which database solution meets these requirements?

A. distributing available CPU by allocating percentages of CPU time to different users and applications

B. limiting the degree of parallelism of any operation performed by members of a group of users

C. limiting queries based on resource consumption of runaway sessions or calls that consume more than a specified amount of CPU, physical I/O, logical I/O, or elapsed time

D. limiting the number of concurrent sessions for a user

E. limiting the number of user sessions allowed to be concurrently active within a group of users

F. limiting the number of parallel executions that can be executed by a user

Discussion of the question

Question 83 🔥

Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)

Which database solution meets these requirements?

A. A high value indicates that the buffer cache is adequately sized for the current workload.

B. Poor hit ratios indicate that a large number of indexed lookups or small table scans are being performed.

C. A low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve performance.

D. A high hit ratio may indicate that repeated scanning of the same large table or index is being performed.

E. A low hit ratio indicates that a KEEP buffer pool should be configured based on the size of the largest object accessed in the buffer cache.

Discussion of the question

Question 84 🔥

Examine the Load Profile section of an AWR report:Which two inferences can you derive from the details in this section? (Choose two.)

Which database solution meets these requirements?

A. The values for Redo size and Block changes imply that only updates were performed by transactions.

B. The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.

C. The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.

D. The values for SQL Work Area and User calls imply that only sort-based operations were performed.

E. The values for Logical reads and Physical reads imply that the number of disk reads per second was less than the total number of DB block reads and

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_064

Exam contains 84 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us