Question 16

Given the code fragments:

and

What is the result?
  • Question 17

    Given:

    And given the code fragment:

    What is the result?
  • Question 18

    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.getString(1));
    16.System.out.println("Description:" + rs.getString(2));
    17.System.out.println("Price:" + rs.getString(3));
    18. System.out.println(Quantity:" + rs.getString(4));
    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?
  • Question 19

    Given the records from the Employeetable:

    and given the code fragment:
    try {
    Connection conn = DriverManager.getConnection (URL, userName,
    passWord);
    Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
    ResultSet.CONCUR_UPDATABLE);
    st.execute("SELECT*FROM Employee");
    ResultSet rs = st.getResultSet();
    while (rs.next()) {
    if (rs.getInt(1) ==112) {
    rs.updateString(2, "Jack");
    }
    }
    rs.absolute(2);
    System.out.println(rs.getInt(1) + " " + rs.getString(2));
    } catch (SQLException ex) {
    System.out.println("Exception is raised");
    }
    Assume that:
    The required database driver is configured in the classpath.
    The appropriate database accessible with the URL, userName, and passWordexists.
    What is the result?
  • Question 20

    Given the code fragment:
    public class StringReplace {
    public static void main(String[] args) {
    String message = "Hi everyone!";
    System.out.println("message = " + message.replace("e", "X")); }
    }
    What is the result?