|
|
Created by Jerry Reeves Jr
over 3 years ago
|
|
How JDBC plays a vital role in Java?
What is the functionality of ResultSet in JDBC?
Why we need JDBC driver in JDBC?
What is the need of DriverManager in JDBC?
Which JDBC driver is fastest and used more commonly?
Which data types are used for storing the image and file in the database table?
Why we need stored procedure? Explain it?
How can you differentiate ODBC and JDBC?
What is Rowset in a Resultset?
JDBC driver
Type I
JDBC
JDBC driver
Type II
Native API
JDBC driver
Type III
Network Protocol
JDBC
Type IV
Thin Driver
JDBC Statement
java.sql.Statement
JDBC Statement
java.sql.PreparedStatement
JDBC Statement
java.sql.CallableStatement
Connection
Statement
PreparedStatement
ResultSet
ResultSetMetaData
DatabaseMetaData
CallableStatement
DriverManager
BLOB
CLOB
What is Batch processing in JDBC? How to perform it?
How can you differentiate Statement and PreparedStatement?
What is execute(),executeQuery() and executeUpdate() methods in JDBC?Explain it?
How getter and setter methods used in ResultSet?
What do you mean by "Dirty read" in terms of database?
Step 1 for establishing a JDBC connection
Loading the Driver
Step 2 for establishing a JDBC connection
Connection
Step 3 for establishing a JDBC connection
Create a statement
Step 4 for establishing a JDBC connection
Execute the query
Step 5 for establishing a JDBC connection
Close the connection
Explain the implementation of JDBC MySQL database connection with an example?
Explain the implementation to call Stored procedures in JDBC?
When "No suitable driver" error occurs in java?
Explain the types of JDBC architecture?
Transaction
Transaction Management
ACID
ACID property
Atomicity
ACID property
Consistency
ACID property
Isolation
ACID property
Durability
Need for Transaction Management
How can you differentiate between PreparedStatement and Statement?
setAutocommit()
commit()
rollback()
setSavepoint()
releaseSavepoint()
Explain the common exceptions in JDBC.
How two-phase commit is performed in JDBC?
How to create a table dynamically from java using JDBC?
How is it possible to connect to multiple databases using single statement object?
How do you insert images into database using JDBC?
Hide known cards