Answer / s

Filter Factor is the percentage of rows that qualify for a
coded predicate. It determines if an index will be used.

Answer / deepak dada

filter factor is a reciprocal of cardinality factor
and cardinality factor is no of distinct rec in particular
col

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers  

---

What are the functions in DB2?

3 Answers   Satyam,

---

How many buffer pools are available in db2?

2 Answers  

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---

---

What are common abends

1 Answers   SPIC, Virtusa,

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

what is difference between Plan and Package

1 Answers   Syntel,

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

Explain packages.

0 Answers  

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---