Q3-PROGRAMMING-SUMMATIVE-TEST-SY2023-2024

What is JDBC?

• Joint Driver for Basic Connection

• JDBC is a java-based protocol.

• JDBC is a specification to tell how to connect to a database.

• JDBC is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases.

Which of the following encapsulates an SQL statement which is passed to the database to be parsed, compiled, planned and executed?

• JDBC driver

• Statement

• DriverManager

• Connection

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

• QueryStatement  

• PreparedStatement

• Statement

• CallableStatement  

What is true about getConnection() method?

• It is a non static method from DriverManager class

• It is a static method from DriverManager interface

• It is a static method from DriverManager class

• It is a non static method from DriverManager interface

How can you execute DML statements (i.e. insert, delete, update) in the database?

• By making use of the execute(…) statement of the DataModificationStatement object

• By invoking the execute(…) or executeUpdate(…) method of a normal Statement object or a sub-interface object thereof

• By invoking the executeInsert(…), executeDelete(…) or executeUpdate(…) methods of the DataModificationStatement object

• By making use of the InsertStatement, DeleteStatement or UpdateStatement classes

What is the return type of executeUpdate() method?

• short

• byte

• int

• long

What is true about getConnection() method?

• It is a non static method from DriverManager interface

• It is a non static method from DriverManager class

• It is a static method from DriverManager interface

• It is a static method from DriverManager class

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

• Better performance

• Using more memory

• Slow performance

• Using less memory

Which packages contain the JDBC classes?

• java.jdbc and javax.jdbc

• java.jdbc and java.jdbc.sql

• ava.rdb and javax.rdb

• java.sql and javax.sql

Which package contains JDBC classes and interfaces?

• java.sql

• java.lang

• java.io

• java.jdbc