Practical questions of SQL queries on Joins and Ranking 1. Top 3 salaried employees for each department in Emp and Department tables. 2. Primary key, Foreign key and other constrains. 3. Effect of cascade on delete statement. 4. Joins in update query.
Interview questions are 3 to 4 like, How do you use dot net framework, what are different verbs in Web API, Is SQL used in your application, thats all from my side, enough we have gone through multiple technologies. made fool.
One round was on low level design of a component.
1.) Tell me about yourself, what your day to day activities are at your job 2.) Discuss a time when I took initiative to do something that resulted in a change. 3.) Just one question on Method that takes two arrays [1,2,3] and [3,4,5] processes it like this --> {1,3}, {1,4},{1,5},{2,3}, {2,4}....{3,5}} and print out the number of paired duplicates in the processing. Which is 1 from this example => {3,3}
Whiteboard and notepad problem solving.
STAR behavioral questions.
The question where as following: 1- What you working on Now 2- What was the MOST difficult challenge you worked on 3- How to implement Red and Black Trees
I was asked to elaborate about an example of my technical creativity: present the problem to the interviewer and delineate the solution in quite a detailed way.
Given graph with two dimensional array, some positions will set to 1 and others will be set to 0. find number of continuous islands.
Coding questions are mostly data structure and algorithm related, including binary tree, recursive programming, bit-wise operation etc.
Viewing 291 - 300 interview questions