# Arcesium Interview Experience | Off – Campus

Initial Online Screening:

There were 3 questions conducted in hackerrank:

1. I dont remember the first one .
2. Â Your job was to find the number of elements in the set of any number. Only those numbers will be there in set which are isomorphic to the given number.
Input : 11
Output : 9
because 11, 22, 33, 44, 55, 66, 77, 88, 99 are all isomorphic
3. Â It was a tree question.it was tough.

Round 1:

This round was a screening round ( technical + hr )
The interview lasted for 35 – 40 mins. It started with : Introduce yourself.
I did that for 3 mins. Then they asked about the project in my resume. It was done in PHP / HTML / SQL.
It was live so i showed them online.They asked me few questions about it.

Then they Asked me one algorithm question:

1. How to Maximize the profit if you are given the rates of stock in a day array.
I asked them a counter question if we have limit on the number of times we can buy and sell? They said no.
Also if we could sell and buy on the same day.
I gave them O(n) solution for the problem. Using local maxima and minima method.

They then asked me one SQL question:

1.Â  Given two tables.

Product table:

id Name price
1 mobile 20000
2 tv 40000
3 ac 50000

orderhistory Table:

id product id qty
1 2 500
2 1 -200
3 1 -300

In inventory negative qty tells that the product was sold.The question was to generate a report consisting of all the products that were sold and how much was the total sale for that particular product?

select o.pid, product.name, sum(o.qty)*product.price
from orderhistory o
JOIN product product
on o.pid=product.id
GROUP by o.pid, product.name

They then asked questions on OOPS / Java.

Difference between inheritance and abstract classes.

Round 2:

This round went for 1 hr 15 mins