Refer to the exhibit to answer the question.
Consider the Products relation defined in the exhibit. What is the result of attempting to execute
the following Java code segment assuming con is a valid reference to an open Connection object?
1. PreparedStatement ps = con.prepareStatement(
2. “SELECT * FROM Products WHERE ” +
3. “Cost < ?”);
4.
5. ps.setDouble(0, 10f);
6.
7. ResultSet rs = ps.executeUpdate();
8. rs.next();
9. System.out.print(rs.getString(1));
10. System.out.println(rs.getString(2));
A.
The code segment displays “Flyback Transformer 8.0”.
B.
No output is displayed due to a runtime error.
C.
The code segment displays “1001 Flyback Transformer”.
D.
The code segment displays “1004 Grounding Strap”.
E.
The code segment displays “Grounding Strap 0.15”.