Answer / abhisek

Database Descriptor is a DB2 component that limits access
to the database whenever objects are created,altered or
dropped.

Answer / deepika

A DBD also contains other information about accessing tables in the database. DB2 creates and updates DBDs whenever their corresponding databases are created or updated.

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

Which is faster delete or truncate?

0 Answers  

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  

---

How does db2 sample database connect?

0 Answers  

---

What is sqlca?

0 Answers  

---

What kind of database is db2?

0 Answers  

---

Explain about mirror activator disk mirroring?

0 Answers  

---

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

Compare a subselect to a join?

1 Answers  

---

What are the rules for db2 programming?

0 Answers  

---