Answer / s

CREATE TABLE AAA
LIKE TABLE BBB;

Answer / nag(igate)

the like will create the same table structure and it will
not copy data from existing table.

How many buffer pools are there in DB2?

2 Answers  

---

What will the COMMIT accomplish?

5 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

What is a collection in db2?

0 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

What is runstats db2?

0 Answers  

---

List down the data types in the db2 database.

0 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

What do the initials DDL and DML stand for and what is their meaning?

2 Answers  

---

What is the role of data manager in the db2 database?

0 Answers  

---

Can we update view in db2?

0 Answers  

---

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---