How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  

---

what is static sql? what is dynamic sql? Give me details

3 Answers  

---

What is load utility in db2?

0 Answers  

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---

What is consistency token in db2?

0 Answers  

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

What is the usage of open cursor command?

0 Answers  

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

what are stage one indexable predicates?

1 Answers  

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---