eQuiz - Bài kiểm tra trắc nghiệm về JDBC - Phần 1

Quản Trị Mạng - Trong bài quiz dưới đây, chúng tôi sẽ giới thiệu với các bạn phần 1 trong loạt bài kiểm tra trắc nghiệm về kiến thức cơ bản JDBC với 15 câu hỏi. Có một số câu hỏi với nhiều phương án lựa chọn - Multichoice, thời gian trả lời đối với mỗi câu là không hạn chế.

eQuiz - Bài kiểm tra trắc nghiệm về JDBC - Phần 1

Chúc các bạn trả lời được nhiều câu hỏi nhất nhé!

  • Câu 1: Which of the following is true regarding the use of the JDBC-ODBC bridge with the applets?
    • Use of the JDBC-ODBC bridge from an untrusted applet running in a browser, such as Netscape Navigator, isn't allowed.
    • It is possible to use the JDBC-ODBC bridge with applets that will be run in appletviewer since appletviewer assumes that applets are trusted.
    • Pure Java JDBC drivers work well with applets. They are fully downloadable and do not require any client-side configuration.
    • All of the above.
  • Câu 2: Which of the following is not an isolation level in the JDBC?
    • TRANSACTION_READ_UNCOMMITTEDB
    • TRANSACTION_READ_ COMMITTED
    • TRANSACTION_SERIALIZABLE
    • TRANSACTION_REPEATABLE_WRITE
  • Câu 3: Which of the following values can be replaced in the place of 1 and 2 below Statement stmt= con.createStatement(1,2)
    • ResultSet. TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY
    • ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE
    • All of the above.
    • Neither of the above,
  • Câu 4: How many JDBC drivers are there?
    • 2
    • 4
    • 3
    • 1
  • Câu 5: Which of the statement is true regarding loading a driver in JDBC. 1. registerDriver(Driver driver). 2. Class.forName(java.lang.String driverclass)
    • 1
    • 2
    • 1, 2
    • Neither of the above
  • Câu 6: Which of the following state ment is true for the Type 2 JDBC driver?
    • A Type 2 driver converts JDBC calls into calls for a specific database
    • This driver is referred to as a "native-API, partly Java driver"
    • As with the Type 1 driver, some binary code may be required on the client machine which means this type of driver is not suitable for downloading over a network to a client
    • All of above
  • Câu 7: Which of the following is false regarding the Type 3 JDBC driver?
    • A Type 3 driver is a JDBC-Net pure Java driver
    • This translates JDBC calls into a database-dependent net protocol.
    • Vendors of database middleware products can implement this type of driver into their products to provide interoperability with the greatesr number of database servers.
    • All of the above.
  • Câu 8: Which of the following allows non repeatable read in JDBC connection class?
    • TRANSACTION_READ_UNCOMMITTEDB
    • TRANSACTION_READ_ COMMITTED
    • TRANSACTION_SERIALIZABLE
    • TRANSACTION_REPEATABLE_READ
  • Câu 9: Which of the following statement is false regarding the exceptions in JDBC?
    • SQLWarning objects are a subclass of SQLException that deal with database access warnings
    • Warnings stop the execution of an application, as exceptions do; they simply alert the user that something did not happen as planned
    • Connection object has a getWarning() method in it.
    • Statement and ResultSet objects have getWarning() methods in it.
  • Câu 10: Which of the following statement is false regarding the different type of statements in JDBC?
    • Regular Statement (use createStatement method)
    • Prepared statement (use prepareStatement method)
    • Callable statement (use prepareCall).
    • Interim statement (use jdbcCall).
  • Câu 11: Which isolation level prevents dirty read in JDBC, connection class?
    • TRANSACTION_READ_UNCOMMITTEDB
    • TRANSACTION_READ_ COMMITTED
    • TRANSACTION_SERIALIZABLE
    • TRANSACTION_REPEATABLE_READ
  • Câu 12: Which of the following allows phantom read in JDBC, connection class?
    • TRANSACTION_READ_UNCOMMITTEDB
    • TRANSACTION_READ_ COMMITTED
    • TRANSACTION_SERIALIZABLE
    • TRANSACTION_REPEATABLE_READ
  • Câu 13: ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database?
    • True
    • False
  • Câu 14: The data defined by th class are referred to as member variables or instance variables?
    • True
    • False
  • Câu 15: The Java compiler requires that a source file use the ... filename extension?
    • .h
    • .java
    • >java
    • .class
Thứ Sáu, 22/03/2019 16:09
3,52 👨 808
0 Bình luận
Sắp xếp theo