JDBC Quiz 1 | Englishfreetest.com

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

Here's the exercise 'JDBC Quiz 1 | 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: In order to transfer data between a database and an application written in the Java programming language, the JDBC API provides which of these methods?
    A. Methods on the ResultSet class for retrieving SQL SELECT results as Java types
    B. Methods on the PreparedStatement class for sending Java types as SQL statement parameters
    C. Methods on the CallableStatement class for retrieving SQL OUT parameters as Java types
    D. All mentioned above
    Question 2: The interface ResultSet has a method, getMetaData(), that returns a/an
    A. Tuple
    B. Value
    C. Object
    D. Result
    Question 3: What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?
    A. A Java application
    B. A Java applet
    C. A Java servlet
    D. None of the above is correct
    Question 4: Which methods returns a stream that simply provides the raw bytes from the database without any conversion?
    A. getCharacterStream
    B. getBinaryStream
    C. getAsciiStream
    D. getUnicodeStream
    Question 5: 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
    Question 6: Where is metadata stored in MySQL?
    A. In the MySQL database metadata
    B. In the MySQL database metasql
    C. In the MySQL database mysql
    D. None of the above is correct
    Question 7: Which JDBC type represents a single precision floating point number that supports seven digits of mantissa?
    A. Real
    B. Double
    C. Float
    D. Integer
    Question 8: Which JDBC driver Type(s) can be used in either applet or servlet code?
    A. Both Type 1 and Type 2
    B. Both Type 1 and Type 3
    C. Both Type 3 and Type 4
    D. Type 4 only
    Question 9: Abbreviate the term UDA?
    A. Unified Data Access
    B. Universal Data Access
    C. Universal Digital Access
    D. Uniform Data Access
    Question 10: Which one of the following contains date information?
    A. java.sql.TimeStamp
    B. java.sql.Time
    C. java.io.Time
    D. java.io.TimeStamp