Oracle
1Z0-054 · Question #109
You observed in your database that the queries formerly executed in 5 seconds now take longer time. View the Exhibit and analyze the output of the query that you executed to find the problem. Which…
The correct answer is C. the number of chained and migrated rows. See the full explanation below for the reasoning.
Question
You observed in your database that the queries formerly executed in 5 seconds now take longer time. View the Exhibit and analyze the output of the query that you executed to find the problem. Which is the primary concern?
Options
- Athe number of disk sorts
- Bthe number of full table scans
- Cthe number of chained and migrated rows
- Dthe number of rows fetched based on rowid
How the community answered
(23 responses)- A4% (1)
- B9% (2)
- C74% (17)
- D13% (3)
Community Discussion
No community discussion yet for this question.