Online 1Z0-809 Practice Test

Question 1

Which of the following code will create/return a Locale object for the JVM, on which your code is running?

Options :

A : System.getDefault();

B : Locale.getDefault();

C : Locale.getLocale();

D : Locale.getDefaultLocale();

Answer: B

Question 2

Assume that proper import statements are available, and 'fr' is the language code for French language.

And you have the following code snippet:

Locale [] loc = Locale.getAvailableLocales();

Which of the following statements will print all the supported (by the JVM) French Language Locale on to the console?

Select 2 options.

Options :

A : Arrays.stream(loc).filter(x -> x.getLanguage().contains("FR")).forEach(System.out::println);

B : Arrays.stream(loc).filter(x -> x.toString().contains("FR")).forEach(System.out::println);

C : Arrays.stream(loc).filter(x -> x.getLanguage().equals("fr")).forEach(System.out::println);

D : Arrays.stream(loc).filter(x -> x.toString().startsWith("fr")).forEach(System.out::println);

E : Arrays.stream(loc).filter(x -> x.startsWith("fr")).forEach(System.out::println);

Answer: C,D

Question 3

Given the code fragments:

and

What is the result?

Options :

A : null

B : A compilation error occurs.

C : DogCatMouse

D : [Dog, Cat, Mouse]

Answer: D

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 structure of EMPLOYEE table:

EMPLOYEE (ID integer, FIRSTNAME varchar(100), LASTNAME varchar(100), SALARY real, PRIMARY KEY (ID))

EMPLOYEE table contains below records:

1. 101 John Smith 12000

2. 102 Sean Smith 15000

3. 103 Regina Williams 15500

4. 104 Natasha George 14600

Given code of Test.java file:

1. package com.udayan.ocp;

2.

3. import java.sql.*;

4. import java.util.Properties;

5.

6. public class Test {

7. public static void main(String[] args) throws Exception {

8. String url = "jdbc:mysql://localhost:3306/ocp";

9. Properties prop = new Properties();

10. prop.put("user", "root");

11. prop.put("password", "password");

12. String query = "Select ID, FIRSTNAME, LASTNAME, SALARY FROM EMPLOYEE ORDER BY ID";

13. try (Connection con = DriverManager.getConnection(url, prop);

14. Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

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

16. {

17. rs.afterLast();

18. rs.relative(-1);

19. rs.previous();

20. System.out.println(rs.getInt(1));

21. }

22. }

23. }

Also assume:

URL, username and password are correct.

SQL query is correct and valid.

The JDBC 4.2 driver jar is configured in the classpath.

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

Options :

A : 103

B : 102

C : 104

D : 101

Answer: A

EXPERTY DESIGNED 1Z0-809 PRACTICE TEST