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.
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.
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.
Given a binary tree, and two nodes, find whether they are siblings or not.
Do you have experience on creating test plan? Do you have experience on Linux commands? What are all the guidelines you will used for automation? Have you created entire framework end to end? when you will do manual testing?
Technical questions
Viewing 361 - 370 interview questions