If we have 100 records in the PF, we deleted all the records
then what is the Size of the PF?
Answers were Sorted based on User's Feedback
Answer / divyananda
The memory will be held untill you compress the PF
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / rama
If it is a physical sequential file the size of the file
becomes 0.
| Is This Answer Correct ? | 5 Yes | 2 No |
What is cursor stability?
How will you return the number of records in table?
How do you do the EXPLAIN of a dynamic SQL statement?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
Mention the downsides of page level lock.
What is the difference between Primary key and unique index?
What are simple, segmented and partitioned table spaces ?
What is Declaration Generator(DCLGEN)?
What does DML stand for and what are some examples of it?
Explain the function of data manager.
How can we define a table? How can we apply SEARCH ALL on it ?
what is plan? is plan executable or package?