Q.1
Which driver is efficient and always preferable for using JDBC applications?
  • Type-4
  • Type-3
  • Type-2
  • Type-1
Q.2
Which of the following is used to rollback a JDBC transaction?
  • rollback()
  • rollforward()
  • deleteTransaction()
  • RemoveTransaction()
Q.3
Transactions can be described with key properties:-
  • Atomicity
  • Consistency
  • Isolation
  • All of the mentioned
Q.4
Which of the following describes the correct sequence of the steps involved in making a connection with a database.
  • 1 ,3,4,2
  • 1,2,3,4
  • 1,4,3,2
  • 1,2,4,3
Q.5
How many JDBC driver types does Sun define?
  • One
  • Two
  • Three
  • Four
Q.6
The JDBC-ODBC bridge is
  • Multithreaded
  • Singlethreaded
  • Both of the above
  • none of the above
Q.7
To run a compiled Java program, the machine must have what loaded and running?
  • Java virtual machine
  • Java compiler
  • Java bytecode
  • A Web browser
Q.8
Abbreviate the term UDA?
  • Unified Data Access
  • Universal Data Access
  • Universal Digital Access
  • Uniform Data Access
Q.9
Which JDBC driver Type(s) can be used in either applet or servlet code?
  • Both Type 1 and Type 2
  • Both Type 1 and Type 3
  • Both Type 3 and Type 4
  • Type 4 only
Q.10
Which JDBC type represents a "single precision" floating point number that supports seven digits of mantissa?
  • Real
  • Double
  • Float
  • Integer
Q.11
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
Q.12
What is the correct order to close database resources?
  • Connection then Statement then ResultSet
  • ResultSet then Statement then Connection
  • Statement then Connection then ResultSet
  • Statement then ResultSet then Connection
Q.13
Which of the following is not a valid type of ResultSet?
  • ResultSet.TYPE_FORWARD_ONLY
  • ResultSet.TYPE_SCROLL_INSENSITIVE
  • ResultSet.TYPE_SCROLL_SENSITIVE
  • ResultSet.TYPE_BACKWARD_ONLY
Q.14
Which JDBC driver type is the JDBC-ODBC type?
  • Type 1
  • Type 2
  • Type 3
  • Type 4
Q.15
Which of the following is efficient than a statement due to the pre-compilation of SQL?
  • Statement
  • PreparedStatement
  • CallableStatement
  • None of the above.
Q.16
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 Java application
  • A Java applet
  • A Java servlet
  • None of the above is correct.
Q.17
Which methods returns a stream that simply provides the raw bytes from the database without any conversion?
  • getCharacterStream
  • getBinaryStream
  • getAsciiStream
  • getUnicodeStream
Q.18
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?
  • ResultSet.TYPE_FORWARD_ONLY
  • ResultSet.TYPE_SCROLL_INSENSITIVE
  • ResultSet.TYPE_SCROLL_SENSITIVE
  • None of the above.
Q.19
Which is responsible for getting a connection to the database?
  • Driver
  • Connection
  • Statement
  • ResultSet
Q.20
Which JDBC driver Types are for use over communications networks?
  • Type 3 only
  • Type 4 only
  • Both Type 3 and Type 4
  • Type 2 and Type 4 only
0 h : 0 m : 1 s