Answer / Vipul Negi

The data might not have persisted due to a database crash or an issue with transaction management. When performing multiple INSERT statements without explicitly starting a transaction and committing it, the data may only exist in memory and could be lost if something goes wrong before committing the changes.nnTo prevent such issues, always use transactions by surrounding your operations inside BEGIN TRANSACTION, COMMIT, or ROLLBACK statements.

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

What is a self join? Explain it with an example?

16 Answers   TCS,

---

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---

Explain about network model?

1 Answers  

---

How to customize error conditions.

1 Answers  

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1 Answers  

---

How to combine two function together?

1 Answers  

---

What are the main phases of database development?

1 Answers  

---

Can an extended stored procedure be called from inside a user-defined function?

1 Answers  

---

Where is dbms used?

1 Answers  

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

1 Answers  

---