Answer / sravani

active log,archieve log, bootstrap dataset is also a log

What is RUNSTATS?

3 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

Why select is not preferred in embedded sql programs?

0 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---

Which component is responsible for db2 startup and shutdown?

0 Answers  

---

How many sub queries can you combine together ?

4 Answers   IBM,

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

How does DB2 use multiple table indexes?

1 Answers  

---

Explain the EXPLAIN statement?

1 Answers  

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---