InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 101. |
What does JDBC do? |
| Answer» | |
| 102. |
When do we use execute method in Java JDBC? |
| Answer» | |
| 103. |
Explain the two tier and three tier architecture of JDBC. |
| Answer» | |
| 104. |
What are the different types of Statements? How we can you use PreparedStatement. |
| Answer» | |
| 105. |
How can we retrieve data from the ResultSet? |
| Answer» | |
| 106. |
How are JDBC Statements used? |
| Answer» | |
| 107. |
Differentiate between TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE. |
| Answer» | |
| 108. |
What are the utilities of the CallableStatement? |
| Answer» | |
| 109. |
Explain how to Make Updates to the Updatable ResultSets. |
| Answer» | |
| 110. |
Name the types of JDBC drivers. |
| Answer» | |
| 111. |
Expalin the method of calling a stored procedure from JDBC. |
| Answer» | |
| 112. |
How do I find whether a parameter exists in the request object? |
| Answer» | |
| 113. |
What are the factors that the JDBC driver performance depends upon? |
| Answer» | |
| 114. |
How can you make a connection? |
| Answer» | |
| 115. |
What Class.forName does, while loading the drivers? |
| Answer» | |
| 116. |
How do we load the drivers? |
| Answer» | |
| 117. |
How can we move the cursor in a scrollable result set? |
| Answer» | |
| 118. |
What is SQLWarning and discuss the procedure of retrieving warnings? |
| Answer» | |
| 119. |
How do we call a stored procedure from JDBC? |
| Answer» | |
| 120. |
What is the function of setAutoCommit? |
| Answer» | |
| 121. |
Differentiate between a Statement and a PreparedStatement. |
| Answer» | |
| 122. |
Define PreparedStatement. |
| Answer» | |
| 123. |
What is a Statement? |
| Answer» | |
| 124. |
What is represented by the connection object? |
| Answer» | |
| 125. |
What does the JDBC Driver interface do? |
| Answer» | |
| 126. |
How a database driver can be loaded with JDBC 4.0 / Java 6? |
| Answer» | |
| 127. |
Describe how the JDBC application works. |
| Answer» | |
| 128. |
Explain the life cycle of JDBC. |
| Answer» | |
| 129. |
Briefly tell about the JDBC Architecture. |
| Answer» | |
| 130. |
How do Java applications access the database using JDBC? |
| Answer» | |
| 131. |
Name the new features added in JDBC 4.0. |
| Answer» | |
| 132. |
Discuss the significances of JDBC. |
| Answer» | |
| 133. |
How do I insert an image file (or other raw data) into a database? |
| Answer» | |
| 134. |
How can you load the drivers? |
| Answer» | |
| 135. |
What are DML and DDL? |
| Answer» | |
| 136. |
I have the choice of manipulating database data using a byte[] or a java.sql.Blob. Which has best performance? |
| Answer» | |
| 137. |
Explain basic steps in writing a Java program using JDBC. |
| Answer» | |
| 138. |
What is the benefit of having JdbcRowSet implementation? Why do we need a JdbcRowSet like wrapper around ResultSet? |
| Answer» | |
| 139. |
How can I manage special characters when I execute an INSERT query? |
| Answer» | |
| 140. |
What are the differences between setMaxRows(int) and SetFetchSize(int)? |
| Answer» | |
| 141. |
Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases? |
| Answer» | |
| 142. |
What are types of JDBC drivers? |
| Answer» | |
| 143. |
What restrictions are placed on method overriding? |
| Answer» | |
| 144. |
Why Prepared Statements are faster? |
| Answer» | |
| 145. |
What does setAutoCommit do? |
| Answer» | |
| 146. |
What causes No suitable driver error? |
| Answer» | |
| 147. |
What are the types of statements in JDBC? |
| Answer» | |
| 148. |
Write a code to create a trigger to call a stored procedure |
| Answer» | |
| 149. |
How transient variable is different from volatile variable? |
| Answer» | |
| 150. |
What is a prefix function.write down a code to compute prefix function. |
| Answer» | |