Given the records from the STUDENTtable:

Given the code fragment:

Assume that the URL, username,and passwordare valid.
What is the result?

• A.The STUDENTtable is updated with the record:
  1 13 : Jannet : [email protected]
  and the program prints:
  1 13 : Jannet : [email protected]
• B.A SQLExceptionis thrown at run time.
• C.The STUDENTtable is updated with the record:
  1 13 : Jannet : [email protected]
  and the program prints:
  1 14 : John : [email protected]
• D.The STUDENT table is not updated and the program prints:
  1 14 : John : [email protected]

Comment: *

Name: *

Email: *

Verification: *

Given the code fragment:

What is the result?

• A.3
• B.A compilation error occurs at line n2.
• C.A compilation error occurs at line n1.
• D.2

Comment: *

Name: *

Email: *

Verification: *

Given the structure of the STUDENT table:
Student (id INTEGER, name VARCHAR)
Given:
public class Test {
static Connection newConnection =null;
public static Connection get DBConnection () throws SQLException {
try (Connection con = DriveManager.getConnection(URL, username, password)) { newConnection = con;
}
return newConnection;
}
public static void main (String [] args) throws SQLException {
get DBConnection ();
Statement st = newConnection.createStatement();
st.executeUpdate("INSERT INTO student VALUES (102, 'Kelvin')");
}
}
Assume that:
The required database driver is configured in the classpath.
The appropriate database is accessible with the URL, userName, and passWord exists.
The SQL query is valid.
What is the result?

• A.The program executes successfully and the STUDENT table is NOT updated with any record.
• B.The program executes successfully and the STUDENT table is updated with one record.
• C.A NullPointerException is thrown as runtime.
• D.A SQLException is thrown as runtime.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which code fragment is required to load a JDBC 3.0 driver?

• A.Connection con = Connection.getDriver
  ( "jdbc:xyzdata://localhost:3306/EmployeeDB");
• B.Class.forName("org.xyzdata.jdbc.NetworkDriver");
• C.Connection con = DriverManager.getConnection
  ("jdbc:xyzdata://localhost:3306/EmployeeDB");
• D.DriverManager.loadDriver ("org.xyzdata.jdbc.NetworkDriver");

Comment: *

Name: *

Email: *

Verification: *