What is a checkpoint in dbms and when does it occur?
What do you understand by data model?
What is Database testing and What are ways of writing test cases for database testing?
What is the role of tables in database?
Define data, entity, domain and referential integrity?
describe middleware applications that ease the connection of databases to web?
What is snow flake schema design in database? What's the difference between star and snow flake schema?
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?
What are the basic components of notification services?
What is delimiter in dbms?
Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?
Do I need ccp4?
What are the four components of a database system?
What is database partition key?
What are the 3 types of relationships in a database?