Answer / s

ALTER is a DDL (data definition language) statement to make
changes to the description of the table.

Answer / om yadav

modify the structer of table.
1. add column.
2. midify column.
3. drop column.
4. add or remove constraint.

Answer / jitendra

ALter is to change db2 table definition. for eg:
Alter tablename
add column number(11,2)

What is the FREE command?

1 Answers  

---

Mention data types used in db2 ?

0 Answers  

---

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---

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

2 Answers   Cap Gemini,

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---

What is the result of open cursor statement?

0 Answers  

---

How to check last update on table in db2?

0 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---