Answer Posted / uday singh

The main difference between DBMS and RDBMS is DBMS does not
impose any constraints or security with regard to data
manipulation it is user or the programmer responsibility to
ensure the ACID(Atomicity Consistency Isolation and
Durability) PROPERTY of the database whereas the rdbms is
more with this regard bcoz rdbms define the integrity
constraint for the purpose of holding ACID PROPERTY.

Why is group-clause used?

907

---

What is database url?

910

---

What are indexes? Mention the differences between the clustered and non-clustered index?

908

---

What is data independence and also explain its types?

849

---

Are databases stored on servers?

970

---

What is file manager?

875

---

What are the basic components of notification services?

1029

---

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?

1816

---

Define database model.

993

---

What is an image database?

878

---

What is database partition key?

880

---

How to move a multi-file database?

995

---

Which database is best for storing large data?

847

---

Explain what are called fat clients and fat servers?

982

---

What's the difference between star and snow flake schema?

994

---