Time remaining
:
:
Test Status
JDBCRANDOMTEST
Ques 1 :
Which of the following statements is false as far as different type of statements is concern in JDBC?
(A) Regular Statement
(B) Interim Statement
(C) Callable Statement
(D) Prepared Statement
Ques 2 :
What MySQL property is used to create a surrogate key in MySQL?
(A) UNIQUE
(B) AUTO_INCREMENT
(C) SEQUENCE
(D) None of the above -- Surrogate keys are not implemented in MySQL.
Ques 3 :
How many types of Statement in JDBC
(A) 2
(B) 3
(C) 4
(D) 5
Ques 4 :
ResultSet.CONCUR_UPDATABLE used with the result set is used
to update the rows directly in the database.
(A) False
(B) True
Ques 5 :
State true or false :- ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
(A) True
(B) False
Ques 6 :
what is jdbc ?
(A) a
(B) b
(C) c
(D) d
Ques 7 :
Which isolation level prevents dirty read in JDBC, connection class.
(A) TRANSACTION_READ_ COMMITTED
(B) TRANSACTION_UNREAD_ COMMITTED
Ques 8 :
How many JDBC drivers are there ?
(A) 1
(B) 2
(C) 3
(D) 4
Ques 9 :
Where is metadata stored in MySQL?
(A) In the MySQL database mysql
(B) In the MySQL database metadata
(C) In the MySQL database metasql
(D) In the MySQL database mysql
Ques 10 :
State true or false . Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
(A) False
(B) True
Ques 11 :
Which of the following allows non repeatable read in JDBC Connection?
(A) TRANSACTION_READ_COMMITTED
(B) TRANSACTION_READ_UNCOMMITTED
(C) TRANSACTION_REPEATABLE_READ
(D) TRANSACTION_SERIALIZABLE
Ques 12 :
Can we update a resultset programmatically?
(A) No
(B) Yes
Ques 13 :
State true or false :- The JDBC-ODBC bridge from Sun's Java Software does not provide network access to desktop databases like Microsoft access by itself.
(A) True
(B) False
Ques 14 :
Which of the following describes the correct sequence of the steps involved in making a connection with a database.
1. Loading the driver
2. Process the results.
3. Making the connection with the database.
4. Executing the SQL statements.
(A) 1,2,3,4
(B) 1,3,4,2
(C) 2,1,3,4
(D) 4,1,2,3
Ques 15 :
Is the JDBC-ODBC Bridge multi-threaded?
(A) NO
(B) Yes
Ques 16 :
Which of the following methods are needed for loading a database driver in JDBC?
(A) registerDriver() method
(B) Class.forName()
(C) Both A and B
(D) getConnection()
Ques 17 :
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
(A) Type 1
(B) Type 2
(C) Type 3
(D) Type 4
Ques 18 :
Which driver is efficient and always preferable for using JDBC applications?
(A) Type-4
(B) Type-1
(C) Type-2
(D) Type-3
Ques 19 :
If your Java application is accessing multiple types of databases at the same time, which type of driver is the preferred driver.
(A) Type-1
(B) Type-2
(C) Type-3
(D) Type-4
Ques 20 :
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.
Submit Answer
Don't Refresh the Page !! ...
