Developer/Programmer interview practical test and solution
Below is a simple practical test which may be asked in interviews and the candidate may be expected to solve the problem within a duration of 40 to 45 mins . I have described the problem and given the solution for it. Question: A list of users and the manager they report to are available in the database. You need to display a). Count of all users who have a manager. b). Count of all users who do not have a manager. c). Display list of users and the managers they report to. Answer: When solving the problem , keep in mind the following: a. Design solution with clean architecture. - Properly layer your solution. Use separate project for data layer, business layer and presentation layer. Have a single solution file which combines all three project files. b. The test is for you to exhibit your problem solving/coding skills. Hence, avoid writing code which binds UI controls (ex: Dropdown,Repeater control) to DataSource controls(SQL, Xml or Object) . This will provide the required result, b...