Let?s say you have 100,000 records and you want to delete 95,000 at a time and

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?

Question Posted / mihir

3 Answers
10030 Views
eBay, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand..

Answer / manjeet

First select the 5000 records u want to keep.. put it in
memory.. then delete the entire table.. and then put this
5000 record table in place

Is This Answer Correct ?

8 Yes

1 No

Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand..

Answer / pankaj gupta

First create a table using select statement with 5000 records u want to keep.. put it in memory.. then drop/truncate (not delete, that is the basic problem) the entire table.. and then put this 5000 record table in place

Is This Answer Correct ?

2 Yes

0 No

Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand..

Answer / 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

More Database Management Interview Questions

What is a driver in programming?

0 Answers

What is meant by system analysis?

0 Answers

How can I access my database remotely?

0 Answers

Why is databases important in healthcare?

0 Answers

How to open the database in exclusive mode?

0 Answers

What is 2-tier architecture?

0 Answers

Explain the importance of database partitioning.

0 Answers

How to specify transaction or query timeout?

0 Answers

What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

0 Answers

What are the types of distributed database?

0 Answers

What is difference between database and spreadsheet?

0 Answers

how to restore particular schema from rman full backup?

0 Answers HCL,

For more Database Management Interview Questions Click Here