1z0-809 Exam Question 116

Given the structure of the STUDENT table:
Student (id INTEGER, name VARCHAR)
Given:
public class Test {
static Connection newConnection =null;
public static Connection get DBConnection () throws SQLException {
try (Connection con = DriveManager.getConnection(URL, username, password)) { newConnection = con;
}
return newConnection;
}
public static void main (String [] args) throws SQLException {
get DBConnection ();
Statement st = newConnection.createStatement();
st.executeUpdate("INSERT INTO student VALUES (102, 'Kelvin')");
}
}
Assume that:
The required database driver is configured in the classpath.
The appropriate database is accessible with the URL, userName, and passWord exists.
The SQL query is valid.
What is the result?
  • 1z0-809 Exam Question 117

    Given:
    class ImageScanner implements AutoCloseable {
    public void close () throws Exception {
    System.out.print ("Scanner closed.");
    }
    public void scanImage () throws Exception {
    System.out.print ("Scan.");
    throw new Exception("Unable to scan.");
    }
    }
    class ImagePrinter implements AutoCloseable {
    public void close () throws Exception {
    System.out.print ("Printer closed.");
    }
    public void printImage () {System.out.print("Print."); }
    }
    and this code fragment:
    try (ImageScanner ir = new ImageScanner();
    ImagePrinter iw = new ImagePrinter()) {
    ir.scanImage();
    iw.printImage();
    } catch (Exception e) {
    System.out.print(e.getMessage());
    }
    What is the result?
  • 1z0-809 Exam Question 118

    Which statement is true about the single abstract method of the java.util.function.Function interface?
  • 1z0-809 Exam Question 119

    Given the code fragment:
    ZonedDateTime depart = ZonedDateTime.of(2015, 1, 15, 3, 0, 0, 0, ZoneID.of("UTC-
    7"));
    ZonedDateTime arrive = ZonedDateTime.of(2015, 1, 15, 9, 0, 0, 0, ZoneID.of("UTC-
    5"));
    long hrs = ChronoUnit.HOURS.between(depart, arrive); //line n1
    System.out.println("Travel time is" + hrs + "hours");
    What is the result?
  • 1z0-809 Exam Question 120

    Given the records from the STUDENT table:

    Given the code fragment:

    Assume that the URL, username, and password are valid.
    What is the result?