JDBC Quiz 5 | Englishfreetest.com

  • Do test 20 minutes
  • Number Questions: 10 questions
  • By: englishfreetest.com
Do test

Here's the exercise 'JDBC Quiz 5 | Englishfreetest.com' about Technical Quiz - Technical Tests.


Put your knowledge about all things technology to the test Because everything tech, from computers and the internet to software and big data, changes rapidly on a day-to-day basis, it’s now a must to stay up to date with the technology that dominates our modern day lives. Are you up to speed on what’s going on in the tech industry today? Take our quiz to find out. Test how much you know about technology

You can find more to the lesson and more exercises. Technical Quiz - Technical Tests in here.

Finally, click here to "Test" for start practice exercise .

  • Test content
    Question 1: Which of the following is correct about driver interface of JDBC?
    A. JDBC driver is an interface enabling a Java application to interact with a database
    B. The JDBC driver gives out the connection to the database and implements the protocol for transferring the query and result between client and database
    C. Both of the above
    D. none of the above
    Question 2: What is JDBC?
    A. JDBC is a java based protocol
    B. JDBC is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases
    C. JDBC is a specification to tell how to connect to a database
    D. Joint Driver for Basic Connection
    Question 3: What is the use of blob, clob datatypes in JDBC?
    A. These are used to store large amount of data into database like images, movie etc which are extremely large in size
    B. These are used to store XML data
    C. Both of the above
    D. None of the above
    Question 4: Which of the following is used generally for reading the content of the database?
    A. ResultSet executeQuery()
    B. boolean execute()
    C. int executeUpdate()
    D. None of the above
    Question 5: Which of the following type of JDBC driver should be used if your Java application is accessing multiple types of databases at the same time?
    A. Type 1
    B. Type 2
    C. Type 3
    D. Type 4
    Question 6: Why will you set auto commit mode to false?
    A. To increase performance
    B. To maintain the integrity of business processes
    C. To use distributed transactions
    D. All of the above
    Question 7: Which of the following is not a valid type of ResultSet?
    A. ResultSet.TYPE_FORWARD_ONLY
    B. ResultSet.TYPE_SCROLL_INSENSITIVE
    C. ResultSet.TYPE_SCROLL_SENSITIVE
    D. ResultSet.TYPE_BACKWARD_ONLY
    Question 8: Which of the following is correct about connection pooling?
    A. Database vendor's help multiple clients to share a cached set of connection objects that provides access to a database
    B. Clients need not create a new connection everytime to interact with the database
    C. Both of the above
    D. None of the above
    Question 9: Which of the following is not the standard isolation levels defined by JDBC?
    A. TRANSACTION_REPEATABLE_READ
    B. TRANSACTION_NONE
    C. TRANSACTION_SERIALIZABLE
    D. TRANSACTION_REPEATABLE_WRITE
    Question 10: Which of the following is correct about DriverManager.registerDriver() method call?
    A. This method is used to register the database driver
    B. This static method is used in case you are using a non-JDK compliant JVM, such as the one provided by Microsoft
    C. Both of the above
    D. None of the above