Upload Button Icon Add office photos

Filter interviews by

Anand Rathi Information Technology Interview Questions and Answers

Updated 18 Apr 2024

Anand Rathi Information Technology Interview Experiences

Popular Designations

4 interviews found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 18 Apr 2024

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

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Different types of SQL Joins
  • Ans. 

    Different types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • INNER JOIN: Returns rows when there is at least one match in both tables.

    • LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.

    • RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table.

    • FULL JOIN: Returns rows when there is a match in one of the tables.

  • Answered by AI
  • Q2. Difference between Stored Procedures and Functions
  • Ans. 

    Stored Procedures are used to perform a set of actions, while Functions return a value.

    • Stored Procedures can perform multiple actions and may or may not return a value

    • Functions always return a value and are used for calculations or data retrieval

    • Stored Procedures can have input/output parameters, while Functions only have input parameters

    • Stored Procedures are called using EXECUTE command, while Functions are called in

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. Additional skills apart from database. Regarding C# and Web APIs
Round 3 - HR 

(1 Question)

  • Q1. Salary expectation

Interview Preparation Tips

Topics to prepare for Anand Rathi Information Technology SQL Developer interview:
  • HTML
  • CSS
  • C#.Net
  • API
  • SQL
Interview preparation tips for other job seekers - You should have skills in SQL, HTML, CSS, C# APIs. Study from W3 Schools before taking interview. Be confident. If you don't know answer to a question say positively, that currently I don't know but i'll search and let you know. Then you're good to go.

Skills evaluated in this interview

SQL Developer Interview Questions asked at other Companies

Q1. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)
View answer (4)

I applied via Naukri.com and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is MVC ? What is routing ? When we use finally block
  • Ans. 

    MVC is a software architecture pattern. Routing is the process of directing HTTP requests to the appropriate controller. Finally block is used to execute code after a try-catch block.

    • MVC stands for Model-View-Controller

    • Routing is used to map URLs to specific actions in a controller

    • Finally block is used to ensure that a section of code is always executed, even if an exception is thrown

  • Answered by AI
  • Q2. Using keywords, difference between view data and view bag, can we possess temp data, which exception used without try and catch block and exception handling

Interview Preparation Tips

Interview preparation tips for other job seekers - Please learn about c# and MVC and SQL server

Skills evaluated in this interview

Developer Interview Questions asked at other Companies

Q1. Which programming language do you use regular in work
View answer (2)

I applied via Referral and was interviewed before Jun 2021. 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 - Technical 

(1 Question)

  • Q1. Basics of oops and databse related questions and programming concepts.

Interview Preparation Tips

Interview preparation tips for other job seekers - Great place to learn and work on lattest technologies. Work culture is upto the mark and process of development is as like as multinational comapanies. I got the oppotunity to work here and I learned a lot here.

Developer Associate Interview Questions asked at other Companies

Q1. Cycle Detection in a Singly Linked List Determine if a given singly linked list of integers forms a cycle or not. A cycle in a linked list occurs when a node's next points back to a previous node in the list. Thus, the list does not have a ... read more
View answer (1)

I applied via Company Website and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic Oop Fundamental.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was quite simple,In technical round they asked Basic Oop questions,project stuff etc.

Graduate Engineer Trainee (Get) Interview Questions asked at other Companies

Q1. Q: 1 What is IC engine? What is the types of IC engine? Q:2 Difference between Otto cycle and Diesel cycle? What is the process of both cycle and what is the effeciency of both cycle ? Which one is good in effeciency? Q:3 Difference between... read more
View answer (2)

Anand Rathi Information Technology interview questions for popular designations

 Graduate Engineer Trainee (Get)

 (1)

 SQL Developer

 (1)

 Developer Associate

 (1)

 Developer

 (1)

Jobs at Anand Rathi Information Technology

View all

Interview questions from similar companies

I applied via Walk-in and was interviewed before Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Basic Programming questions.
  • Q2. Fibonacci program
  • Q3. OOPS concepts.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic OOPS concepts and basic programs.

I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops Concepts and Data Structure Questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Oops And Data Structure, Collection.

I applied via Recruitment Consultant and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic communication skills were tested. Sone techical questn too. Versant test is mandatory

Interview Preparation Tips

Interview preparation tips for other job seekers - Please never go for these third party vendors. They misguide you regarding profile . I went for this third party vendor named savantis solution and it really misguided me

I applied via Campus Placement and was interviewed before Feb 2020. There were 6 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Was interviewed as fresher?
  • Q2. Written test conducted? with verbal ability test ? GD
  • Q3. How would u deal with a problematic situation when you are working in a team?
  • Q4. What are your plans about higher studies?

Interview Preparation Tips

Interview preparation tips for other job seekers - it was basic with apptiude test and attitiude test.

Interview Questionnaire 

2 Questions

  • Q1. They asked me on java and I have joined as a fresher they not much questions as I got selected as fresher on oops concepts and collections
  • Q2. Please be confident while facing interview and they will check your communication skills

Interview Questionnaire 

1 Question

  • Q1. Who is the most important person have to transform you in your life?

Interview Preparation Tips

Interview preparation tips for other job seekers - Just speak your mind you will be selected.

Anand Rathi Information Technology Interview FAQs

How many rounds are there in Anand Rathi Information Technology interview?
Anand Rathi Information Technology interview process usually has 2 rounds. The most common rounds in the Anand Rathi Information Technology interview process are Technical, One-on-one Round and HR.
How to prepare for Anand Rathi Information Technology interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Anand Rathi Information Technology. The most common topics and skills that interviewers at Anand Rathi Information Technology expect are Relationship Management, OOPS, Postgresql, SQL and .Net.
What are the top questions asked in Anand Rathi Information Technology interview?

Some of the top questions asked at the Anand Rathi Information Technology interview -

  1. What is MVC ? What is routing ? When we use finally bl...read more
  2. Difference between Stored Procedures and Functi...read more
  3. Different types of SQL Jo...read more

Tell us how to improve this page.

Anand Rathi Information Technology Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Infosys Interview Questions
3.6
 • 7.7k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
Mphasis Interview Questions
3.4
 • 811 Interviews
KPIT Technologies Interview Questions
3.4
 • 294 Interviews
View all

Anand Rathi Information Technology Reviews and Ratings

based on 69 reviews

3.5/5

Rating in categories

3.2

Skill development

3.6

Work-life balance

2.9

Salary

4.1

Job security

3.5

Company culture

2.8

Promotions

3.1

Work satisfaction

Explore 69 Reviews and Ratings
Product Manager- Investment AUM

Mumbai

4-7 Yrs

Not Disclosed

PCG desk advisor

New Delhi

2-5 Yrs

Not Disclosed

PCG - Advisor

Mumbai

2-6 Yrs

Not Disclosed

Explore more jobs
Software Developer
24 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Developer Associate
21 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Developer
14 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Officer
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Java Developer
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Anand Rathi Information Technology with

Infosys

3.6
Compare

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

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