Assume db is a DataSource and the EMP table is defined appropriately.

try (Connection conn = ds.getConnection();
PreparedStatement ps = conn.prepareStatement("INSERT INTO EMP VALUES(?, ?, ?)")) {
ps.setObject(1, 101, JDBCType.INTEGER);
ps.setObject(2, "SMITH", JDBCType.VARCHAR);
ps.setObject(3, "HR", JDBCType.VARCHAR);
ps.executeUpdat e();
ps.setint(1, 102);
ps.setString(2, "JONES");
ps.executeUpdate();
}

What does executing this code fragment do?

Question

Assume db is a DataSource and the EMP table is defined appropriately.

try (Connection conn = ds.getConnection();
 PreparedStatement ps = conn.prepareStatement("INSERT INTO EMP VALUES(?, ?, ?)")) {
 ps.setObject(1, 101, JDBCType.INTEGER);
 ps.setObject(2, "SMITH", JDBCType.VARCHAR);
 ps.setObject(3, "HR", JDBCType.VARCHAR);
 ps.executeUpdat e();
 ps.setint(1, 102);
 ps.setString(2, "JONES");
 ps.executeUpdate();
}

What does executing this code fragment do?

Accepted Answer

C. Inserts one row (101, 'SMITH', 'HR')

Answer

A. Inserts two rows (101, 'SMITH', 'HR') and (102, 'JONES', NULL)

Answer

B. Inserts two rows (101, 'SMITH', 'HR') and (102, 'JONES', 'HR')

Answer

D. Throws a SQL Exception

Assume db is a DataSource and the EMP table is defined appropriately. try (Connection conn = ds.getConnection(); PreparedStatement ps = conn.prepareStatement("INSERT INTO EMP VALUES(?, ?, ?)")) {…

Question

Options

How the community answered

Community Discussion