T4Tutorials .PK

JDBC PROGRAMMING MCQs – CHAPTER 8 DAE

1. . What are the types of ResultSet in JDBC?

(A) Both a and b


(B) Scrollable ResultSet


(C) Only a


(D) Forward ResultSet




2. . Select the packages in which JDBC classes are defined?

(A) jdbc and javax.jdbc


(B) rdb and javax.rdb


(C) sql and javax.sql


(D) jdbc and java.jdbc.sql




3. . Which of the following method is used to perform DML statements in JDBC?

(A) executeResult()


(B) executeQuery()


(C) executeUpdate()


(D) execute()




4. . How many transaction isolation levels are provided by JDBC through the Connection interface?

(A) 3


(B) 2


(C) 7


(D) 4




5. . Which of the following method is static and synchronized in JDBC API?

(A) executeUpdate()


(B) prepareCall()


(C) getConnection()


(D) executeQuery()




6. . Which methods are required to load a database driver in JDBC?

(A) Both b and c


(B) registerDriver()


(C) forName()


(D) getConnection()




7. . Parameterized queries can be executed by?

(A) ParameterizedStatement


(B) CallableStatement and Parameterized Statement


(C) PreparedStatement


(D) All kinds of Statements




8. . Which of the following is not a valid statement in JDBC?

(A) Statement


(B) PreparedStatement


(C) QueryStatement


(D) CallableStatement




9. . Stored procedure can be called by using the ______.

(A) CallableStatement


(B) PreparedStatement


(C) CalledStatement


(D) Statement




10. . A good way to debug JDBC-related problems is to enable ______.

(A) JDBC tracing


(B) Exception handling


(C) Both a and b


(D) Only b




11. . Which JDBC driver can be used in servlet and applet both?

(A) Type 3


(B) Type 3 and Type 4


(C) Type 3 and Type 2


(D) Type 4




12. . JDBC-ODBC driver is also known as?

(A) Type 1


(B) Type 3


(C) Type 4


(D) Type 2




13. . How many stages are used by Java programmers while using JDBC in their programs?

(A) 3


(B) 2


(C) 6


(D) 5




14. . How many ways to register a driver?

(A) 4


(B) 3


(C) 2


(D) 5




Exit mobile version