UNIT - 1

Which of the following best describes JDBC?

• A protocol

• A programming language

• An API to connect Java to a database

• A database management system

Which layer in the JDBC architecture is responsible for managing the list of database drivers?

• JDBC API

• Java Application

• JDBC Driver

• JDBC Driver Manager

JDBC provides what type of database connectivity?

• Platform-specific

• Database-specific

• Platform-independent and database-independent

• Platform-independent only

Which of the following is NOT a responsibility of the JDBC API?

• Connect to a database

• Compile Java code

• Execute SQL queries

• Retrieve results from a database

What is the correct order of steps to establish a JDBC connection?

• Create statement → Register driver → Execute query → Close

• Register driver → Create connection → Create statement → Execute query → Close

• Execute query → Register driver → Create connection → Close

• Create connection → Register driver → Execute query → Close

Which JDBC driver uses an ODBC driver internally?

• Type-1

• Type-2

• Type-3

• Type-4

Which JDBC driver provides the best performance and is platform-independent?

• Type-1

• Type-2

• Type-3

• Type-4

Which driver type is entirely written in Java and communicates directly with the database?

• Type-1

• Type-2

• Type-3

• Type-4

Which driver uses a middleware application server?

• Type-1

• Type-2

• Type-3

• Type-4

What is a disadvantage of the JDBC-ODBC bridge driver?

• Easy to use

• Requires ODBC driver installation

• Fully Java-based

• High performance