Deloitte interview

Just had a telephonic interview with Deloitte. And Deloitte exploited Hybris real bad.

Hybris Questions:

1. Lots of question about items.xml.
2. Difference between Collection and relation?
3. Dynamic attribute in an item type.
4. How to declare an item?
5. How to extend an item?
6. Structure of items.xml.
7. Various tags in items.xml.
8. Difference between type and item.
9. How to ensure that some particular attribute is not added to DB through persistence. Something to do with dynamic attribute.
10. Catalog vs Catalog version?
11. How many active catalogs are there?
12. How to make more than one active catalog?
13. Architecture of cockpit.
14. What are interceptor? 
15. How many types of interceptor?
16. What is modelcontext?
17. Difference between save() and saveall() in modelservice.
18. Entire hierarchy of catalog. Whatever that means!
19. Relation between cronjob and trigger.
20. Flexiquery.getbyexample() or something like that.
21. Impex structure.
22. Lazy loading in hybris.
23. Price Groups in Hybris
24. What if the delimiter in impex file i.e.semicolon(;) is changed to something else. How can this be done? 

Then it was plain ol' Java stuff. Its remarkable how the java questions were so easy while Hybris ones were tougher beyond recognition.

1. What is dynamic polymorphism, with examples.
2. Difference between final, finalize and finally.
3. Daemon threads
4. Difference between ArrayList and LinkList.
5. Difference between Set and HashSet.
6. Objects in a JSP.
7. Life-cycle of JSP.
8. Tag files.

Now, all this and more was bombarded within 15 minutes. And my eager interviewer was asking the next question before i can answer the previous one.

Gotta say i feel quite drenched. Need a chilled cold coffee, though a nice fuck wont hurt either!!!!

One97 Communications Limited

Interview: One97 Communications Limited

Location : B-121, Sector -5 , Noida

Date : 20 August 2013

                Within a kilometer from Noida Sector-15 metro station. Got ripped by auto-wala. Paid him 40 bucks for getting from metro to the office. While returning i paid only 10 bucks for the same journey. Great way to start an interview.

Written test has three sections.

1. Aptitude

2. Java (objective type)

3. Programs and sql queries.

Aptitude:

1.  M N O

     M N O

     M N O

+   M N O

-------------

    P O N

-------------

Find the value of  M, N, O and P ? (And stop giggling on the double meaning.)

2. 

How many triangles are in this large triangle?

Ans.  543 (weird, huh. There is an entire blog post about how weird this question is...How many triangles in my cat?)

3. A murder took place after 10 pm at night. The lone witness recorded that the clock stopped at the exact time of murder. Later it was revealed that the hands on the clock remained on the same position, however their position were interchanged. What was the actual and claimed timing of the murder?

4. Find the next number in the series ( 1 2 4 13 81 122). (I am missing a number or two).

Lots of questions about how to tell the order of arrangement of items.

Example: 5 books are arranged on a shelf. A is next to B, C is between A and D and similar stuff.

5. In a game of chess i defeated "the only brother of daughter of my grandmother". Who did i defeat?

Ans. Father

Java

Very easy questions about boolean expressions, threads, garbage collection and inner classes.

Q.1 Which expression is same as (a>=b)

Ans.    !(a<b)

Programming

Q.1 WAP to sort an alphanumeric array of String.

   Example: {a1,j3,b2,v4} should be sorted to {a1,b2,j3,v4}.

Q.2 WAP to reverse the order of words (not characters) in  a character array.

  Example: cat boy bell bottle                      becomes                      

                 bottle bell boy cat

Q.3 WAP to print all absolute numbers between 100 and 999. Absolute numbers are those where left digit is always smaller than the right digit. Example: 345

Q.4 Suppose on facebook a user puts his status and then others comment on that status.

So, a situation like this evolves:

User 1 : My status 1

FB user 2: comment1

FB user 3: comment2

FB user 2: comment3

FB user 4: comment5

User 2 : My status 2

FB user 2: comment6

FB user 3: comment7

FB user 2: comment8

All this is stored in a table status_table as ID, Status, FB_User, Comment

Find the number of comments done by each user on a particular status.

Q.5 There are two tables

Customer (customer_id, name ,phone ,address)

Order(Order_id, date, customer_id, quantity)

Write a query to display the order of each customer along with his name and other details. Their may be some customers in customer table that do not have any order in order table. So, in front of their name, address, etc. their order details should all be displayed as NULL.