問題文
Two sessions submit text that is character for character identical. The first submission causes a hard parse and the second one does not. Which step of statement processing is skipped on the second submission?
選択肢
- The syntax check and the semantic check are skipped because the text has already been proved to be well formed by the earlier submission.
- The fetch step is skipped because the rows produced by the earlier submission are still held in the shared area and can be returned again.
- The bind step is skipped because the values supplied by the earlier submission are remembered and applied to the second submission as well.
- The optimization step and the generation of the row sources are skipped because the database can reuse the executable form that already sits in the shared area.