Test your skills through the online practice test: SQL Quiz Online Practice Test

Related differences

Ques 26. What are the two components of ODBC ?

1. An ODBC manager/administrator and
2. ODBC driver.

Is it helpful? Add Comment View Comments
 

Ques 27. What is the function of a ODBC manager ?

The ODBC Manager manages all the data sources that exists in the system.

Is it helpful? Add Comment View Comments
 

Ques 28. What is the function of a ODBC Driver ?

The ODBC Driver allows the developer to talk to the back end database.

Is it helpful? Add Comment View Comments
 

Ques 29. What description of a data source is required for ODBC ?

The name of the DBMS, the location of the source and the database dependent information.

Is it helpful? Add Comment View Comments
 

Ques 30. How to Retrieve Warnings?

SQLWarning objects are a subclass of SQLException that deal with database access warnings. Warnings do not stop the execution of an application, as exceptions do; they simply alert the user that something did not happen as planned. A warning can be reported on a Connection object, a Statement object (including PreparedStatement and CallableStatement objects), or a ResultSet object. Each of these classes has a getWarnings method, which you must invoke in order to see the first warning reported on the calling object




SQLWarning warning = stmt.getWarnings();

if (warning != null)

{

while (warning != null)

{

System.out.println("Message: " + warning.getMessage());

System.out.println("SQLState: " + warning.getSQLState());

System.out.print("Vendor error code: ");

System.out.println(warning.getErrorCode());

warning = warning.getNextWarning();

}

}

Is it helpful? Add Comment View Comments
 

Most helpful rated by users:

About Withoutbook

This site contains most of the quality computer technologies which can help all the related students and employees. We have large number of interview questions and answers, online test, difference between on many subjects.

Social Links

Quick Links

About Us Privacy Policy Terms of Use Contact Us Take a Tour

Copyright © 2024, WBook Technologies.