Explain the Surrogate Key in DBMS.

0 Answers   Genpact,

---

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

0 Answers  

---

How to reorder the table columns (fields)?

0 Answers  

---

How do I convert a spreadsheet to a database?

0 Answers  

---

What is database join?

0 Answers  

---

Why its better to use files than a DBMS when there are multiple users to access the data

0 Answers   Infosys,

---

How does index hunting help in improving query performance?

0 Answers  

---

Is a server a database?

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,

---

What is normalisation and its type?

0 Answers  

---

What are the two types of database?

0 Answers  

---

When is a .FMB file extension is created in Forms 4.5 ?

1 Answers  

---