フリー問題

問題文

An application builds its statement text by pasting the search value straight into the text, so almost every submission is a new string. Which part of the shared area suffers and why?

選択肢

1. The buffer cache suffers because each new string reads a different set of blocks and the blocks that were read earlier are pushed out before reuse.
2. The redo log buffer suffers because each new string is written to it before execution and that space stays held until a commit.
3. The result cache suffers because each new string produces a separate entry and the entries that are held are then invalidated by the next change to the data.
4. The library cache suffers because each new string has to be optimized from scratch and the form that results sits in the shared area so it is rarely reused.