Answer / s

Data Definition Language CREATE, ALTER, DROP
Data Manipulation Language SELECT, INSERT, UPDATE, DELETE

Answer / komal riaz

DDL(Data Definition Language) is used for the manipulation
of Tables in SQL. This involves three functions CREATE,ALTER
and DROP.
Whereas DML(Data Manipulation Language) is used for the
manipulation of data in the tables. This involves four basic
functions SELECT,INSERT,UPDATE,DELETE.

What does runstats do in db2?

0 Answers  

---

What is the difference between base table and view?

7 Answers  

---

How to create backup table in db2?

0 Answers  

---

What is precompiler in db2?

0 Answers  

---

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  

---

what's the error code for Unique Index Violation?

2 Answers  

---

How to see the structure of db2 table??

4 Answers   IBM,

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---