Skip to contentSkip to footer

Programmer Trainee Interview Questions

Salaries
Interviews

2,741 programmer trainee interview questions shared by candidates

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.
avatar

Programmer Analyst Trainee

Interviewed at Cognizant

3.5★
Apr 3, 2023

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.

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
avatar

Programmer Analyst Trainee

Interviewed at Cognizant

3.5★
Apr 4, 2023

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

Viewing 1401 - 1410 interview questions

Glassdoor has 2,741 interview questions and reports from Programmer trainee interviews. Prepare for your interview. Get hired. Love your job.