Zoho 3rd Round
Zoho 3rd Round
Zoho 3rd Round
2. Create an engine that can process the user query. The main focus is not the
logic but System Design.
1. How the created query engine scales out perfectly even upon adding new
features later?
2. How do we create a system that can handle the following inputs and process
the input query?
Question:
1. Given a table containing a set of 10 employees with respective fields:
ID Name Age Designation Department Reporting To
2. Show all employee data
3. Process the query:
1. Get input from the user until presses exit.
2. Get field value to compare, comparison operator as input
1. If the field value is age (int data type), supported comparators: >, <, !=,
==
2. If the field value is of string data type, supported comparators:
‘startswith’, ‘contains’, ‘endswith’, ‘notcontains’, ‘equals’ and ‘notequals’.
3. Use ‘AND’ in default for queries with multiple checks.
4. Eg: age > 30 and age < 50 and department contains finance and reporting to A
4. Show the reporting to hierarchy for the given employee name: J -> I -> F -> D
-> C -> B-> A
5. Show the employees reporting to the given manager.
6. Show summary of Department, Designation, ReportingTo.
b. apply the same for multiple conditions using ‘AND’ for each condition. (similar
to ‘where’ class in SQL using multiple columns).
Task 3: print reporting tree of the given employee.
Task 4: print the employees reporting to the given manager.
Task 5: print summary of Department, Designation, ReportingTo.(menu driven)
4.event management
5.TICKET RESERVATION SYSTEM
1. first simple reservation for 50 seats from A to F.
2. After stations are added in middle like B, C, D, E. Where people can board
any station and get down at any station assuming train is going from A to F.
3. Then Waiting list are to be added after 50 seats reserved and if any reserved
seat is cancelled we have to check the waiting list and need to confirm the seat if
possible.
4. After which we need to print the details of the PNR details.
6. The bank has initially three customers.There were around eight modules .
1. Account Login
2. Purchase
Account Login
Giving customer id and password .Password should be encrypted and stored
Encryption is like A-> B, B->C
a-> b, b->c, c->d
0->1, 1->2
On successful login, it should print the account details
1.Create Gift Card
2. TopUp
3.Transaction History
4.Block
5.Logout
1.Create Gift Card
Gift card with 5 digit card no and 4 digit pin number will be genrated
2.TopUp
For topup, amount need to be reduced from main account balance and added to gift
card
3.Transaction History
Should print all the transaction details of a particular gift card
4.Block
If the card is blocked, shouldn’t be available for topUp, Purchase.the amount in
gift card should be transferred to main account
5.Logging Out
After log out, should go to main module,
2.Purchase
Login to the gift card
Purchase Amount
Then print Available balance
7.Redeem points :
For Every 100 rupee purchase, 1 reward point is added .For 10 reward points, 10
will be added to main account
8.Doing for Multiple gift cards
SET a 20
GET a 20
SET b 30
GET b 30
SET a 10
GET a 10
UPDATE c 40 No variable named “c”
SET c 30
COUNT 30 2
COUNT 40 null
UNSET a
GET a null
EXAMPLE 2:
GET a null
SET a 30
GET a 30
EXAMPLE 3:
SET a 30
BEGIN
GET a 30
SET a 40
GET a 40
SET b 40
GET b 40
ROLLBACK
GET b null
GET a 30
EXAMPLE 4:
BEGIN
SET a 40
SET b 40
SET c 50
COUNT 40 2
BEGIN
COUNT 40 null
COMMIT
COUNT 40 2
BEGIN
SET c 10
GET c 10
ROLLBACK
GET c 50
Round 3:
Given an employee date base.
2. Display the details of all the tolls…..like what are all the vehicles(vehicle
number) passed
that respective toll and the amount each vehicle paid……and the total amount charged
in
that toll.
3. Display the details of all the vehicles …….like what are all the journeys did it
take….the
start and destination of the same……tolls it passed during that journey….amount paid
in
that journey…..and the total amount paid by that vehicle.
4. Assume the highway as a circular path……we have to find the short route and
identify
the tolls between that route and calculate the amount.