JDBC Quiz 4 | Englishfreetest.com

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

Here's the exercise 'JDBC Quiz 4 | 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 not a valid type of statement in JDBC?
    A. Statement
    B. PreparedStatement
    C. CallableStatement
    D. QueryStatement
    Question 2: Which of the following is not the standard isolation levels defined by JDBC?
    A. TRANSACTION_NONE
    B. TRANSACTION_READ_COMMITTED
    C. TRANSACTION_READ_UNCOMMITTED
    D. TRANSACTION_WRITE_UNCOMMITTED
    Question 3: Which of the following method can be used to create a connection object?
    A. getConnection(String url, String user, String password)
    B. getConnection(String url)
    C. getConnection(String url, Properties prop)
    D. All of the above
    Question 4: 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
    Question 5: Which of the following is correct about setMaxRows(int)?
    A. setMaxRows(int) method of the ResultSet specifies how many rows a ResultSet can contain at a time.
    B. setMaxRows(int) affects the client side JDBC object
    C. Both of the above
    D. None of the above
    Question 6: Which of the following is used generally used for altering the databases?
    A. boolean execute()
    B. ResultSet executeQuery()
    C. int executeUpdate()
    D. None of the above
    Question 7: Which of the following is a Metadata interfaces of JDBC?
    A. DatabaseMetaData
    B. ResultSetMetaData
    C. Both of the above
    D. None of the above
    Question 8: Which of the following is correct about Statement?
    A. Used for general-purpose access to your database
    B. Useful when you are using static SQL statements at runtime
    C. The Statement interface cannot accept parameters
    D. All of the above
    Question 9: Which of the following is correct about SQL Warning?
    A. SQLWarning objects are a subclass of SQLException that deal with database access warnings
    B. Warnings do not stop the execution of an application, as exceptions do
    C. Both of the above
    D. None of the above
    Question 10: In which of the following type of ResultSet, the cursor can scroll forwards and backwards, and the result set is sensitive to changes made by others to the database that occur after the result set was created?
    A. ResultSet.TYPE_FORWARD_ONLY
    B. ResultSet.TYPE_SCROLL_INSENSITIVE
    C. ResultSet.TYPE_SCROLL_SENSITIVE
    D. None of the above