Great jobs here.....
Software developer additional questions
Note: some of these questions are easy, some are harder.
If you can’t answer the hard questions, tell us the approach you would take, what you do understand, what you think the result would be- those sorts of things. Then we’ll be impressed. If you just put “I have no idea” or miss out the question it’s not a good look.
Write some sample code to do this in the language of your choice.
*. Imagine we have an integer array of 100 elements. Each elements have some value ranging from 0 to 100. a. Find the sum of all array element and print the value on the screen. b. Find the least non zero value in the array and replace the value with 1000. c. Find the least non zero value in an interval of 10 and replace the value with 999.
- For the Nassi-Schneidermann diagram below, what are the final values of A and B?
| A<-6 | |
| B<-6 | |
| FOR COUNT 1 TO 3 | |
| A<-A – COUNT | |
| B<-B + A | |
| OUTPUT A, B |
- Let us consider a string “SUSSOL”
a. Write a function to print all the possible permutations (different ordering of the characters) for the above string
b. Modify the function to discard duplicates.
*
| id | name | parent |
| 1 | DEPARTMENTS | 11 |
| 2 | CATEGORIES | 11 |
| 3 | DEPARTMENTS SUB 1 | 1 |
| 4 | DEPARTMENTS SUB 2 | 1 |
| 5 | DEPARTMENTS SUB 3 | 3 |
| 6 | CATEGORIES SUB 4 | 2 |
| 7 | CATEGORIES SUB 5 | 6 |
| 8 | CATEGORIES SUB 6 | 7 |
| 9 | DEPARTMENTS SUB 7 | 5 |
| 10 | CATEGORIES SUB 8 | 6 |
| 11 | OFFICE | NULL |
Let us consider table Category with fields id, name and parent.
1. Write an SQL query to retrieve a Full Tree for category name “OFFICE”
2. Write an SQL query to find all the leaf nodes (those with no Children) in the above hierarchal data.
- View this article and comment on what implications it might have for your role with Sustainable Solutions.
- Visit the mSupply web site and view the history page. Make some comments on the frequency of releases and what you can conclude about our quality control.
- Have you used any php or javascript frameworks? State the advantages of a framework. If you haven’t, research either the Codeigniter or ExtJS frameworks and make three comments on one or other.