Explain in detail about buffer manager and its functionalities?
No Answer is Posted For this Question
Be the First to Post Answer
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is cascading rollback?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is lock contention?
What is lock escalation?
When is the access path determined for dynamic SQL?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
what is the Foreign key? explain?
What is a precompiler?
What is the difference between group by and order by?
What is netezza database?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,