Answer / basanti

1. Check the volume of data.
2. check whether index need to be rebuild or not.

Have you written applications to retrieve stored images in a table?

0 Answers   Tech Mahindra,

---

Is the server accepting tcp ip connections on port 5432?

0 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,

---

Name two utilities that oracle provides, which are use for backup and recovery.

0 Answers  

---

Describe the purposes and advantages stored procedure?

0 Answers  

---

---

Which parameters are optional in init.ora parameter file?

0 Answers  

---

Why do not you use gnu autoconf or scons for building?

0 Answers  

---

Define join and enlist its types.

0 Answers  

---

What is normalization in dbms?

0 Answers  

---

Why not phenix, the zelinka/otwinoski libraries, etc?

0 Answers  

---

describe and contrast a trigger and a procedure.

0 Answers  

---

Explain the term entity in dbms?

0 Answers  

---