MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Science
Jdbc
Quiz 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page