Answer Posted / deepak cheela
For suppose if two database connections are available for
two client requests then database server grants all of them
connection after usage of one client request is over that
client must close the connection becoz server create a
session with clent requests.if so we do without clossing the
connection the DBserver thinks client is still processing
then load wil be on DBserver and performance will decrease.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Compare jdbc and odbc and how is jdbc required in this context.
What is the reason why we need a jdbcrowset like the wrapper around resultset?
What are the packages are used in jdbc?
What is a datasource in java?
How can we execute stored procedures?
What are the considerations for deciding on transaction boundaries?
State the three different ways in which you can create a table?
How many jdbc driver types are there?
Discuss the procedure of retrieving warnings?
Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?
What are the steps required to execute a query in jdbc?
What is the JDBC?
How to connect html page to database using jdbc?
What are the components of jdbc?
Why we use while rs next ())?