Interested to Buy Any Domain ? << Click Here >> for more details...
Usually, which is more important for DB2 system
performance - CPU processing or I/O access?
- 1 Answers
- 4220 Views
- I also Faced
- E-Mail Answers
Answer / s
I/O is expensive as most the the CPU time is wasted doing
I/O's
| Is This Answer Correct ? | 2 Yes | 1 No |
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
how to resolve -811
Name some fields from SQLCA.
What is difference between rollback and commit?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What does a deadlock mean in DB2?
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is difference between alias and synonym in db2?
What is DYNSLT keyword? How do you perform selection using DYNSLT
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How do you do the EXPLAIN of a dynamic SQL statement?
What does reorg do in db2?
COBOL 
