Cognizant Programmer Analyst Trainee interview questions

All type of sorting and searching Some algorithms of sorting Program of searching Oops concept Difference between Python and C Programing of Swapping of 2 numbers without using third variable using C language Defination of Python and C language Define Compiler and interpreter and also mark the difference. Which type of language is python and why What is machine level language

1. What are the differences between OLTP and OLAP systems ? 2. What type of data are stored in a retail database ? 3. How date dimension table can be used as both conformed dimension table and role play based dimension table. 4. What are Top Down and Bottom Up approaches of Data Warehouse designing ? 5. What is Monkey Patching in Python ? 6. Difference between AWS S3 and AWS Redshift ? 7. Name some Cloud Data Warehouse services. 8. Importance of Machine Learning in IT industry. 9. Difference between supervised and unsupervised learning algorithms. 10. Difference between Data Warehouse and Data Lake solutions. 11. Name some Cloud ETL products. 12. An Employee table was given and I was asked to find the employees who are getting 3rd highest salary from each department. 13. Find those employees whose salary is higher than average salary of sales employee. 14. What is dimensional modeling in Data Warehouse ? 15. Give examples of data modification anomalies if a database is not properly normalized. 16. Importance of denormalized tables for analytical systems.