JDBC Database Access Quiz for Oracle Java OCP

1. True or False: Connection pooling reduces the overhead of creating new database connections.

True

False

2. True or False: A single Connection object can be shared safely across multiple threads without synchronization.

True

False

Submit

4. What does executeUpdate() return in JDBC?

A ResultSet object

The number of rows affected

A boolean value

A Statement object

5. Which method is used to set a parameter value in a PreparedStatement?

SetParameter(int, Object)

SetInt(int, int)

BindValue(int, Object)

SetVariable(int, Object)

6. True or False: PreparedStatement prevents SQL injection attacks better than Statement.

True

False

Submit

8. Which method executes an SQL query that returns a ResultSet?

Execute()

ExecuteUpdate()

ExecuteQuery()

ExecuteBatch()

9. What is the correct JDBC URL format for connecting to an Oracle database?

Jdbc:oracle:thin:@host:port:sid

Jdbc:mysql://host:port/database

Jdbc:postgresql://host:port/database

Jdbc:oracle://host:port/database

10. Which method retrieves a column value as a String from a ResultSet?

GetColumn(int)

GetString(int)

FetchString(int)

ReadString(int)

11. Which interface represents a connection to a specific database in JDBC?

Statement

Connection

ResultSet

DataSource

Submit

13. Which exception is thrown when a database access error occurs in JDBC?

IOException

SQLException

DatabaseException

ConnectionException

14. What does the setAutoCommit(false) method do?

Disables automatic transaction commits

Enables batch processing

Closes the connection

Rolls back pending transactions

15. Which method is used to move the cursor to the next row in a ResultSet?

Next()

MoveNext()

Advance()

Forward()

16. True or False: A ResultSet is automatically closed when its associated Statement is closed.

True

False

Submit

18. Which statement type is best for executing parameterized queries in JDBC?

Statement

PreparedStatement

CallableStatement

BatchStatement

19. What is the primary purpose of DriverManager.getConnection()?

Load the JDBC driver

Establish a connection to a database

Execute SQL queries

Manage connection pooling

Oracle Java OCP JDBC Database Access Quiz

1. True or False: Connection pooling reduces the overhead of creating new database connections.

2.

What first name or nickname would you like us to use?

2. True or False: A single Connection object can be shared safely across multiple threads without synchronization.

3. The rollback() method ________ all pending changes in a transaction.

4. What does executeUpdate() return in JDBC?

5. Which method is used to set a parameter value in a PreparedStatement?

6. True or False: PreparedStatement prevents SQL injection attacks better than Statement.

7. The commit() method ________ all pending changes in a transaction.

8. Which method executes an SQL query that returns a ResultSet?

9. What is the correct JDBC URL format for connecting to an Oracle database?

10. Which method retrieves a column value as a String from a ResultSet?

11. Which interface represents a connection to a specific database in JDBC?

12. A ________ is used to call stored procedures in a database.

13. Which exception is thrown when a database access error occurs in JDBC?

14. What does the setAutoCommit(false) method do?

15. Which method is used to move the cursor to the next row in a ResultSet?

16. True or False: A ResultSet is automatically closed when its associated Statement is closed.

17. A ________ object holds the result set returned from a database query.

18. Which statement type is best for executing parameterized queries in JDBC?

19. What is the primary purpose of DriverManager.getConnection()?