SQL questions
Programador Analista Sql Server Developer Interview Questions
185 programador analista sql server developer interview questions shared by candidates
Implement a solution for the following scenario. Model a system that allows programmers to get coffee and of course pay for it. Programmers will do the following to get coffee: First gather information regarding which types of coffee are available (espresso, latte macchiato or cappuccino) and pick their personal favorite. This will take 0.5 seconds. Second pay the coffee they want at the cash register using cash or credit. This will take 0.25 second for credit and 0.5 seconds for cash payments. Third find a coffee machine and pick the type of coffee they paid for. The system allows: 10 programmers to pick their favorite type of coffee at the same time 5 programmers to pay their coffee at the same time 2 programmers to get their paid coffee from the machine at the same time A programmer will do the following to get coffee from a coffee machine: find a cup (0.25 seconds) put it under the outlet (0.25 seconds) pick the type of coffee the programmer paid (0.25 seconds) wait till the machine is finished filling the cup (This will take 0.25 second for espresso, 0.5 seconds for latte macchiato and 0.75 seconds for cappuccino.) when the machine is done the programmer will take her cup and leave (0.25 seconds) Measure the following things using 100 programmers: how much coffee is sold (total and per payment type) how much coffee is dispensed by each coffee machine (total and per type of coffee) how much time does the average programmer spend getting her coffee how long did it take the fastest and the slowest programmer to get her coffee Challenge it with 200, 500 und 1000 programmers.
Q: How would you design the game server for a new game ?
1. Detect cycle in a graph 2. Find diameter of a binary tree
Q: Explain how to solve permutation of [a, b, c] so you all combination like [a, b, c], [a, c, b], [a, a, a]
(HR) What challenges you've come across with during your career and how you coped with them?
They asked me to design a Producer-Consumer system and implement it in Java with multithreading, similar to how AWS SQS works.
Write a code to reverse a string?
Analytical question asked by senior management.
Mostly scenario based questions were asked to check your fundamentals and basic concepts on the subject. Eg: Why SSIS is used though every functionality can be achieved through SQL itself?
Viewing 31 - 40 interview questions