Answer / s

Column name qualifier is Table name

What is a SELECT statement?

1 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

Is db2 a mainframe database?

0 Answers  

---

What is universal database?

0 Answers  

---

How does coalesce work?

0 Answers  

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,

---

Explain various types of locks in db2?

0 Answers  

---

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,

---

Give the name of some fields form sqlca.

0 Answers  

---

What do you need to do before you do EXPLAIN?

1 Answers  

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---