1D0-441 Question #113: Real Exam Question with Answer & Explanation

Consider the code fragment shown in the exhibit. 1. PreparedStatement ps = conn.prepareStatement 2. (INSERT INTO Orders VALUES (?, ?, ?, ?, ?)); 3. 4. ps.setInt(1, 3000); 5. ps.setString(2, 01-01-05); 6. ps.setInt(3, 1010); 7. ps.setInt(4, 200); 8. ps.setDouble(5, 1050.00); 9. 10. ps.setInt(1, 3001); 11. ps.setInt(3, 2010); 12. 13. ps.setInt(1, 3002); 14. ps.setInt(3, 3010); 15. ps.executeUpdate(); 16. 17. Statement s = conn.createStatement(); 18. ResultSet rs = s.executeQuery(SELECT * FROM Orders + 19. WHERE Sales_Rep_no = 200); 20. while(rs.next()) 21. { 22. System.out.print(rs.getString(Order_No) + ); 23. } Assume that variable conn references a valid and open Connection object to a database containing the Orders Relation (shown in the exhibit). Which output is generated?