Upload Button Icon Add office photos

Filter interviews by

Advocate Junior Advocate Interview Questions and Answers

Updated 21 Sep 2020

Advocate Junior Advocate Interview Experiences

1 interview found

I applied via Indeed and was interviewed before Sep 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About experience

Interview Preparation Tips

Interview preparation tips for other job seekers - .....

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Apr 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. What is zero coupon bond?
  • Ans. 

    A zero coupon bond is a bond that pays no interest and is sold at a discount to its face value.

    • Zero coupon bonds are also known as discount bonds.

    • Investors buy these bonds at a price lower than their face value and receive the full face value at maturity.

    • The difference between the purchase price and the face value is the investor's return.

    • Zero coupon bonds are often used for long-term investments, such as retirement sa...

  • Answered by AI
  • Q2. What is corporate actions and how you record those in books?
  • Ans. 

    Corporate actions are events initiated by a company that can affect its stock price and shareholders. They are recorded in books through various accounting entries.

    • Corporate actions include stock splits, dividends, mergers, acquisitions, and spin-offs.

    • These actions are recorded in books through journal entries and adjustments to accounts such as retained earnings and stockholders' equity.

    • For example, if a company decla...

  • Answered by AI

I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Given an input string "neeraj chopra" Write Python code to get output string as "jareen arpohc".
  • Ans. 

    The Python code to get the output string as 'jareen arpohc' from the input string 'neeraj chopra' is provided.

    • Split the input string into individual words

    • Reverse each word

    • Join the reversed words with a space in between

  • Answered by AI
  • Q2. Given a list of 10 numbers. Write a code to list only even numbers out of the original list.
  • Ans. 

    Code to list even numbers from a given list of 10 numbers.

    • Loop through the list of numbers

    • Check if each number is even using the modulo operator

    • If the number is even, add it to a new list of even numbers

    • Return the new list of even numbers

  • Answered by AI
  • Q3. SQL queries using Window Functions Rank() , Dense Rank() etc
  • Q4. Reversal of string in python code
  • Ans. 

    Reversing a string in Python code

    • Use slicing to reverse the string

    • Use the built-in function 'reversed()'

    • Convert the string to a list, reverse it, and then join it back to a string

  • Answered by AI
  • Q5. SQL queries in general.

Interview Preparation Tips

Interview preparation tips for other job seekers - There is hiring surge in the company so one should go for it .
Basic Python , SQL knowledge is enough to crack the interviews.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
-

I applied via Approached by Company

Round 1 - Technical 

(2 Questions)

  • Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
  • Q2. Joining tables with different joins
  • Ans. 

    Joining tables with different joins in SQL

    • Use INNER JOIN to return rows when there is at least one match in both tables

    • Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

    • Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

    • Use FULL JOIN to return rows when there is a match in one of the tables

  • Answered by AI

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Basics of python, project related questions
  • Q2. Basic SQL, few simple problem solving questions
Round 2 - HR 

(2 Questions)

  • Q1. Interests, hobbies ,general HR questions
  • Q2. Expected hike, salary, work timings preferred

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for basic python and sql.

I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. SQL window functions
  • Q2. Basic SQL queries
  • Q3. Basic Power BI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be kind and humble and don't cheat. The interview will be a cup of cake if you even have some decent experience. Just get your basic right. There won't be much scenarios and coding questions

Interview Questionnaire 

2 Questions

  • Q1. Mostly puzzles and one case study
  • Q2. They asked me questions about my interests and hobbies

Interview Preparation Tips

Round: Test
Experience: There were three sets of question paper. We were sitting according to our roll number then question paper with rough sheet were distributed and we were allowed 1 hour to finish that. There was no negative marking.
Tips: For aptitude practice data interpretation and data sufficiency
Duration: 1 hour
Total Questions: 30

Round: Group Discussion
Duration: 15 minutes

Round: Technical Interview
Tips: Practice puzzles and case study for this round

Round: HR Interview
Tips: Be yourself

College Name: NIT Rourkela

Interview Preparation Tips

Round: Technical Interview
Experience: this was a telephonic round : There I was asked basics of web development (e.g Session, hidden variable difference between POST and GET etc. ) and basics of PHP e.g global variables etc , little bit of mysql e.g joins , difference between left and right joins.

Round: Technical Interview
Experience: This was pretty much about interview rounds. I got the offer.

Skills: Core java, OOP, PHP
College Name: na

Interview Questionnaire 

18 Questions

  • Q1. Tell me about your yourself
  • Ans. 

    I am a detail-oriented business analyst with experience in data analysis and process improvement.

    • I have a Bachelor's degree in Business Administration

    • I have worked with various stakeholders to identify business needs and requirements

    • I am proficient in SQL and Excel for data analysis

    • I have experience in process improvement and project management

    • I am a strong communicator and collaborator

  • Answered by AI
  • Q2. Tell us about your training and internships
  • Ans. 

    I have completed a business analyst certification course and have interned at a software development company.

    • Completed a business analyst certification course from XYZ Institute

    • Interned at ABC Software Development Company for 6 months

    • Worked on requirement gathering, documentation and analysis for a project

    • Assisted senior business analysts in creating project plans and reports

  • Answered by AI
  • Q3. What is the role of Instrumentation Department? (my training)
  • Ans. 

    The Instrumentation Department is responsible for designing, installing, and maintaining control systems and instruments used in industrial processes.

    • Designing and implementing control systems for industrial processes

    • Installing and maintaining instruments used in industrial processes

    • Ensuring accuracy and reliability of instruments and control systems

    • Collaborating with other departments to optimize processes and improve...

  • Answered by AI
  • Q4. Why do you want to join Affine Analytics?
  • Ans. 

    I am excited to join Affine Analytics because of their reputation for delivering innovative solutions and their focus on employee growth.

    • Affine Analytics has a strong track record of delivering cutting-edge solutions to clients across industries.

    • I am impressed by the company's commitment to employee growth and development, as evidenced by their training and mentorship programs.

    • I am excited about the opportunity to work...

  • Answered by AI
  • Q5. Why Data anayltics? Why not a technical job in your field?
  • Ans. 

    Data analytics allows me to use my technical skills to solve business problems and make data-driven decisions.

    • Data analytics helps me to identify patterns and trends in data that can be used to improve business processes.

    • It allows me to work with large datasets and use statistical methods to extract insights.

    • I can use my technical skills to develop and implement data models and algorithms.

    • Data analytics is a growing fi...

  • Answered by AI
  • Q6. If I keep two diodes in series will it work as a transistor? (EC branch)
  • Ans. 

    No, two diodes in series cannot work as a transistor.

    • Transistors have three terminals while diodes have two.

    • Transistors can amplify signals while diodes cannot.

    • Transistors can be used as switches while diodes cannot.

    • Diodes in series will only increase the voltage drop.

    • Transistors have different modes of operation such as common emitter, common base, and common collector.

  • Answered by AI
  • Q7. What exactly have you accomplished with the drone? (my final year project)
  • Ans. 

    I developed a drone that can detect and monitor forest fires.

    • Designed and built a drone with thermal imaging camera

    • Integrated machine learning algorithm to detect fire

    • Tested and validated the drone in a controlled forest environment

    • Presented the project at a national engineering conference

  • Answered by AI
  • Q8. How frequently do you play Badminton? (Hobby)
  • Ans. 

    I play badminton twice a week as a hobby.

    • I enjoy playing badminton as a way to stay active and relieve stress.

    • I usually play with friends or family members at a local community center.

    • I have been playing badminton for several years and have improved my skills over time.

  • Answered by AI
  • Q9. Do you have any problem working in Bangalore?
  • Ans. 

    No, I don't have any problem working in Bangalore.

    • I am familiar with the city and its culture

    • I have worked in Bangalore before and enjoyed my experience

    • I am open to new experiences and challenges

    • I am willing to adapt to the local environment and work culture

  • Answered by AI
  • Q10. Do you have any questions for us?
  • Q11. Which football club do you follow? (My answer: Real Madrid) (Que based on hobby)
  • Q12. Why is Real Madrid your favorite?
  • Ans. 

    Real Madrid is my favorite because of their rich history, success, and style of play.

    • Real Madrid has won a record 13 Champions League titles, which is a testament to their success

    • Their style of play is attractive and entertaining to watch

    • The club has a rich history and has had some of the greatest players in football history, such as Cristiano Ronaldo and Zinedine Zidane

  • Answered by AI
  • Q13. Assume you are the CEO of Flipkart. Your board has decided to go App only. What factors would you consider before making your final decision. (You have the relevant data from your website of last 7 years ...
  • Ans. 

    Factors to consider before going App only as CEO of Flipkart

    • Analyze the data from website and app to understand user behavior

    • Evaluate the impact on sales and revenue

    • Consider the potential loss of customers who prefer website over app

    • Assess the cost of developing and maintaining the app

    • Evaluate the competition and their strategies

    • Consider the impact on brand image and customer loyalty

    • Assess the feasibility of providing ...

  • Answered by AI
  • Q14. The Horse Puzzle
  • Q15. 3 Ants triangle puzzle
  • Q16. 3 Jars puzzle (Apple/Orange puzzle)
  • Q17. I have two jars of 5 litres and 3 litres. How can I measure 4 litres? (Assume: Infinite supply of water and no third jar is present)
  • Q18. A revolver with 2 bullets puzzle

Interview Preparation Tips

Round: Test
Experience: The first 10 questions were Data Interpretation type. There were around 4 to 5 logic questions. The rest were quantitative questions.
The questions were pretty basic.
Tips: The aim is to check the speed of your calculations.
Duration: 30 minutes
Total Questions: 23

Round: Group Discussion
Tips: Speak relevant points and you will be fine.
High proficiency in English is a must.
Duration: 10 minutes

Round: Puzzle Interview
Experience: The interview was great and lasted around 35-40 minutes. The interviewer gave ample amount of time to solve the questions.
To answer the questions was ofcourse important but approach to your final answer is very important as well. If you already know the answer but fail to explain the approach to the interviewer, you will get rejected.
Tips: Keep the interviewer in the loop and keep explaining him what you are thinking.
Fluent English is very important as well.

Round: HR Interview
Experience: The interviewers were very friendly and the interview lasted around 15 min.
Tips: Have one or two favorite subject/s from which you can answer any question thrown at you.
Be well versed about your final year project.
Do not put rubbish in your resume as they read the entire resume.

Skills: Enthusiasm, Projects, Proficiency In English, Logical Puzzles, Logical Thinking
College Name: NIT Surat
Funny Moments: As the HR interviewer is an alumni of my college, we had some chat about the college. This made the interview mood very light.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Coding Test 

The first round was a combination of MCQs and SQL Coding test. It consisted of 23 MCQs on SQL, 10 MCQs on Power BI and 5 SQL Coding questions.

Round 2 - Technical 

(1 Question)

  • Q1. Simple questions on SQL were asked.
Round 3 - One-on-one 

(5 Questions)

  • Q1. What is pivot table in Excel?
  • Ans. 

    A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.

    • Pivot tables allow you to analyze and summarize large amounts of data in a spreadsheet.

    • You can easily rearrange the layout of the data to view it from different perspectives.

    • Pivot tables can perform functions like sum, average, count, and more on the data.

    • They are useful for creating reports...

  • Answered by AI
  • Q2. What is 'Data Validation' in Excel?
  • Ans. 

    Data Validation in Excel ensures that data entered in a cell meets certain criteria or conditions.

    • Data Validation allows you to set rules for what can be entered in a cell, such as a range of values, a list of items, or a custom formula.

    • Examples of Data Validation include setting a drop-down list of options for a cell, restricting input to a certain number range, or ensuring dates are entered in a specific format.

    • Data ...

  • Answered by AI
  • Q3. What is the order of execution of an SQL query?
  • Ans. 

    The order of execution of an SQL query involves multiple steps to retrieve data from a database.

    • 1. Parsing: The SQL query is first parsed to check for syntax errors.

    • 2. Optimization: The query optimizer creates an execution plan to determine the most efficient way to retrieve data.

    • 3. Compilation: The optimized query is compiled into an executable form.

    • 4. Execution: The compiled query is executed by the database engine t...

  • Answered by AI
  • Q4. What is the difference between Tree Map and Heatmap in Tableau?
  • Ans. 

    Tree Map visualizes hierarchical data using nested rectangles, while Heatmap displays data values using color gradients.

    • Tree Map displays data hierarchically with nested rectangles, where the size and color represent different measures.

    • Heatmap visualizes data values using color gradients, with darker colors indicating higher values.

    • Tree Map is useful for showing hierarchical data structures, while Heatmap is effective ...

  • Answered by AI
  • Q5. What is the difference between 'Extract Data' and 'Live Connection' in Tableau?
  • Ans. 

    Extract Data saves a snapshot of data in Tableau workbook, while Live Connection directly connects to data source.

    • Extract Data creates a static copy of data in Tableau workbook, while Live Connection directly queries data source in real-time.

    • Extract Data is useful for working offline or with small datasets, while Live Connection is ideal for large datasets or when data is frequently updated.

    • Extract Data can improve per...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Affine Data Analyst interview:
  • SQL
  • Power Bi
  • Tableau
  • Excel

Skills evaluated in this interview

Tell us how to improve this page.

Interview Questions from Similar Companies

Affine Interview Questions
3.3
 • 49 Interviews
IT By Design Interview Questions
3.6
 • 40 Interviews
Argusoft Interview Questions
4.6
 • 38 Interviews
DotPe Interview Questions
3.2
 • 37 Interviews
View all
Advocate Junior Advocate Salary
based on 22 salaries
₹1 L/yr - ₹6 L/yr
At par with the average Junior Advocate Salary in India
View more details

Advocate Junior Advocate Reviews and Ratings

based on 3 reviews

4.7/5

Rating in categories

4.7

Skill development

4.7

Work-life balance

1.2

Salary

3.3

Job security

4.7

Company culture

5.0

Promotions

4.6

Work satisfaction

Explore 3 Reviews and Ratings
Advocate
209 salaries
unlock blur

₹1 L/yr - ₹9 L/yr

Advocate Lawyer
31 salaries
unlock blur

₹2 L/yr - ₹9 L/yr

Junior Advocate
22 salaries
unlock blur

₹1 L/yr - ₹6 L/yr

Lawyer
17 salaries
unlock blur

₹2.7 L/yr - ₹12 L/yr

Practicing Advocate
15 salaries
unlock blur

₹3 L/yr - ₹6 L/yr

Explore more salaries
Compare Advocate with

Maxgen Technologies

4.5
Compare

Value Point Systems

3.6
Compare

JoulestoWatts Business Solutions

2.9
Compare

F1 Info Solutions and Services

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview