ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-064 All Questions

View all questions & answers for the 1z0-064 exam
Go to Exam

Exam 1z0-064 topic 1 question 2 discussion

Actual exam question from Oracle's 1z0-064
Question #: 2
Topic #: 1
[All 1z0-064 Questions]

Examine the partial TKPROF output for an SQL statement:

Which two inferences can definitely be made from this output? (Choose two.)

  • A. Array fetch operations were not performed for this query.
  • B. No hard parse was performed for this query.
  • C. The number of logical I/Os is almost equal to the number of physical I/Os.
  • D. Another transaction held a shared lock on the table, thereby causing a significant delay.
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
by adz07 at Dec. 14, 2023, 4:42 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
adz07
1 year ago
Selected Answer: AB
i think AB A. since Fetch count is 1 and rows retrieved is 1 B. No hard parse since there is 0 misses in library cache https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/performing-application-tracing.html#GUID-16256746-D82C-46DF-8EE0-B4230C22C723
upvoted 1 times
...
adz07
1 year, 1 month ago
hmmmm i'm not sure with D, how can you say that the cause of delay is due to shared lock.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago