COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Yes, but only if you call the method openCursor() on the ResultSet, and if the driver and database support this option
|
|
|
Yes, but only if you indicate a concurrency strategy when executing the statement, and if the driver and database support this option
|
|
|
Yes, but only if the ResultSet is an object of class UpdateableResultSet, and if the driver and database support thisoption
|
|
|
No, ResultSets are never updateable. You must explicitly execute DML statements (i.e. insert, delete and update) to change the data in the underlying database
|
Detailed explanation-1: -Q 10-Which of the following is correct about ResultSet class of JDBC? A-ResultSet holds data retrieved from a database after you execute an SQL query using Statement objects.
Detailed explanation-2: -CONCUR READ ONLY means that the ResultSet can only be read. CONCUR UPDATABLE means that the ResultSet can be both read and updated.
Detailed explanation-3: -22) Which of the following is the correct to register a JdbcOdbcDriver? Explanation: By creating an object to the driver class of the driver software, we can register the driver.
Detailed explanation-4: -Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection? No. You can open only one Statement object per connection when you are using the JDBC-ODBC Bridge.