Answer Posted / babji009

A view is a virtual table made up of data from base
tables and other views, but not stored separately.
Ex:
CREATE VIEW GOOD1_SUPPLIERS
AS SELECT S#, STATUS, CITY
FROM S
WHERE STATUS > 15;
SELECT * FROM GOOD1_SUPPLIERS;

---------+---------+---------+---------+-----------
SELECT * FROM GOOD1_SUPPLIERS;
---------+---------+---------+---------+-----------
S# STATUS CITY
---------+---------+---------+---------+---
S3 40 PARIS
S4 110 LONDON
S8 30 ATHENS
S7 20 U.S.A

Which component is responsible for db2 startup and shutdown?

1033

---

Why do we need reorg in db2?

984

---

What is the syntax for FETCH in DB2 ?

1206

---

Mention the different locking levels that are available in db2.

1127

---

What is bufferpool in db2?

1049

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9189

---

What is the connection string to connect to the DB2 Database ?

1122

---

Explain about dbrm.

1039

---

What are the various isolation levels possible?

1116

---

How do I delete a table in database?

1016

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1057

---

What is a db2 package?

1048

---

What is the use of db2 optimizer?

1110

---

What are types of indexes?

1066

---

What is a trigger in the db2 database?

1069

---