Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

Java Database Interface (JDBI) 3 Online Test

Topics Covered

  • DBI
  •  Arguments
  •  Queries
  •  Mappers
  •  SQL Object Batching
  •  SQL Object Data Manipulation
  •  JdbiConfig
  • JDBI third-party integration
  •  JDBI basics

Useful for hiring

  • Java Developer
  • SQL Developer
  • Senior Java Architect

Start hiring job-fit candidates using this assessment

GET A DEMO

"We are impressed with Interview Mocha's comprehensive IT skill test batteries and their ability to provide tailor-made assessments quickly. The results we got from Interview Mocha exceeded our expectations, employees found the tests quick, fun, and a benchmark of their knowledge."

Ajay Garg, Siemens,
Associate Manager
Question

In order to proceed with JDBI, you first need to construct a DBI instance. Which of the following method of instance construction will you use to construct the instance in case where you want connection pooling?

Answer
    • Passing a JDBC DataSource instance to the constructor

    • Passing a combination of a JDBC url, properties, and/or a username and password

    • Using a JDBI specific interface

    • None of the mentioned

Question

You have written a query to retrieve names of students who have more than 75 marks in English. Which of the following will you use to obtain a Handle instance at runtime if you are expecting that the query is going to return some names?

Answer
    • Jdbi.useHandle(HandleConsumer)

    • jdbi.withHandle()

    • jdbi.openHandle()

    • jdbi.openHandlewith()

    • None of the mentioned

Question

withHandle and useHandle can be used to open a temporary handle. But as your callback returns, they immediately release the handle. If you want to manage the lifecycle of the handle by yourself, which of the following will you use?

1. jdbi.open() with try-with-resources block
2. jdbi.open() with try-finally block
3. jdbi.open() without try-finally block

Answer
    • Only 1

    • Only 2

    • Only 3

    • 1 or 2

    • 1 or 3

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO