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?
Given code of Test.java file:
1. package com.udayan.ocp;
2.
3. public class Test {
4. private static void div(int i, int j) {
5. try {
6. System.out.println(i / j);
7. } catch(ArithmeticException e) {
8. throw (RuntimeException)e;
9. }
10. }
11. public static void main(String[] args) {
12. try {
13. div(5, 0);
14. } catch(ArithmeticException e) {
15. System.out.println("AE");
16. } catch(RuntimeException e) {
17. System.out.println("RE");
18. }
19. }
20. }
What will be the result of compiling and executing Test class?
Given code of Test.java file:
1. package com.udayan.ocp;
2.
3. public class Test {
4. private static String msg = "Hello";
5.
6. private static String changeMsg(String m) {
7. msg = m;
8. return null;
9. }
10.
11. public static void main(String[] args) {
12. if(args.length == 0) {
13. assert false : changeMsg("Bye");
14. }
15. System.out.println(msg);
16. }
17. }
What will be the result of executing Test class with below command?
java -ea com.udayan.ocp.Test
Below is the code of Test.java file:
1. package com.udayan.ocp;
2.
3. class Outer {
4. static class Inner {
5. static void greetings(String s) {
6. System.out.println(s);
7. }
8. }
9. }
10.
11. public class Test {
12. public static void main(String[] args) {
13. /*INSERT*/
14. }
15. }
Which of the following 2 options can replace /*INSERT*/ such that there on executing class Test, output is: HELLO!?
© Copyrights Oracledumps 2025. All Rights Reserved
We use cookies to ensure that we give you the best experience on our website (Oracledumps). If you continue without changing your settings, we'll assume that you are happy to receive all cookies on the Oracledumps.
