DO Recruitment Pre - Interview Exercise
This exercise is meant to examine your analytical thinking skills, your programming proficiency, database query skills and general knowledge in current technologies. Read through the questions carefully before answering.
This exercise is meant to examine your analytical thinking skills, your programming proficiency, database query skills and general knowledge in current technologies. Read through the questions carefully before answering.
The following section consists of logical problems. Read carefully before answering.
The following section consists of logical problems. Read carefully before answering.
There are three boxes. One is labeled APPLES, another is labeled ORANGES and the third is labeled APPLES AND ORANGES. You know that all three boxes are labeled incorrectly. You may ask me to pick a fruit from any of the boxes, after which you should be able to re-label all the boxes correctly. Which would you choose from?
APPLES
ORANGES
APPLES AND ORANGES
ANY
Adwoa has 12 black socks and 12 white socks in her drawer. In complete darkness and without looking, how many socks must she take from the drawer in order to be sure to get a pair that match?
3
7
9
12
In a zoo, there are snakes, elephants and ostriches. A man counted 50 eyes, 40 legs and 6 trunks. How many snakes are in the zoo?
5
11
22
28
A man received 150 cedis from his father and in turn gave his son 100 cedis. How much richer are the two recipients combined?
50
100
150
250
A frog is at the bottom of a 30 metre well. Each day, it gathers enough energy to for a single 3 metre jump up then well. Exhausted, it then hangs there for the rest of the day. At night, while it sleeps, it slips 2 metres back down. How many days does it take to get out of the well? NOTE: Assume after the first leap its hind legs are exactly 3 metres up the well. Its hind legs must clear the edge of the well for it to escape?
27
28
29
30
The following section is made up of database related questions
The following section is made up of database related questions
An ecommerce application stores users’ orders in a database. An order can contain multiple items, each having a name, item code, quantity and unit price. Likewise, a user can have multiple orders. A section of the database is shown in the diagram. Using the diagram as reference, choose the queries that will give you the information required in the next four questions.
An ecommerce application stores users’ orders in a database. An order can contain multiple items, each having a name, item code, quantity and unit price. Likewise, a user can have multiple orders. A section of the database is shown in the diagram. Using the diagram as reference, choose the queries that will give you the information required in the next four questions.
The total number of items customer number 1 has ordered
Select quantity from order_items, `order` where order.customer_no = 1
Select count(`order`.order_no) from order_items, `order` where order.customer_no = 1
Select count(quantity) from order_items, `order` where order.customer_no = 1
Select sum(quantity) from order_items, `order` where order.customer_no = 1
The total value of all customer 1’s orders
Select sum(unit_cost) from order_items, `order` where order.customer_no = 1
Select count(unit_cost) from order_items, `order` where order.customer_no = 1
Select sum(unit_cost * quantity) from order_items, `order` where order.customer_no = 1
Select count(unit_cost * quantity) from order_items, `order` where order.customer_no = 1
The most popular item (most ordered item) across all customers.
Select item_code, quantity from order_items group by item_code order by quantity desc limit 0, 1
Select item_code, count(quantity) from order_items group by item_code order by count(quantity) desc limit 0, 1
Select item_code, sum(quantity) from order_items group by item_code order by sum(quantity) desc limit 0, 1
Select item_code, sum(quantity) from order_items group by item_code order by count(quantity) desc limit 0, 1
The item that has generated the most revenue across all customers
Select item_code, sum(unit_cost) from order_items group by item_code order by sum(unit_cost) desc limit 0, 1
Select item_code, count(unit_cost) from order_items group by item_code order by count(unit_cost) desc limit 0, 1
Select item_code, count(unit_cost * quantity) from order_items group by item_code order by count(unit_cost * quantity) desc limit 0, 1
Select item_code, sum(unit_cost * quantity) from order_items group by item_code order by sum(unit_cost * quantity) desc limit 0, 1
The following questions are related to software development
The following questions are related to software development
Which of the following are loops (incorrect answers attract a negative score)
If...else
For
While
Do...while
Which of the following statements is true (incorrect answers attract a negative score)
All APIs are interfaces
All APIs are web services
All web services are APIs
ReST and SOAP are web service technologies
Which of the following allow one application to directly access the fun
Web services
SDKs
Databases
Files
________ is the process of finding errors and fixing them within a program
Compiling
Testing
Debugging
Executing
The process of accessing every element in a collection sequentially is termed
Sorting
Merging
Inspecting
Traversal
{"name":"DO Recruitment Pre - Interview Exercise", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"There are three boxes. One is labeled APPLES, another is labeled ORANGES and the third is labeled APPLES AND ORANGES. You know that all three boxes are labeled incorrectly. You may ask me to pick a fruit from any of the boxes, after which you should be able to re-label all the boxes correctly. Which would you choose from?, Adwoa has 12 black socks and 12 white socks in her drawer. In complete darkness and without looking, how many socks must she take from the drawer in order to be sure to get a pair that match?, In a zoo, there are snakes, elephants and ostriches. A man counted 50 eyes, 40 legs and 6 trunks. How many snakes are in the zoo?","img":"https://cdn.poll-maker.com/258836/db-diag2.jpg?sz=1200-000000100053"}