Answer / santoshkumar jangamashetti

example for Phantoms:

• Transaction1 opens a cursor and reads account
information, keeping a running sum of the total balance for
the selected accounts.
• Transaction2 inserts a new account that falls
within the range of accounts being processed by
Transaction1, but the insert occurs after Transaction1 has
passed the new account.
• Transaction2 commits the insert.
• Transaction1 runs a query to sum the values to
check the accuracy of the running total. But the totals
will not match.

Answer / prachi

In read stability,
if t1 is performing read and t2 has done some changes in
the database which has same crieteria as T1, these new
updates or rows added by t2 is called phantom, which will
not be read during the read stability lock...

What are the contents of dclgen?

0 Answers  

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

When will you chose to run RUNSTATS?

1 Answers  

---

How can you count the number of rows from a table tab?

0 Answers  

---

what is the difference between where clause and having clause

2 Answers   IBM,

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

What is meant by union and union all?

0 Answers  

---

What is a storage group (stogroup)?

0 Answers  

---

Why do chiropractors use drop table?

0 Answers  

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---