permaculture playing cards
The moose likes JDBC and Relational Databases and the fly likes JDBC , Transaction related question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC , Transaction related question" Watch "JDBC , Transaction related question" New topic

JDBC , Transaction related question

prat de

Joined: Sep 15, 2003
Posts: 22
please share ur answers/opinions regarding foll questions:
Q. Which of the following will not get the data from the first column of ResultSet rs, returned from executing the following SQL statement: “SELECT name, rank, serialNo FROM employee”

a. rs.getString(0);
b. rs.getString("name");
c. rs.getString(1);
Q. Which of the following statements about Transactions are true ?
a. A database does not support Transaction. In such a scenario, it is still possible to control transactions using JDBC API.
b. It is possible to set Transaction Isolation levels on the Statement object if we want the Statement to execute within a Transaction.
c. Assigning the CONCUR_UPDATEABLE property to ResultSet offers the highest level of concurrency.
d. It is possible to specify the database table index which should be used in a JDBC statement through hints.
- prat.
Joe Ess

Joined: Oct 29, 2001
Posts: 9189

please share ur answers/opinions regarding foll questions:
I am:
a. doing my homework
b. doing my take-home exam
c. fond of multiple choice questions.
The answers to all your questions are in the JDBC Getting Started Guide

[How To Ask Questions On JavaRanch]
I agree. Here's the link:
subject: JDBC , Transaction related question
It's not a secret anymore!