Java SE 8 Programmer II: Answer to Question from Exam 1Z0-809 | Page

Java SE 8 Programmer II: Answer

Prev Question Next Question

Question

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?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

D.

The given code fragment attempts to retrieve information from the "Item" table in a database using a SQL SELECT statement. The SELECT statement retrieves all the columns of a row in the "Item" table where the "ID" column has a value of 110.

Here's a line-by-line explanation of the code:

  1. The try-catch block is used to handle any exceptions that might occur during the execution of the code.
  2. The Connection object is obtained by calling the static method DriverManager.getConnection(), which returns a Connection object that represents a connection to the database. The dbURL, username, and password are passed as arguments to this method. If the connection cannot be established, a SQLException is thrown.
  3. A String variable query is declared and initialized with a SQL SELECT statement that retrieves all the columns of a row in the "Item" table where the "ID" column has a value of 110.
  4. A Statement object stmt is created using the Connection.createStatement() method, which returns a Statement object that can be used to execute SQL queries. If the statement cannot be created, a SQLException is thrown.
  5. The executeQuery() method of the Statement object is called with the SQL query passed as an argument. This method returns a ResultSet object that contains the data produced by the query. If the query cannot be executed, a SQLException is thrown.
  6. A while loop is used to iterate through the ResultSet object. The rs.next() method moves the cursor to the next row in the ResultSet object, and returns true if there are more rows, or false if there are no more rows. The while loop continues as long as there are more rows.
  7. The getInt() method of the ResultSet object is called with the column name "Id" to retrieve the value of the "ID" column in the current row, and this value is printed to the console.
  8. The getString() method of the ResultSet object is called with the column name "Descrip" to retrieve the value of the "DESCRIP" column in the current row, and this value is printed to the console.
  9. The getDouble() method of the ResultSet object is called with the column name "Price" to retrieve the value of the "PRICE" column in the current row, and this value is printed to the console.
  10. The getInt() method of the ResultSet object is called with the column name "Quantity" to retrieve the value of the "QUANTITY" column in the current row, and this value is printed to the console.
  11. The end of the while loop is reached.
  12. The end of the try block is reached.
  13. If a SQLException is thrown during the try block, it is caught by the catch block and the message "Error" is printed to the console.
  14. The end of the catch block is reached.

Based on the given assumptions, there are no syntax errors in the code and the SQL query is valid. Therefore, if the "Item" table exists in the database, and there is a row with an "ID" column value of 110, then the code will print the information about that row, including the "ID", "DESCRIP", "PRICE", and "QUANTITY" columns. If the "Item" table does not exist in the database, or there is no row with an "ID" column value of 110, then the code will not print anything. If there is an error during the execution of the code, then the message "Error" will be printed to the console.

Therefore, the answer to the question is D: The code prints information about Item 110, assuming that the "Item" table exists in the database and there is a row

Prev Question Next Question