On the kindle version of the OCP JP8 study Guide book, question 18 has A as the answer. (Same in the questions in Sybex)
But the answer is E because the statement was not set to be TYPE_SCROLL_INSENSITIVE or sensitive.
Using conn.createStatement() creates a statement with the default behavior TYPE_FORWARD_ONLY.