Scribd Logo
Upload

Welcome to Scribd!

  • 89 views

    JDBC Interview Questions

    Uploaded by

    Rk Patanaik
    The document contains 34 questions related to JDBC and database concepts in Java. It asks about the difference between a database and database management system, how queries are executed, JDBC drivers, establishing database connections, executing queries, result sets, prepared statements, transactions, and savepoints.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    JDBC Interview Questions

    Uploaded by

    Rk Patanaik
    89 views4 pages
    The document contains 34 questions related to JDBC and database concepts in Java. It asks about the difference between a database and database management system, how queries are executed, JDBC drivers, establishing database connections, executing queries, result sets, prepared statements, transactions, and savepoints.

    Original Title

    Jdbc Interview Questions

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains 34 questions related to JDBC and database concepts in Java. It asks about the difference between a database and database management system, how queries are executed, JDBC drivers, establishing database connections, executing queries, result sets, prepared statements, transactions, and savepoints.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    89 views4 pages

    JDBC Interview Questions

    Uploaded by

    Rk Patanaik
    The document contains 34 questions related to JDBC and database concepts in Java. It asks about the difference between a database and database management system, how queries are executed, JDBC drivers, establishing database connections, executing queries, result sets, prepared statements, transactions, and savepoints.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 4
    At a glance
    Powered by AI
    The key takeaways are about JDBC interview questions and how to connect Java applications to databases.

    The main components of JDBC are drivers, connections, statements and result sets.

    Statement objects are used for simple queries while PreparedStatement objects are used for parameterized queries to improve performance and security.

    JAVA Means DURGASOFT

    1
    nd
    DURGASOFT, # 202,2 Floor,HUDAMaitrivanam,Ameerpet, Hyderabad - 500038,  040 – 64 51 27 86,
    80 96 96 96 96, 9246212143 | www.durgasoft.com
    JAVA Means DURGASOFT

    JDBC INTERVIEW QUESTIONS:

    1. What is the difference between Database and Database management system?


    2. How a query could be executed when we send a query to Database?
    3. What is Driver? How many Drivers are available in JDBC? What are the types?
    4. What is JDBC and What are the steps to write a JDBC application?
    5. How to load a JDBC driver?
    6. How to establish a Database connection between java application and Database?
    7. Basically Connection is an interface, how getConnection() will create an object for Connection
    interface?
    8. What is the requirement to use Statement object?
    9. How to execute SQL Queries from a java application?
    10. What are the differences between executeQuery(…), executeUpdate(…) and execute(…)
    methods?
    11. How to create a table dynamically from a jdbc application?.
    12. How to insert records into a table from a JDBC application?
    13. How to update a table from a jdbc application?.
    14. How to delete records from a table from jdbc application?.
    15.What is ment by ResultSet object and How to Fetch the Data from Database?.
    16.Ingeneral execute() method can be used to execute selection group SQl queries for getting the
    data from Database , but execute() return a boolean value true so here how it possible to fetch the
    data from database?
    17.Ingeneral execute() method can be used to execute updatation group SQl queries for updating
    the data on Database , but execute() return a boolean value false so here how it possible to get the
    records updated count value(int value)?
    18. If we use selection group SQL query to executeUpdate() ,what happened?
    19. If we use updatation group SQL query to executeQuery() ,what happened?
    20. What is ment by ResultSet and What are the types of ResultSets are available in JDBC
    application?

    2
    nd
    DURGASOFT, # 202,2 Floor,HUDAMaitrivanam,Ameerpet, Hyderabad - 500038,  040 – 64 51 27 86,
    80 96 96 96 96, 9246212143 | www.durgasoft.com
    JAVA Means DURGASOFT

    21. What is the difference between ScrollSensitive ResultSet and ScrollInsensitive ResultSets?
    22. What is the default ResultSet type in JDBC application and How it is possible to create a specific
    type of ResultSet object?
    23. How to iterate the data from Scrollable ResultSet objuect in both forward and backword
    direction?
    24. How to generate ScrollSensitive Result Set and how to reflect the later updations from database
    automatically to the ResultSet object?
    25. How to insert records into Database throws Updatable ResultSet?
    26. How to perform updations on Database throws Updatable ResultSet?
    27. What is meant by ResultSetMetaData ?How to get The ResultSet metadata of a ResultSet object?
    28. How to display the data with the respective field names
    29. What are the differences between Statement and PreparedStatement? (or) Tell me the
    situations where we should go for PreparedStatement over Statement object.
    30. Hhow to insert number of records into a table through Prepared Statement object.
    31. How to update the database through PreparedStatement object.
    32. How to fetch the data from database through PreparedStatement object.
    33. What is meant by Transaction? How it is possible to maintain Transactions in JDBC applications?
    34. What is meant by SavePoint?How to use Savepoints in JDBC applications?

    3
    nd
    DURGASOFT, # 202,2 Floor,HUDAMaitrivanam,Ameerpet, Hyderabad - 500038,  040 – 64 51 27 86,
    80 96 96 96 96, 9246212143 | www.durgasoft.com
    JAVA Means DURGASOFT

    4
    nd
    DURGASOFT, # 202,2 Floor,HUDAMaitrivanam,Ameerpet, Hyderabad - 500038,  040 – 64 51 27 86,
    80 96 96 96 96, 9246212143 | www.durgasoft.com

    You might also like