123 need help with these questions in java :D

Match the JDBC driver type to its definition

Question 7 options:

a	translates JDBC to ODBC and relies on an ODBC driver to communicate with the database
b	a pure Java library that translates JDBC requests directly to a database-specific protocol
c	written partly in Java and partly in native code; it communicates with the client API of a database
d	a pure Java client library that uses a database-independent protocol to communicate database requests to a server component, which then translates the requests into a database-specific protocol

1.	Type 1
2.	Type 2
3.	Type 3
4.	Type 4

8.What is the principal benefit of structuring a relational database so that tables are joined to generate result sets?

a.it avoids unnecessary duplication of data

b.it produces more accurate query results

c.it results in increased database size

d.it enables query submission using HTTP

9.What type of vulnerability is commonly produced by concatenating user input as part of a SQL query?

a.none of these

b.SQL injection

c.stack smashing

d.PCI violation

e.password cracking

10.true or false? Using a PreparedStatement has no performance benefit compared to using a Statement.

11.The differences between a ResultSet and a RowSet are best described by which of the following statements?

a.The RowSet is tied to a database connection and consumes considerable memory and database resources while a ResultSet is not tied to a database and consumes less memory and no database resources.

b.There are no meaningful differences between a ResultSet and a RowSet.

c. none of these

d. The ResultSet provides faster access to results than the RowSet, but the ResultSet is more complex to manipulate.

e. The ResultSet is tied to a database connection and consumes considerable memory and database resources while a RowSet is not tied to a database and consumes less memory and no database resources.

12.If a database transaction fails part way through, it can be

a.none of these

b.eliminated

c.discarded

d.rolled back

e.frozen