can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

What is REORG? When is it used?

4 Answers  

---

Can one database have multiple instances?

0 Answers  

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

What is reorg in database?

1 Answers  

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

---

Explain the function of data manager.

0 Answers  

---

Which catalog table stores referential constraints?

1 Answers  

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---