1Z0-809 practice question 21 of 25

Given: Item table • ID, INTEGER: PK • DESCRIP, VARCHAR(100) • PRICE, REAL • QUANTITY< INTEGER And given the code fragment: 9. try { 10.Connection…

Choose your answer, then check it against the explanation.

Given: Item table • ID, INTEGER: PK • DESCRIP, VARCHAR(100) • PRICE, REAL • QUANTITY< INTEGER And given the code fragment: 9. try { 10.Connection conn = DriveManager.getConnection(dbURL, username, password); 11. String query = “Select * FROM Item WHERE ID = 110”; 12. Statement stmt = conn.createStatement(); 13. ResultSet rs = stmt.executeQuery(query); 14.while(rs.next()) { 15.System.out.println(“ID:“ + rs.getInt(“Id”)); 16.System.out.println(“Description:“ + rs.getString(“Descrip”)); 17.System.out.println(“Price:“ + rs.getDouble(“Price”)); 18. System.out.println(Quantity:“ + rs.getInt(“Quantity”)); 19.} 20. } catch (SQLException se) { 21. System.out.println(“Error”); 22. } Assume that: The required database driver is configured in the classpath. The appropriate database is accessible with the dbURL, userName, and passWord exists. The SQL query is valid. What is the result?
Answer options
Question 21 of 25

Keep practicing

Take the free 1Z0-809 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test

More questions

Other 1Z0-809 practice questions

Scroll to Top