Quiz  /  JDBC Gate & PSU MCQ Questions With Answers

  • 1. 
    In a ResultSet object, the ___________ methods to retrieve the value of a given column.

  • POST()
  • GET()
  • setXXX()
  • getXXX()

  • 2. 
    The ……………… object provides you with methods to access data from the table.

  • ResultSet
  • Parametrized
  • TableStatement
  • Condition

  • 3. 
    Which interface will NOT accept input parameters

  • Statement
  • PreparedStatement
  • CallableStatement
  • PrepareStatement

  • 4. 
    Which method returns an integer as its result?

  • execute()
  • executeUpdate()
  • executeQuery()
  • extract()

  • 5. 
    Which class/interface manages a list of database drivers?

  • Driver
  • DriverManager
  • ManageDriver
  • DriverCon

  • 6. 
    What is the return type of executeUpdate() method?

  • byte
  • short
  • int
  • long

  • 7. 
    Which of the following is efficient than a statement due to the pre-compilation of SQL?

  • Statement
  • PreparedStatement
  • CallableStatement
  • None of the above

  • 8. 
    Driver types are used to categorize the technology used to connect to database.

  • True
  • False

  • 9. 
    What is true about DriverManager class?

  • It is class from java.lang package
  • It is a class from java.sql package
  • It is a interface from java.sql package
  • It is a class from java.lang package

  • 10. 
    Where is metadata stored in ORACLE?

  • In the ORACLE database metadata
  • In the ORACLE database metasql
  • In the ORACLE database ORACLE
  • None of the above is correct

  • 11. 
    What must be the first characters of a database URL?

  • db,
  • db:
  • jdbc,
  • jdbc:

  • 12. 
    Transactions can be described with key properties:-

  • Atomicity
  • Consistency
  • Isolation
  • All of the mentioned

  • 13. 
    What is the package name of "Class"?

  • java.util
  • java.sql
  • java.lang
  • java.io

  • 14. 
    The corresponding SQL type for the boolean JAVA type is_____

  • BOOLEAN
  • BIT
  • BOOL
  • BYTE

  • 15. 
    Parameterized queries can be executed by?

  • ParameterizedStatement
  • PreparedStatement
  • CallableStatement and Parameterized Statement
  • All kinds of Statements
Report Question
warning
access_time
  Time