University:
California State University, Northridge
Course:
COMP 110 | Introduction to Algorithms and Programming and Lab
Academic year:

2024
Views:

307

Pages:

10
Author:

Samuel K

Quiz 11Due Nov 18, 2023 at 11:45amPoints 40Questions 20Time Limit 75 MinutesQuestion 12 ptsWhat does JDBC stand for in Java programming?Java Database CompilerJava Data Binding ConnectorJava Database ConnectivityJava Data Buffering ControlQuestion 22 ptsWhich package in Java contains the JDBC API classes?Cjava.sqljava.utiljava.jdbcjava.database Question 32 ptsWhat is the purpose of the DriverManager class in JDBC?CManaging database driversExecuting SQL queriesHandling result setsCreating database tablesQuestion 42 ptsWhich method is used to establish a connection to a database inJDBC?createConnection()establishConnection()getConnection()connectToDatabase() Question 52 ptsWhat is the purpose of the Connection interface in JDBC?Executing SQL queriesRepresenting a connection to a databaseHandling result setsManaging database driversQuestion 62 ptsWhich method is used to create a Statement object in JDBC?createStatement()makeStatement()newStatement()generateStatement() Question 72 ptsWhat is the purpose of the Statement interface in JDBC?Handling result setsExecuting SQL queriesRepresenting a connection to a databaseManaging database driversQuestion 82 ptsWhich method is used to execute a query in JDBC?executeUpdate()executeQuery()execute()runQuery() Question 92 ptsWhat is the purpose of the ResultSet interface in JDBC?Executing SQL queriesRepresenting a connection to a databaseHandling result setsManaging database driversQuestion 102 ptsWhich method is used to retrieve data from a ResultSet in JDBC?fetchData()getData()retrieve()getString() Question 112 ptsWhat is the purpose of the PreparedStatement interface in JDBC?Executing SQL queriesRepresenting a connection to a databaseHandling result setsaPrecompiling SQL statementsQuestion 122 ptsWhich method is used to execute a parameterized query in JDBC?executeUpdate()executeQuery()execute()setParameter() Question 132 ptsWhat is the purpose of the CallableStatement interface in JDBC?Executing SQL queriesRepresenting a connection to a databaseHandling result setsExecuting stored proceduresQuestion 142 ptsWhich method is used to call a stored procedure in JDBC?executeUpdate()executeQuery()execute()call() Question 152 ptsWhat is the purpose of the Batch processing in JDBC?Executing multiple SQL queries in a batchHandling result setsConnecting to multiple databasesManaging database driversQuestion 162 ptsWhat is the role of the DriverManager class in JDBC?Managing database connectionsExecuting SQL queriesHandling result setsCreating database tables Question 172 ptsWhich method is used to close a connection in JDBC?closeConnection()endConnection()close()shutdown()Question 182 ptsWhat is the purpose of the ResultSetMetaData interface in JDBC?Executing SQL queriesHandling result setsRetrieving metadata about the result setManaging database drivers Question 192 ptsWhich interface represents a precompiled SQL statement in JDBC?ConnectionStatementPreparedStatementResultSetQuestion 202 ptsIn JDBC, what is the purpose of the commit() method?Rollback changes in the databaseClose the database connectionSave the changes made since the last commitExecute a SQL query