-
Two parts of JDBC 2.0 API are The JDBC 2.0 core API (the java.sql package), which is included in the JavaTM 2 SDK, Standard Edition The JDBC 2.0 Optional Package API (the javax.sql package), which is available separately or as part of the Java 2 SDK, Enterprise Edition State true or false for the above both points
A) TrueB) FalseExplanation: The JDBC 2.0 API is the latest update of the JDBC API. It contains many new features, including scrollable result sets and the new SQL:1999 (formerly SQL 3) data types.
-
State true or false :- ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
A) TrueB) FalseExplanation: This is the new feature in the JDBC 2.0 API usage is Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
anitpatel
- Nov 6th, 2009
True. One has to call insertRow() programmatically to get the resultset data changes reflected in database. The CONCUR_UPDATABLE implementation can be driver specific. If driver does not support this mode of update, it will not allow the resultset update.
-
What’s the difference between TYPE_SCROLL_INSENSITIVE , and TYPE_SCROLL_SENSITIVE?
A) A result set that is TYPE_SCROLL_INSENSITIVE does not reflect changes made while it is still open and one that is TYPE_SCROLL_SENSITIVE does.B) Both types of result sets will make changes visible if they are closed and then reopened.C) You will get a scrollable ResultSet object if you specify one of these ResultSet constants.D) A result set that is TYPE_SCROLL_INSENSITIVE makes the result set read...
vk payne
- Feb 8th, 2013
A,B and D
All the three are correct
-
Which of the following values can be replaced in the place of 1 and 2 belowStatement stmt = con.createStatement(1, 2);
A) ResultSet. TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLYB) ResultSet. TYPE_SCROLL_INSENSITIVE , ResultSet. CONCUR_UPDATABLEC) ResultSet. CONCUR_UPDATABLE,ResultSet. TYPE_SCROLL_SENSITIVED) ResultSet. CONCUR_UPDATABLE,ResultSet. TYPE_FORWARD_ONLY
sravan
- Jun 30th, 2006
A and Bbecause, the createStatement() method takes ResultSet Type as 1st argument and concurrency as 2nd argument. we cannot alter this.
-
State true or false :-The new features in the JDBC 2.0 API is the ability to move a result set’s cursor backward as well as forward.
A) TrueB) FalseExplanation: There are also methods that let you move the cursor to a particular row and check the position of the cursor
