What are the database objects?
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?
Explain about User_Defined Exceptions?
What is entity and its types?
Explain what is an Exception ?
Why not phenix, the zelinka/otwinoski libraries, etc?
If I delete a table and then rollback it, do the index on the table remains? What if I drop the table and roll back?Do index on the table remains? What if I truncate the table and roll back? Do the index on the table remains
What are the five important software components of a database management system?
What is normalization and what are the different types of normalization?
What is a database in a website?
What is data in dbms?
What is meant by database management system?
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping