Solutions developer Interview Questions in United States
426
Solutions Developer interview questions shared by candidates
If a ping pong ball was stuck in a pipe that is cemented in the ground how would you get it out?
3 Answers↳
The interviewer told me that she was looking for the most creative answer.
↳
First I'd try a vacuum. (Might need a craftsman battery operated one if no power source.) If that didn't work I'd pour water in the hole with maybe a little olive oil to lubricate and try floating it out. Might need to gently nudge it with a stick. If that didn't work I'd check to see if it was above ground level and use a craftsman battery operated pipe saw to cut the pipe and push it out with a chop stick. If it's below ground...it's time for a shovel to dig the pipe out...at least to the point where I get too tired to dig further. Before I spend any money hiring a contractor I'd check back with management to see just how important it is to get the ball out and if there was some way we could make leaving the ball where it was to work to our advantage. Thanks for the fun question. Less
↳
The answer is to pour water down the pipe. The ping pong will float to the top.
Writing a query to find the average and the first three ranks only should come In the output
3 Answers↳
select avg(salary) from (select name, salary,rank() over(order by salary desc) as rank from emp_tbl) where rank <= 3; Less
↳
Could you please provide some more questions from your interview?
↳
Select empid,avg(salary) from (sel empid, salary, row-number() over(order by salary desc) as rank from emp) A Where A. Rank <=3 Group by empid; Less
basic SQL questions
2 Answers↳
a test in about half hour
↳
What is the test about? Is it Multiple choice or query writing?
How long were you dating your wife, before you got married?.
2 Answers↳
Really ? Disgusting
↳
None of your business. This is not related to the position I'm applying for.
Describe the concept of dependency injection.
2 Answers↳
It is proces that provides automatic loading of dependencies for example we write the dependency in pom file and then it loads the dependencies from central repository or locally hosted Maven repository Less
↳
It's a coding pattern to help create loosely coupled classes. A dependency is injected into the dependent class (through the constructor, method, or a property) instead of initializing it inside the dependent class Less
I cannot think of any because I was able to answer at least 50-100 percent of every question of all the questions rendered to me in the interview. On my 2nd technical interview, the guy almost had gotten me based on my Comp. Sci. undergrad days with the "What's' the difference btwn. an ArrayList and a HashTable?"
2 Answers↳
I told him that a HashTable has a key-value pair where as an ArrayList can hold an array of different data types and structures. I don't know if that's correct or not. Less
↳
Through questions like this, interviewers are mostly trying to test your skillset (and its relevance to the role) as robustly as possible, so be prepared for multiple offshoots and followups. It could be a useful exercise to do mocks with friends or colleagues in Avanade to get a real sense of what the interview is actually like. Alternatively Prepfully has a ton of Avanade Solutions Developer experts who provide mock interviews for a pretty reasonable amount. prepfully.com/practice-interviews Less
C#: Static Members, Abstract Classes, ArrayList, . . . . , LinQ. SQL Server: Keys, Compound Key, Joins, . . . . . ASP: Page Life Cycle, Cache, PostBack, . . . . .
2 Answers↳
It just requires to be prepared, and to have good understanding of the technical topics. Less
↳
- string Static member = "static member is to shared member with other classes " - abstract classes = They are declared with the purpose of having the child class provide implementation. - array list = is more dynamic than Array because it doesn't take and number for list it depands on what you get data from database . for example JSON format it show like arraylist without [] ; i hope those answers are helpful Less
What is your experience in writing long documents and do you have any proof?
1 Answers↳
Yes, I wrote a white paper before, let me show you.
