Online Access Free 1z0-809 Practice Test

Given the records from the Employee table:

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 passWord exists.
What is the result?

• A.The program prints Exception is raised.
• B.The Employee table is updated with the row:112 Jackand the program prints:112 Jack
• C.The Employee table is not updated and the program prints:112 Jerry
• D.The Employee table is updated with the row:112 Jackand the program prints:112 Jerry

Given the code fragment:
LocalDate valentinesDay =LocalDate.of(2015, Month.FEBRUARY, 14);
LocalDate nextYear = valentinesDay.plusYears(1);
nextYear.plusDays(15); //line n1
System.out.println(nextYear);
What is the result?

• A.2016-02-14
• B.2016-02-29
• C.A compilation error occurs at line n1.
• D.A DateTimeException is thrown.

Given:

What is the result?

• A.A compilation error occurs.
• B.A NullPointerException is thrown at run time.
• C.IT:0.0
• D.IT:null

Given the code fragment:
List<String> str = Arrays.asList ("my", "pen", "is", "your', "pen");
Predicate<String> test = s -> {
int i = 0;
boolean result = s.contains ("pen");
System.out.print(i++) + ":");
return result;
};
str.stream()
.filter(test)
.findFirst()
.ifPresent(System.out ::print);
What is the result?

• A.0 : 0 : 0 : 0 : 0 : pen
• B.A compilation error occurs.
• C.0 : 1 : 2 : 3 : 4 :
• D.0 : 1 : pen
• E.0 : 0 : pen

Given:
interface Doable {
public void doSomething (String s);
}
Which two class definitions compile? (Choose two.)

• A.public class Job implements Doable {public void doSomething(Integer i) { }}
• B.public abstract class Task implements Doable {public void doSomethingElse(String s) { }}
• C.public class Action implements Doable {public void doSomething(Integer i) { }public String doThis (Integer j) { }}
• D.public class Do implements Doable {public void doSomething(Integer i) { }public void doSomething (String s) { }public void doThat (String s) { }}
• E.public abstract class Work implements Doable {public abstract void doSomething(String s) { }public void doYourThing(Boolean b) { }}