Why do you want to work for us?
Developer Interview Questions
269,410 developer interview questions shared by candidates
Python Qs: 1. Write Program to get the most frequency occurring in file? 2. Given a list and a number find two numbers in the list that sums up to the number given? 3. Write Program to print a tree in level order traversal? 4. Write a function that accept the file, count and return the exact occurrence of a word based on count? 5. List a=[ 1,2,3 none, none] list b=[4,5,3] Output=[1,4,2,5,3,3] ? Sql Qs: Given Employee & Department tables 1. Display ename,dname even if there no employees working in a particular department. 2. List out the lowest paid employees working under each manager, exclude any groups where minsal is less than 1000, sort the output by salary 3. Display the name of employee who earn Highest Salary 4. Display the employee Number and name for employee working as clerk and earning highest salary among the clerks. 5. Display the job groups having Total Salary greater than the maximum salary for Managers. 6. Display the names of employees from department number 10 with salary greater than that of ANY employee working in other departments. 7. Display those employees whose salary is greater than his managers salary. 8. Display the grade and employees name for the deptno 10 or 30 but grade is not 4 while joined the company before 31-DEC-82. 9. Display the Second maximum salary from the table using subquery. 10. Display those employees whose salary is less than his manager but more than salary of other managers. Excel Qs: Given Employee & Department tables 1. Count number of employees whose salary is greater than 20000 2. Get chemistry dept employees total salary 3. what are the use of charts - Pie chart, Bar chart, Line chart, Pivot table, Con(bar & live). 4. Given 2 tables. Fill sales column using HLookup.
Pretend you're given a simple iOS app with a table view and a text field which looks like a search bar. It has methods to call to a remote server to get potential auto complete words. Describe how you would actually implement the iOS side.
Make a progress bar in vanilla JS with setInterval to kick it off. Then make 3 to kickoff at the same time. Then make them kick off at 3 different times (or end at different times). then use recursion to make them kick off one after the other sequentially.
Each round was knock out 1st round : technial ----------------------------------------------------------- 1. Explain storage class in C. 2. Given an array of n integer from 1 to n, 1 value is missing find out which value is missing(optimal solution). 3. explain waterfall model and some basic questions //cleared this round 2nd round : technical ---------------------------------------------------------- 1. Tell me about yourself 2. Explain Normalization and its form with example 3. He gave 3 empty table(3 table structures). 1st table column reference to 2nd table column and 2nd table column references to 3rd table column. Now he asked which normal form it is violating. 4. In the same table he filled data and asked to write a query to get data from the table using join.Inner join worked well and was easy. 5. Gave the following code asked what this code will do void x(struct node* head) { if(head->next==NULL) return; x(head->next); printf("%d ",head->data); } //quite simple that it is the code to print the linked list in reverse order. but he asked me to explain it. Did it very well and he said very good. 6. Puzzle 7 full, 7 half-full and 7 empty bottles of beer are given. you have to divide in group of three such that each group has equal no. of bottles and beers too. //cleared this round too. 3rd round : Managerial round ---------------------------------------------------------------- #old guy probably one of the manager. greeted well Only puzzles and few questions from resume, course taken etc 1.Given a cube, dipped into colour and cut into 5x5. how many cubes we will get coloured(total). //I calculated right but said wrong 2. you have 26 similar balls(colour and weight) and 1 ball which is similar to rest 26 but has weight slightly higher then the rest. how many comparisons you require to find the faulty ball on weighing scale. i knew that it is controlled by power of 3 and ans should be 3. but that time i though 3^4 = 27 and said 4........infact i proved also in 4. he said to optimize it but i didn't............. unfortunately after this round they said you are not qualified for hr round. :( Hope this review will help others to get job at sap labs :)
I'd classify this as the most bizarre and unexpected question which was what are the four tenets of object oriented programming.
What are your salary expectations if you are hired?
How do you dereference a hash in Perl?
What is linked list? Bubble sort
Addition of 2 binary numbers.
Viewing 2501 - 2510 interview questions