Answer Posted / shaikshavali

if u r using PL/SQL

select distinct id from subs_contacts
where rownum<=10
order by id desc

Is the primary key a clustered index?

609

---

What are packages in db2?

597

---

What is the maximum size of varchar data type in db2?

645

---

Mention the definition of cobol in varchar field.

695

---

Is schema the same as database?

629

---

---

Explain in detail about buffer manager and its functionalities?

564

---

What is a db2 package?

599

---

Explain in brief how does db2 determine what lock-size to use?

597

---

Comment whether the cursor is closed during commit or not.

674

---

is it compulsory commitment control in journal?

2009

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

634

---

What is meant by dclgen?

618

---

What is cobol db2?

568

---

What is database manager in db2?

551

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

630

---