Explore topic-wise MCQs in BBA in Computer Applications.

This section includes 218 Mcqs, each offering curated multiple-choice questions to sharpen your BBA in Computer Applications knowledge and support exam preparation. Choose a topic below to get started.

201.

Which of the following statements is false as far as different type of statements is concern in JDBC?

A. regular statement
B. prepared statement
C. callable statement
D. interim statement
Answer» E.
Discussion
202.

Which of the following allows non repeatable read in JDBC Connection?

A. transweraction_read_uncommitted
B. transweraction_read_committed
C. transweraction_serializable
D. transweraction_repeatable_read
Answer» E.
Discussion
203.

JDBC stands for?

A. java database connectivity
B. java database concept
C. java database communications
D. none of the above
Answer» B. java database concept
Discussion
204.

Which JDBC product components does the Java software provide?

A. the jdbc driver manager
B. the jdbc driver test suite
C. the jdbc-odbc bridge
D. all mentioned above
Answer» E.
Discussion
205.

What is used to execute parameterized query?

A. statement interface
B. preparedstatement interface
C. resultset interface
D. none of the above
Answer» C. resultset interface
Discussion
206.

Which result set generally does not show changes to the underlying database that are made while it is open. The membership, order, and column values of rows are typically fixed when the result set is created?

A. type_forward_only
B. type_scroll_insensitive
C. type_scroll_sensitive
D. all mentioned above
Answer» C. type_scroll_sensitive
Discussion
207.

Which method is used for an SQL statement that is executed frequently?

A. prepare statement
B. prepare call
C. create statement
D. none of the above
Answer» B. prepare call
Discussion
208.

How many types of JDBC drivers are available?

A. 3
B. 4
C. 2
D. 5
Answer» C. 2
Discussion
209.

How many JDBC product components does the Java software provides?

A. 3
B. 2
C. 4
D. 5
Answer» B. 2
Discussion
210.

Which driver uses ODBC driver to connect to the database?

A. jdbc-odbc bridge driver
B. native - api driver
C. network protocol driver
D. thin driver
Answer» B. native - api driver
Discussion
211.

Which of the following is used to rollback a JDBC trAnsweraction?

A. rollback()
B. rollforward()
C. deletetransweraction()
D. removetransweraction()
Answer» B. rollforward()
Discussion
212.

Which of the following is used to call stored procedure?

A. statement
B. preparedstatement
C. callablestatment
D. calledstatement
Answer» D. calledstatement
Discussion
213.

What does setAutoCommit(false) do?

A. commits transweraction after each query
B. explicitly commits transweraction
C. does not commit transweraction automatically after each query
D. never commits transweraction
Answer» D. never commits transweraction
Discussion
214.

Which of the following is method of JDBC batch process?

A. setbatch()
B. deletebatch()
C. removebatch()
D. addbatch()
Answer» E.
Discussion
215.

Which of the following is advantage of using PreparedStatement in Java?

A. slow performance
B. encourages sql injection
C. prevents sql injection
D. more memory usage
Answer» D. more memory usage
Discussion
216.

Which of the following is advantage of using JDBC connection pool?

A. slow performance
B. using more memory
C. using less memory
D. better performance
Answer» E.
Discussion
217.

Which one of the following contains date information?

A. java.sql.timestamp
B. java.sql.time
C. java.io.time
D. java.io.timestamp
Answer» B. java.sql.time
Discussion
218.

Which of the following contains both date and time?

A. java.io.date
B. java.sql.date
C. java.util.date
D. java.util.datetime
Answer» E.
Discussion