OA round only A 7 Apti B 1 Schema design and query answering C 2 programming Questions (Java/-) A Basic apti questions. Taps filling a tank, and one of them is removing water Cost price, Selling price, breakeven point - 2 problems When does an angle of 30 degree is made between hour and minute hands between 8-9PM rowing a boat with and against stream, how much time will the person take to row in still water A couple of more problems were there B Design schema for an grocery booking website. 1 The website has a fair amount of customers 2 Customers can place multiple orders 3 Each Order can have multiple items 4 Customers can have multiple shipping addresses 5 One order can be shipped to unique add. only Define Schema, Primary Keys, Foreign Keys, Indexing (if needed) for fast result for the following query, write the SQL for each 1 Name, Contact of all customers who have not placed a single order 2 Name, Email of customers whose Oders have more than 5 items C Programming 1 Chocolate Distribution Given N chocolates, you can select a group of m students and distribute chocolates using the following rule Equal Number should be distributed All students will have more than 1 chocolates There will not be a case where all chocolates will be given to a single students Return true/false if possible to distribue 4 - true 17 - false (hint : prime numbers) Programming 2 Given an array of length of rods [5,4,4,2,2,8] Each time you have to process all rods, until all are exhausted. In each round, pick the smallest length rod and cut the same length from all. print number of processed rod in each round. eg input = [5,4,4,2,2,8] op = [6,4,2,1]
