|
INTERVIEW QUESTIONS
J2EE
JDBC
DETAILS
Question: What is pessimistic concurrency?
Answer: With a pessimistic approach, locks are used to ensure that no users, other than the one who holds the lock, can update data. It's generally explained that the term pessimistic is used because the expectation is that many users will try to update the same data, so one is pessimistic that an update will be able to complete properly. Locks may be acquired, depending on the DBMS vendor, automatically via the selected Isolation Level. Some vendors also implement 'Select... for Update', which explicitly acquires a lock.
|
|
|
Category |
JDBC Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7108 users |
Added on |
9/12/2014 |
Views |
66611 |
Rate it! |
|
|
Question:
What is pessimistic concurrency?
Answer:
With a pessimistic approach, locks are used to ensure that no users, other than the one who holds the lock, can update data. It's generally explained that the term pessimistic is used because the expectation is that many users will try to update the same data, so one is pessimistic that an update will be able to complete properly. Locks may be acquired, depending on the DBMS vendor, automatically via the selected Isolation Level. Some vendors also implement 'Select... for Update', which explicitly acquires a lock. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is optimistic concurrency?
|
View Answer
|
|
Which Java and java.sql data types map to my specific database types?
|
View Answer
|
|
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
|
View Answer
|
|
What is a JDBC 2.0 DataSource?
|
View Answer
|
|
Can I use JDBC to execute non-standard features that my DBMS provides?
|
View Answer
|
|
How can I get information about foreign keys used in a table?
|
View Answer
|
|
How can I determine where a given table is referenced via foreign keys?
|
View Answer
|
|
What are the considerations for deciding on transaction boundaries?
|
View Answer
|
|
How to insert/update records with some of the columns having NULL value?
|
View Answer
|
|
Why do I get UnsatisfiedLinkError when I try to use my JDBC driver?
|
View Answer
|
|
How do I check in my code whether a maximum limit of database connections have been reached?
|
View Answer
|
|
What is the JDBC syntax for using a literal or variable in a standard Statement?
|
View Answer
|
|
How do I set properties for a JDBC driver and where are the properties stored?
|
View Answer
|
|
What is an SQL Locator?
|
View Answer
|
|
Why do I have to reaccess the database for Array, Blob, and Clob data?
|
View Answer
|
|
What does it mean to "materialize" data?
|
View Answer
|
|
How can I get or redirect the log used by DriverManager and JDBC drivers?
|
View Answer
|
|
How can I write to the log used by DriverManager and JDBC drivers?
|
View Answer
|
|
How do I receive a ResultSet from a stored procedure?
|
View Answer
|
|
Connecting to a database through the Proxy I want to connect to remote database using a program that is running in the local network behind the proxy. Is that possible?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All JDBC Interview Questions & Answers - Exam Mode /
Learning Mode
|