what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

How to execute stored procedures?

0 Answers  

---

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

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,

---

---

Mention the downsides of page level lock.

0 Answers  

---

What is cursor stability?

1 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

---

What is an alias and how does it differ from a synonym?

3 Answers  

---

What are foreign keys in db2?

0 Answers  

---

What are the disadvantages of PAGE level lock?

3 Answers  

---