When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

why we create view.

5 Answers  

---

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

How many databases are there?

0 Answers  

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

---

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---