JAVA JDBC

This is the correct choice because moveToCurrentRow() method is present in the Result Set interface. This method moves the cursor to the remembered cursor position, usually the current row.

executeBatch() method is present in the Statement interface and not in PreparedStatement interface and it submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. So, this answer is true.

isCloseOnCompletion() method is present in the Statement interface. This method returns a value indicating whether this statement will be closed when all its dependent result sets are closed or not. So, this answer is correct.

getColumnTypeName(int column) method is present in ResultSetMetaData interface and it retrieves the designated column's database-specific type name. So, this answer is correct.

There are 10 methods present in the Time class in java. These are:-
1) getDate()
2) getDay()
3) getMonth()
4) getYear()
5) setDate(int i)
6) setMonth(int i)
7) setTime(int i)
8) setYear(int i)
9) toString():- Formats a time in JDBC time escape format
10) valueOf(String s):- Converts a string in JDBC time escape format to a Time value
So, this is the correct answer.

As explained above, both options (1) and (2) are correct.

There is no method named getWrite() defined in the DataTruncation class in java. So, this answer is true.

There is no method named createXMLSQL() in Connection interface. The correct method name is createSQLXML(). This method Constructs an object that implements the SQLXML interface. So, this answer is correct.

There is no method named getResults() in Statement interface. The correct method name is getMoreResults() which moves to this Statement object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet. So, this answer is true.

There is no method named getPreviousException() in java database programming. So, this answer is true.

This is the correct choice because rowDeleted() method is present in ResultSet interface and it retrieves whether a row has been deleted or not. 

rowInserted() method is present in the ResultSet interface and it retrieves whether the current row has had an insertion or not. So, this answer is correct.

isValid(int timeout) method is present in the Connection interface and it returns true if the connection has not been closed and is still valid. So, this answer is correct.

There are 8 constructors of SQLTimeoutException class in java. These are:-
1) SQLTimeoutException():- Constructs a SQLTimeoutException object
2) SQLTimeoutException(String reason):- Constructs a SQLTimeoutException object with a given reason
3) SQLTimeoutException(String reason, String SQLState):- Constructs a SQLTimeoutException object with a given reason and SQLState
4) SQLTimeoutException(String reason, String SQLState, int vendorCode):- Constructs a SQLTimeoutException object with a given reason, SQLState and vendorCode
5) SQLTimeoutException(String reason, String SQLState, int vendorCode, Throwable cause):- Constructs a SQLTimeoutException object with a given reason, SQLState, vendorCode and cause
6) SQLTimeoutException(String reason, String SQLState, Throwable cause):- Constructs a SQLTimeoutException object with a given reason, SQLState and cause
7) SQLTimeoutException(String reason, Throwable cause):- Constructs a SQLTimeoutException object with a given reason and cause
8) SQLTimeoutException(Throwable cause):- Constructs a SQLTimeoutException object with a given cause
So, this is the correct answer.

rowUpdated() method is present in the ResultSet interface and it retrieves whether the current row in the table has been updated or not. So, this is the correct choice.