Question 1

Given the code fragment:

Assume that:

The required database driver is configured in the classpath.

The appropriate database is accessible with the dbURL, userName, and passWord exists

The Employee table has a column ID of type integer and the SQL query matches one record.

What is the result?

Options :

A :

Compilation fails at line 14.

B :

Compilation fails at line 15.

C :

The code prints the employee ID.

D : The code prints Error.

Answer: A

Question 2

Given code of Test.java file:

package com.udayan.ocp;

import java.util.Arrays;

import java.util.List;

public class Test {

public static void main(String[] args) {

List list = Arrays.asList("A", "E", "I", "O");

list.add("U");

list.forEach(System.out::print);

}

What will be the result of compiling and executing Test class?

Options :

A : AEIOU

B : Runtime exception

C : Compilation error

D : UAEIO

E : AEIO

Answer: B

Question 3

Given the code fragment:

Path p1 = Paths.get(“/Pics/MyPic.jpeg”);

System.out.println (p1.getNameCount() +

“:” + p1.getName(1) +

“:” + p1.getFileName());

Assume that the Pics directory does NOT exist.

What is the result?

Options :

A : An exception is thrown at run time

B : 2:MyPic.jpeg: MyPic.jpeg

C : 3:.:MyPic.jpeg

D : 2:Pics: MyPic.jpeg

Answer: B

Question 4

Given the code fragment:

9. Connection conn = DriveManager.getConnection(dbURL, userName, passWord);

10. String query = “SELECT id FROM Employee”;

11. try (Statement stmt = conn.createStatement()) {

12. ResultSet rs = stmt.executeQuery(query);

13. stmt.executeQuery(“SELECT id FROM Customer”);

14. while (rs.next()) {

15. //process the results

16. System.out.println(“Employee ID: “+ rs.getInt(“id”));

17. }

18. } catch (Exception e) {

19. System.out.println (“Error”);

20. }

Assume that:

The required database driver is configured in the classpath.

The appropriate database is accessible with the dbURL, userName, and passWord exists.

The Employee and Customer tables are available and each table has id column with a few records and

the SQL queries are valid.

What is the result of compiling and executing this code fragment?

Options :

A : The program prints employee IDs.

B : The program prints customer IDs

C : The program prints Error

D : compilation fails on line 13.

Answer: C

Question 5

Given the code fragment:

Stream<Path> files = Files.list(Paths.get(System.getProperty(“user.home”)));

files.forEach (fName -> { //line n1

try {

Path aPath = fName.toAbsolutePath(); //line n2

System.out.println(fName + “:”

+ Files.readAttributes(aPath,

Basic.File.Attributes.class).creationTime

());

} catch (IOException ex) {

ex.printStackTrace();

});

What is the result?

Options :

A :

All files and directories under the home directory are listed along with their attributes.

B : A compilation error occurs at line n1.

C : The files and folders in the home directory are listed along with their attributes.

D : A compilation error occurs at line n2.

Answer: C

Free 1Z0-809 Mock Exam – Practice Online Confidently

Buying Options: