PBTE DAE CIT-303 Web Development with JAVA | Chapter 8 : JDBC Programming | MCQs

CIT 303

Web Development with JAVA

Chapter 8 : JDBC Programming

DAE Computer Information Technology | Third Year

Short Questions

• Home
• DAE
• CIT-303
• Chapter 8 (JDBC Programming) - MCQs

Chapter:08 (JDBC Programming)

Question 1:

What are the types of ResultSet in JDBC?

Forward ResultSet Scrollable ResultSet Only a Both a and b

Question 2:

Select the packages in which JDBC classes are defined?

jdbc and javax.jdbc rdb and javax.rdb jdbc and java.jdbc.sql sql and javax.sql

Question 3:

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

executeResult() executeQuery() executeUpdate() execute()

Question 4:

How many transaction isolation levels provide the JDBC through the Connection interface?

3 4 7 2

Question 5:

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

getConnection() prepareCall() executeUpdate() executeQuery()

Question 6:

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

getConnection() registerDriver() forName() Both b and c

Question 7:

Parameterized queries can be executed by?

ParameterizedStatement PreparedStatement CallableStatement and Parameterized Statement All kinds of Statements

Question 8:

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

Statement PreparedStatement QueryStatement CallableStatement

Question 9:

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

CallableStatement Statement CalledStatement PreparedStatement

Question 10:

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

JDBC tracing Exception handling Both a and b Only b

Question 11:

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

Type 3 Type 4 Type 3 and Type 2 Type 3 and Type 4

Question 12:

JDBC-ODBC driver is also known as

Type 4 Type 3 Type 1 Type 2

Question 13:

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

3 2 5 6

Question 14:

How many ways to register a driver?

2 3 4 5

Quiz Results

Total Questions:

Correct Answers:

Incorrect Answers:

Percentage:

NOTE

If you find any mistake in them, do tell in the comment, so that it can be corrected.

If you face any issues feel free to contact me on WhatsApp
03129671316, 03085507292

If you want more improvement
Share feedback in the comment

INSTRUCTOR

MUHAMMAD BIN JAMEEL

BSC ENGG. CIVIL