Let?s say you have 100,000 records and you want to delete
95,000 at a time and keep only 5 thousand. But in local
memory you don?t have enough space for 95,000 records. What
do you do in this case? How do you delete without any
problem with time and performance?
Answer Posted / java
Do the batch delete.
ie Delete the set of records in loop and commit the transaction
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define RDBMS.
If I use netlib, will I find many other users to network with?
What does clipper stand for?
Enlist some commands of dcl?
What are the differences between a dbms and rdbms?
Which two can be implemented as a centrally located logical architecture?
Differentiate between nested loop, hash loop and merge join.
What is default value database?
How to handle data if f table are more than one and each table contain thousands of entries?
What are database data types?
List few disadvantages of file processing system.
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
Tell us about some Dot operator queries?
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
What are the two types of database?