Answer / s

Inner Join return only matching rows whereas Outer Join
returns matching rows from both tables and unmatched rows
from either of the table depending on the join.
RIGHT outer Join returns matching rows and unmatched rows
from the right table.
LEFT outer join returns matching rows and unmatched rows
from the left table.

How do I add a column to a table in db2?

0 Answers  

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

Explain the function done by data manager?

0 Answers  

---

What are data types?

2 Answers  

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

What is a synonym ?

2 Answers  

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

What are the Isolation levels possible ?

5 Answers  

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---