Answer / swapnil

USING AN INDEX WE CAN ACCESS THE KEY VERY FAST
ON PRIMARY KEY YOU CREATE AN INDEX.

Answer / dilon

index are nothing but primary key in the table...
ex:create table emp(eno numeric(4) not null primary key,
ename char(10) not null,
elocation char(10) not null)
in this example employee number eno is the primary key it is
called as index...

What is a predicate?

1 Answers  

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

What os does db2 run on?

0 Answers  

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

Which one allows duplicate values Union or Union All ?

3 Answers  

---

What is a buffer in memory?

0 Answers  

---

Give some example of statistics collected during RUNSTATS?

1 Answers  

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

What is clone table?

0 Answers  

---

Explain the use of the WHERE clause?

1 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---