Answer Posted / kirthi

executeQuery() --- This is used generally for reading the
content of the database. The output will be in the form of
ResultSet. Generally SELECT statement is used.

executeUpdate() --- This is generally used for altering the
databases. Generally DROP TABLE or DATABASE, INSERT into
TABLE, UPDATE TABLE, DELETE from TABLE statements will be
used in this. The output will be in the form of int. This
int value denotes the number of rows affected by the query.

execute() --- If you dont know which method to be used for
executing SQL statements, this method can be used. This
will return a boolean. TRUE indicates the result is a
ResultSet and FALSE indicates it has the int value which
denotes number of rows affected by the query.

What are different types of ResultSet?

1057

---

Give an example for getXXX method?

986

---

Explain about the Try Block?

979

---

Why isn't the java.sql.DriverManager class being found?

996

---

Why do we need jdbc api?

970

---

Name the new features added in jdbc 4.0.

979

---

What is data source in java?

950

---

What is jdbc driver?

904

---

What is addbatch jdbc?

1028

---

Does sql allow null values ?

959

---

How can you make a connection?

982

---

How many locking systems are there in jdbc?

1019

---

How can I manage special characters when I execute an insert query?

932

---

How many jdbc driver types are there?

920

---

Which database is used for java?

949

---