Answer / bawa

- Dirty read—Dirty reads occur when one transaction reads data that has been written but not yet committed by another transaction. If the changes are later rolled back, the data obtained by the first transaction will be invalid.

- Nonrepeatable read—Nonrepeatable reads happen when a transaction performs the same query two or more times and each time the data is different. This is usually due to another concurrent transaction updating the data
between the queries.

- Phantom reads—Phantom reads are similar to nonrepeatable reads. These occur when a transaction (T1) reads several rows, and then a concurrent transaction (T2) inserts rows. Upon subsequent queries, the first transaction (T1) finds additional rows that were not there before.

Answer / manoj pandey

Check the following link for differences:
http://sqlwithmanoj.wordpress.com/2011/07/20/dirty-reads-and-phantom-reads/

Answer / sknkarthik

dirty read allow a row changed by one transation to be read
by another transaction before any changes have been commited.
non repeatable read is whre one transaction chage a row
another transaction alter or delete the row then the 1st
transacton reread the row with the different value in the
second time.
phantom read is whre one transcation read the row that
satisfied the where condiotion the the 2nd transcation
insert the row with the where condiotion then the 1st
transaction reread the satisfied the where condition get the
phantom row in the second time

Why do you use a data source object for a connection?

0 Answers  

---

What is device controller?

0 Answers  

---

How MS-Access DB can be accessed over a network, using JDBC API?

0 Answers  

---

Which database is used for java?

0 Answers  

---

What is database connection pooling? Advantages of using a connection pool?

0 Answers  

---

Is odbc an api?

0 Answers  

---

java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }

6 Answers   CTS,

---

How do you know which driver is connected to a database?

3 Answers  

---

What are the differences between stored procedure and functions?

0 Answers  

---

What is Type-3 Driver and when this driver is used?

3 Answers   Wipro,

---

What is an outer join?

3 Answers   Infogain,

---

wahts is mean by primary key and unique key?

7 Answers   Wipro,

---