What is the function of buffer manager?
Answer / s
Buffer manager is responsible for reading the data page
from DASD to Virtual storage.
| Is This Answer Correct ? | 4 Yes | 2 No |
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Can you tell me how can you find out the # of rows updated after an update statement?
What is a subselect? Is it different from a nested select?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is an alias?
What do you mean by rollback?
How do I delete a table in db2?
What are db2 tables?
What does db2 mean?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?