Automatic Data Processing (ADP) Associate Consultant Interview Questions and Answers

• Q1. Who developed c
  View Answers (1)

• Q1. Coding problem statement
  Add Answer

What is a Linux. Basic computers. NTP IP TCP Ansible useradd userdel

Round duration - 150 minutes
Round difficulty - Hard

Oracle’s aptitude test is one of the longest aptitude tests I appeared for in my placement phase. It was around 2hrs 30mins long.
Questions were from basically every subject I had studied like OS, CN, SDLC, etc. Questions weren’t too hard but the difficult part about this test is that it was divided into sections and sub-sections.
Each sub-section had its own independent time interval so bringing it down to like 10 quant questions in 14 minutes might sound easy but it’s not. So managing time is the only difficult part of this round.

• Q1. SQL Question

  Which is the correct SQL query to select the top 5 numbers from the given data?

  View Answers (1)
• Q2. Insertion in AVL Tree Ninja has to implement an ‘AVL_TREE’ from scratch. He is given ‘N’ values, representing the values of nodes to be inserted. Ninja has to i...read more
  View Answers (2)

Round duration - 30 minutes
Round difficulty - Easy

The Technical Interview started off very fine and lasted for about 30-40 minutes. There were few HR questions in the beginning. The interviewer is very friendly. Firstly they asked me to tell them about myself. then the reasons for choosing this Profile. Then he asked me to explain the projects I have done. I have explained them. They have interrupted me and asked some doubts meanwhile. But I felt that they were intended just to check my confidence and how would I explain their doubts. They asked me some DSA Questions but I told them I am not much confident in DSA then they asked Basic Questions on DBMS like Explain about Normalization of DB, self Join, etc. And at the end, he asked me a general aptitude question based on Distance and time.

Overall the Interview was quite easy. Just learn the basics. Maintain good communication skills. Be confident and add good projects to your CV. Then it will be very easy to crack this round.

• Q1. SQL Question

  Asked me to write a query to select some data from large collection of it.

  View Answers (1)
• Q2. Third greatest element Given an array/list 'ARR' of ‘N’ distinct integers, you are supposed to find the third largest element in the given array 'AR...read more
  View Answers (4)

Round duration - 30 minutes
Round difficulty - Easy

In the first 10 min, He asked me general HR questions like why OFSS. What are your strengths etc?
Then he asked me a puzzle. Then he asked me some questions from my resume regarding my internship and extracuriculars.
Then he asked me questions related to banking like how banks earn money, is a loan asset or liability, is FD asset or liability for a bank, and as I knew all these financial concepts already so it was quite easy for me to crack this round. The interviewer was very friendly and then I asked him some questions regarding the job profile and he answered every question happily and it was visible on his face that he is happy with my interview.

• Q1. Puzzle Suppose there are N balls. out of which only 1 ball is lighter in weight. You are given a simple balance. Then How many minimum no. of attempts do one ta...read more
  View Answers (1)

• Q1. What are the instances that are created when we deploy our CAPM app to CF?
  View Answers (1)

It was straightforward and basic technical scenarios

• Q1. Combined DSA, and scenarios driven questions
  Add Answer

• Q1. Managerial round
  Add Answer

English mental ability and cs fundamentals

• Q1. Reverse strings, oops,dbms
  Add Answer