123 need help with these questions in java :D Match the JDBC driver type to its
ID: 3822036 • Letter: 1
Question
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
Type 1
Type 2
Type 3
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
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
Explanation / Answer
7)
TYPE 1 driver
translates JDBC to ODBC and relies on an ODBC driver to communicate with the database
TYPE 2 Driver
written partly in Java and partly in native code; it communicates with the client API of a database
TYPE 3 Driver
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
TYPE 4 DRIVER
a pure Java library that translates JDBC requests directly to a database-specific protocol
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
9)
.What type of vulnerability is commonly produced by concatenating user input as part of a SQL query?
b.SQL injection
10)
Using a PreparedStatement has no performance benefit compared to using a Statement.
False
Preparedstatement is better than Statemnt performance wise
11)
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)
Elimnated
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.