Given the structure of the Student table:
Student (id INTEGER, name VARCHAR)

Given the records from the STUDENT table:
ID NAME
102 Edwin
103 Edward
103 Edwin

Given the code fragment:

Connection conn = DriverManager.getConnection(dbURL, userName, passWord);
Statement st = conn.createStatement();
String query = "SELECT * FROM Student WHERE id = 103";
System.out.println("Status: " + st.execute(query));

Assume that:
The required database driver is configured in the classpath.
The appropriate database is accessible with the dbURL, userName, and passWord exists.
What is the result?

Question

Given the structure of the Student table:
Student (id INTEGER, name VARCHAR)

Given the records from the STUDENT table:
ID NAME
102 Edwin
103 Edward
103 Edwin

Given the code fragment:

Connection conn = DriverManager.getConnection(dbURL, userName, passWord);
Statement st = conn.createStatement();
String query = "SELECT * FROM Student WHERE id = 103";
System.out.println("Status: " + st.execute(query));

Assume that:
The required database driver is configured in the classpath.
The appropriate database is accessible with the dbURL, userName, and passWord exists.
What is the result?

Accepted Answer

B. The program prints Status: false and two records are deleted from the Student table.

Answer

A. The program prints Status: true and two records are deleted from the Student table.

Answer

C. A SQLException is thrown at runtime.

Answer

D. The program prints Status: false but the records from the Student table are not deleted.

Given the structure of the Student table: Student (id INTEGER, name VARCHAR) Given the records from the STUDENT table: ID NAME 102 Edwin 103 Edward 103 Edwin Given the code fragment: Connection conn…

Question

Options

How the community answered

Explanation

Community Discussion