U3.1. Connections (JDBC)

What are connectors?

• A type of database management software.

• Libraries that allow applications to communicate with a database management system.

• Software components that directly store data.

• Tools for creating databases.

Which is not a CRUD operation?

• Update

• Create

• Modify

• Read

• Delete

What is JDBC primarily used for?

• Creating new databases

• Connecting Java applications to various database management systems

• Formatting SQL queries

• Encrypting database connections

What does the java.sql.Connection class represent?

• A tool to manage database drivers

• A connection to a database

• A class to execute SQL statements

• A method to handle SQL errors

In JDBC, what does the URL format jdbc:%subprotocol%:%db_name% represent?

• It represents a file path for SQLite databases only.

• • It specifies the location and protocol for a database connection.

• It defines the user and password for connection.

• • It provides the SQL syntax for a database connection.

Which JDBC class is responsible for managing drivers?

• DriverClass

• DriverManager

• DriverConnector

• DriverControler

What method is used for connecting to a database?

• createConnection

• connectToDB

• openConnection

• getConnection

What is the correct way to close a JDBC connection in a try-with-resources block?

• con.close();

• try(Connection con = DriverManager.getConnection(...)){ }

• DriverManager.close(con);

• closeConnection(con);

What are metadata in the context of databases?

• Safety data

• Configuration data

• User data

• Data about data

What is the primary use of DatabaseMetaData in JDBC?

• To define SQL statements

• To retrieve information about the database structure

• To share data to an external database

• To store data