PDA

View Full Version : JDBC


  1. Can we use the one instance of Statement to execute more than one query
  2. What is Type-3 Driver and when this driver is used
  3. Can you create an index on sex column where there is M or F
  4. How can you tune SQL statements
  5. How to execute bulk number of queries at once
  6. Is the JDBC-ODBC Bridge multi-threaded
  7. How can a java objects be stored in database
  8. Can the JDBC-ODBC Bridge be used with applets
  9. Can you define a foreign key, with a key from the same table
  10. Are there any ODBC drivers that do not work with the JDBC- ODBC Bridge
  11. What is Type-1 Driver and when this driver is used?
  12. What is Type-4 Driver and when this driver is used
  13. What is Type-2 Driver and when this driver is used
  14. What is 2-tier and 3-tier architecture
  15. How do you debug PL/SQL code
  16. Without using of Class.forName(? ?), how do you connect to db
  17. What is isolation level? How to set it
  18. How do find debugging problems related to JDBC API
  19. Explain the sequence of steps to connect to the database
  20. How to get a whole row of data at once
  21. How can you sort dates
  22. How warnings are retrieved in JDBC
  23. How a driver can be loaded
  24. How data can be inserted into long row column of database
  25. How to get the data from a table into a buffer
  26. How to find that, a row is updated or not
  27. What are JDBC statements
  28. How MS-Access DB can be accessed over a network, using JDBC API
  29. What is static Synchronized method in JDBC API? Give an example
  30. What are stored procedures? How to call them
  31. What are the salient features of JDBC 2.0
  32. Does the JDBC-ODBC Bridge work with Microsoft J++
  33. The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge
  34. Does multiple concurrent open statements per connection supported by the JDBC-ODBC
  35. How do you know which driver is connected to a database
  36. How is jndi useful for Database connection
  37. How to check null value in JDBC
  38. How the information about db(database) can be retrieved
  39. How vendor Naming registry supports JNDI
  40. How to store images in database
  41. How transactions are performed using JDBC
  42. If I am using JDBC API, do I also have to use ODBC
  43. How to know how much data is truncated
  44. Under what circumstances, that all four drivers are used
  45. What type of driver you use in real-time projects
  46. Commit() and Rollback() methods are defined in which interface
  47. What is Normalization
  48. What are cursor attributes
  49. How to find number of records in result set
  50. What is the difference between triggers and procedures
  51. What are statements in JAVA
  52. What are restrictions on triggers
  53. What are the Normalization Rules
  54. Can we define indexes on a foreign key? Explain pros and cons
  55. Explain the different ways to register a driver
  56. What are pros and cons of using of Type-2 and Type-4 Drivers over Type-1 driver
  57. What is the equivalent method for precompiled SQL Statement in JDBC
  58. What are the Isolation level in JDBC transaction
  59. What are the different types of 2 tier and 3 tier architecture
  60. What are different types of transactions
  61. What are the different types of statements
  62. What is a Connection
  63. What does Class.forName return
  64. What is JDBC
  65. What type of drivers have you used
  66. What are the advantages of JDBC
  67. When you will get error like No suitable driver
  68. What is an outer join
  69. What type of drivers are used for web application
  70. What is de-normalization
  71. What is correlated subquery
  72. What is meant by a ResultSet
  73. What is Statement and PreparedStatement? What is the difference
  74. What are static and dynamic queries
  75. What is the difference between ExecuteUpdate and ExecuteQuery
  76. What is the difference between Union, Unionall
  77. What is JDBC and ODBC and what are the differences between them
  78. What is the difference between Minus, and Intersect
  79. What is the exception thrown by JDBC
  80. What is database null and Java null
  81. What is the latest version of JDBC? What new features are added
  82. What are the conditions applies to varchar variable, when using in procedures
  83. Which Driver is preferable for using JDBC API in Applets
  84. What is CallableStatement and what is its usage
  85. What type of driver called is pure Java driver
  86. What are the Different types of exceptions in JDBC
  87. What are the types of result sets in JDBC 3.0
  88. What is the syntax of URL to get connection
  89. JDBC Drivers properties
  90. What is call level interface
  91. Callable is interface or class
  92. preparedstatement p= new preparedstatement is it possible
  93. How to find the column count in resultset
  94. How to find total column from a resultset
  95. What is the use of prepared statement? Will that precompiled statement be executed
  96. How you will execute the many tables data
  97. What are design patterns
  98. What is meant by primary key and unique key
  99. what is the use connection pooling
  100. What is connection pooling? how do u create connection pooling
  101. What does the method Class.forName returns
  102. Is that compulsory to have Primarykey-forignkey for joint
  103. How does JDBC differ from ODBC
  104. How is database middleware used to access legacy databases
  105. How do you create Connection
  106. What is metadata and it's use
  107. What is callable statement
  108. In JDBC, All the APIs are interfaces
  109. Where is the actual implementation
  110. What is PreparedStatement
  111. How many types of JDBC drivers are there and what are they
  112. How many isolation levels are supported in JDBC and what are they
  113. Difference between servlet and applet method
  114. What is the signature of init method
  115. Difference between Generic Servlet and HTTP Servlet
  116. Difference between Dirty, committed ,phantom, repeatable reads
  117. Write down exceptions those appear in java programs when u write JDBC Programs
  118. What is Stored procedure purpose
  119. What is execute(), executeUpdate() and executeQuery() methods
  120. Different statements in JDBC