{"id":8752,"date":"2019-02-21T16:40:20","date_gmt":"2019-02-21T16:40:20","guid":{"rendered":"https:\/\/www.monsterindia.com\/career-advice\/10-frequently-asked-jdbc-interview-questions-8752\/"},"modified":"2021-11-16T07:41:48","modified_gmt":"2021-11-16T07:41:48","slug":"10-frequently-asked-jdbc-interview-questions","status":"publish","type":"post","link":"https:\/\/www.foundit.my\/career-advice\/10-frequently-asked-jdbc-interview-questions\/","title":{"rendered":"10 frequently asked JDBC Interview Questions"},"content":{"rendered":"\n

Subjects such as JDBC require you to set your basics right in order to succeed in a job interview. Here are some of the most frequently asked JDBC questions that you can go through.<\/span><\/p>\n\n\n\n

1. What do you understand by the database connection pooling? What are the advantages of using connection pooling?<\/strong> <\/span><\/p>\n\n\n\n

As the name suggests, database connection pooling is defined as the process in which connections are chiefly stored in the cache so that they are reusable in the near future. So far as the merits are concerned, it is relatively quick and also helps evaluate the overall process of database pooling.<\/span><\/p>\n\n\n\n

2. In JDBC, what do you understand by the term batch updates? <\/span><\/strong><\/span><\/p>\n\n\n\n

Batch update refers to the process of executing SQL queries concurrently. Barring select query, the method of batch updates may be applied to all other cases such as update, insert and delete. <\/span><\/p>\n\n\n\n

3. What do you think are some the basic merits of using Prepared Statement in Java?<\/strong> <\/span><\/p>\n\n\n\n

So far as the Prepared Statement is concerned, it is chiefly advantageous in that it helps iterative execution of the same SQL statements. Precisely, it is an important aspect of JDBC. However, it must be understood that the Prepared Statement is compiled not more than once. <\/span><\/p>\n\n\n\n

4. Speaking of a prepared statement, why do you think it is quicker than direct execution?<\/strong> <\/span><\/p>\n\n\n\n

Precisely, the prepared statement is faster because it is compiled only once. Apart from that, it is imperative to keep in mind that the prepared statement is directly connected with the JDBC driver so that there are no fundamental connection overheads. Consequently, the prepared statement is quicker than the execution of direct statements. <\/span><\/p>\n\n\n\n

5. Can you tell us how many locking systems are there in the JDBC?<\/strong> <\/span><\/p>\n\n\n\n

Essentially, there are two kinds of locking systems in the JDBC. Locking is an important aspect of the JDBC. Depending on the user situation, you decide whether to avail of the locking system. So there are two types: pessimistic locking and optimistic locking. Optimistic locking is used to lock a record only when you seek to update. On the other hand, pessimistic locking is used to lock the record from the select parameter in order to view and update. <\/span><\/p>\n\n\n\n

You may also like:<\/span><\/strong><\/span><\/p>\n\n\n\n