Oracle 1z1-809 : Java SE 8 Programmer II

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 Employee table is not updated and the program prints:112 Jerry
• B. The Employee table is updated with the row:112 Jackand the program prints:112 Jerry
• C. The program prints Exception is raised.
• D. The Employee table is updated with the row:112 Jackand the program prints:112 Jack

Given the EMPLOYEE table;

Given the code fragment:

Assuming the database supports scrolling and updating, what is the result?

• A. A new record is inserted and Employee Id: 102, Employee Name: Peter is displayed.
• B. A new record is inserted and Employee Id: 104, Employee Name: Michael is displayed.
• C. A compilation error occurs.
• D. The program throws a runtime exception at Line 1.

Given the code fragments:
class Caller implements Callable<String> {
String str;
public Caller (String s) {this.str=s;}
public String call()throws Exception { return str.concat ("Caller");}
}
class Runner implements Runnable {
String str;
public Runner (String s) {this.str=s;}
public void run () { System.out.println (str.concat ("Runner"));}
}
and
public static void main (String[] args) InterruptedException, ExecutionException { ExecutorService es = Executors.newFixedThreadPool(2); Future f1 = es.submit (new Caller ("Call")); Future f2 = es.submit (new Runner ("Run")); String str1 = (String) f1.get(); String str2 = (String) f2.get();//line n1 System.out.println(str1+ ":" + str2);
}
What is the result?

• A. An Execution is thrown at run time.
• B. The program prints:Run RunnerCall Caller : nullAnd the program does not terminate.
• C. A compilation error occurs at line n1.
• D. The program terminates after printing:Run RunnerCall Caller : Run

Given the code fragment:
Path file = Paths.get ("courses.txt");
// line n1
Assume the courses.txt is accessible.
Which code fragment can be inserted at line n1 to enable the code to print the content of the courses.txt file?

• A. Stream<String> fc = Files.lines (file);fc.forEach (s - > System.out.println(s));
• B. Stream<String> fc = Files.readAllLines (file);fc.forEach (s - > System.out.println(s));
• C. List<String> fc = Files.list(file);fc.stream().forEach (s - > System.out.println(s));
• D. List<String> fc = readAllLines(file);fc.stream().forEach (s - > System.out.println(s));

Given the code fragment:

What is the result?

• A. [text1, text2]
• B. text1text2text2text3
• C. text1
• D. text1text2