Oracle Exam 1Z0-064 Topic 3 Question 20 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 20
Topic #: 3

Examine the Load Profile section of an AWR report:

Which two inferences can you derive from the details in this section? (Choose two.)

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

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

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

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

EThe 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 consistent gets per second.

Show Suggested Answer

Suggested Answer: B, D

by Louisa at May 04, 2022, 10:57 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-064 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!