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?

3 Answers   eBay,

---

How do you maintain a database?

0 Answers  

---

What is stored in a database?

0 Answers  

---

Define dbms.

0 Answers  

---

Write a query to create a duplicate table with and without data present?

0 Answers  

---

---

What is the difference between indexes,views,synonyms?

0 Answers   HCL,

---

Enlist the advantages of normalizing database.

0 Answers  

---

Explain how RDBMS software deals with deadlocks.

1 Answers  

---

Tell us about some Dot operator queries?

0 Answers   Atos Origin,

---

What is field record and table in database?

0 Answers  

---

What is the importance of query in database?

0 Answers  

---

What is the use of drop command and what are the differences between drop, truncate and delete commands?

0 Answers  

---