Refer to the exhibit to answer the question.
Consider the Products relation defined in the exhibit. Which of the following Java code segments
creates a prepared statement that could be used to produce a result set containing all of the
products that cost more than $2.00 and are priced less than $20 assuming con references a valid
and open Connection object?
A.
PreparedStatement ps = con.createStatement(
“SELECT * FROM Products WHERE ” +
“Cost > ? AND Price < ?”);
B.
PreparedStatement ps = con.preparedStatement(
“SELECT * FROM Products WHERE ” +
“Cost > ? AND Price < ?”);
C.
PreparedStatement ps = new PreparedStatement(
“SELECT * FROM Products WHERE ” +
“Cost > ? AND Price < ?”);
D.
PreparedStatement ps = con.prepareCall(
“SELECT * FROM Products WHERE ” +
“Cost > ? AND Price < ?”);
E.
PreparedStatement ps = con.prepareStatement(
“SELECT * FROM Products WHERE ” +
“Cost > ? AND Price < ?”);