Show List

Quiz - JDBC - 2

77%

Public Average Score
Select the right answer for below questions:

What is the use of savepoint in JDBC?
To commit a transaction
To store result set
To store metadata
To rollback to a specific point in a transaction
To rollback to a specific point in a transaction

What is the use of setAutoCommit method in JDBC?
To turn off auto-commit mode
To turn on auto-commit mode
To store result set
To store metadata
To turn on auto-commit mode

What is the use of setTransactionIsolation method in JDBC?
To commit a transaction
To store result set
To set the transaction isolation level
To store metadata
To set the transaction isolation level

What is the use of commit method in JDBC?
To commit a transaction
To rollback a transaction
To store result set
To store metadata
To commit a transaction

What is the use of rollback method in JDBC?
To rollback a transaction
To commit a transaction
To store result set
To store metadata
To rollback a transaction

What is the use of close method in JDBC?
To commit a transaction
To close a connection to the database
To store result set
To store metadata
To close a connection to the database

What is batch processing in JDBC?
The ability to execute a single SQL statement
The ability to execute multiple SQL statements as a single batch
The ability to store result set
The ability to store metadata
The ability to execute multiple SQL statements as a single batch

What is the use of executeQuery method in JDBC?
To execute an INSERT statement
To execute an UPDATE statement
To execute a SELECT statement
To execute a DELETE statement
To execute a SELECT statement

What is the use of executeUpdate method in JDBC?
To execute a SELECT statement
To execute an INSERT statement
To execute an UPDATE and DELETE statement
None of these
To execute an UPDATE and DELETE statement

What is the use of execute method in JDBC?
To execute any type of SQL statement
To execute a SELECT statement
To execute an INSERT statement
To execute an UPDATE statement
To execute any type of SQL statement

Submit
Retry
{"qz1-473357":"To rollback to a specific point in a transaction","qz1-473358":"To turn on auto-commit mode","qz1-473359":"To set the transaction isolation level","qz1-473360":"To commit a transaction","qz1-473361":"To rollback a transaction","qz1-473362":"To close a connection to the database","qz1-473363":"The ability to execute multiple SQL statements as a single batch","qz1-473364":"To execute a SELECT statement","qz1-473365":"To execute an UPDATE and DELETE statement","qz1-473366":"To execute any type of SQL statement"}

    Leave a Comment


  • captcha text