1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?

2 Answers   3i Infotech,

---

What is the use of INDEXES option in IMP command ?

2 Answers  

---

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

0 Answers   IBM,

---

What's the difference between delete and truncate ?

0 Answers  

---

What is the example of rdbms?

0 Answers  

---

Explain the terms specialization and generalization.

0 Answers  

---

Why does reading require write privileges on database file?

0 Answers  

---

What is database bloat?

0 Answers  

---

Suppose database is running slow, what will you do?

0 Answers  

---

What is the purpose of a model?

0 Answers  

---

What's difference between dbms and rdbms ?

0 Answers  

---

What is the structure of a database?

0 Answers  

---