Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Foray Software SQL Developer Interview Questions and Answers

Updated 12 Jul 2023

Foray Software SQL Developer Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 30 Jun 2023

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jul 2022. There were 3 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 Resume tips
Round 2 - Technical 

(3 Questions)

  • Q1. Difference between function store productor
  • Ans. 

    A function is a reusable block of code that performs a specific task, while a stored procedure is a group of SQL statements that can be executed together.

    • Functions return a value, while stored procedures do not necessarily return a value.

    • Functions can be used in SQL statements like SELECT, WHERE, etc., while stored procedures cannot be used in such statements.

    • Stored procedures can have input and output parameters, whil...

  • Answered by AI
  • Q2. Highest second salary
  • Q3. What join and type explain each
  • Ans. 

    Different types of joins in SQL and their explanations

    • 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 Outer Join - returns rows when there is a match in one of the tables

    • Cross Join - returns the Cartesian produc

  • Answered by AI
Round 3 - HR 

(3 Questions)

  • Q1. Why you left last job
  • Q2. Introduction your self
  • Q3. Decision about the salary

Interview Preparation Tips

Interview preparation tips for other job seekers - no any point

Skills evaluated in this interview

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. 1 . Oops concept in detail 2 DBMS 3. Data base query
Round 2 - HR 

(1 Question)

  • Q1. Document verification

Interview Preparation Tips

Interview preparation tips for other job seekers - For freshers should be clear on basic concepts.
For experienced should be detailed knowledge on their domain.

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

Round 1 - Technical 

(1 Question)

  • Q1. Basic java concepts like collection frame work, exception handling

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn basics well, be confident, show you are flexible enough to learn

I was interviewed in Jun 2017.

Interview Preparation Tips

Round: Technical Interview
Experience: They asked java basics,
what we wrote in resume will ask
about project
Tips: please prepare basics things

I applied via Campus Placement and was interviewed before Oct 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. What is encapsulation ?
  • Ans. 

    Encapsulation is the process of hiding implementation details and providing access to only necessary information.

    • Encapsulation helps in achieving data abstraction and information hiding.

    • It allows for better control over data and prevents unauthorized access.

    • In Java, encapsulation is achieved through the use of access modifiers such as private, public, and protected.

    • For example, a class may have private variables that c...

  • Answered by AI
  • Q2. What is the meaning of string.
  • Ans. 

    A string is a sequence of characters used to represent text in programming.

    • Strings are often used for storing and manipulating text data.

    • In Java, strings are represented by the String class.

    • Strings can be concatenated using the + operator.

    • Strings are immutable, meaning they cannot be changed once created.

    • Examples of string literals include "hello world" and "42".

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - do not tell about salary expectations

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Aug 2018. There were 5 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. 1.Core java 2.Spring 3. Hibernate 4. Spring Boot 5. SQL 6. AngularJS
  • Ans. 

    The question is asking about the candidate's knowledge in Core Java, Spring, Hibernate, Spring Boot, SQL, and AngularJS.

    • Core Java is the foundation of Java programming language.

    • Spring is a popular framework for building Java applications.

    • Hibernate is an ORM tool used for mapping Java objects to database tables.

    • Spring Boot is a framework for building microservices.

    • SQL is a language used for managing relational databases...

  • Answered by AI
  • Q2. 1. How to connect 2 DBs from spring boot application
  • Ans. 

    To connect 2 DBs from a Spring Boot application, configure multiple data sources and use JdbcTemplate or EntityManager for each DB.

    • Configure multiple data sources in the application.properties file

    • Create separate configuration classes for each data source

    • Use JdbcTemplate or EntityManager to interact with each DB

    • Specify the appropriate data source in the repository or service classes

  • Answered by AI
  • Q3. 2. Difference between abstract method implementation and default method
  • Ans. 

    Abstract method implementation is mandatory while default method is optional.

    • Abstract method has no implementation in the abstract class and must be implemented by the subclass.

    • Default method has a default implementation in the interface and can be overridden by the implementing class.

    • Abstract method is used to enforce a contract while default method is used to provide a default behavior.

    • Example: abstract method - publ...

  • Answered by AI
  • Q4. 1. About salary and expectation

Interview Preparation Tips

Round: Test
Experience: Technical written test

General Tips: Terrible interview. HR told to give 11% hike with 6% variable and 5% fixed. I kicked off the company.
Skills: Web Technologies, Java Application Development
Duration: 1-4 weeks

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Abstraction

I applied via Company Website

Interview Questionnaire 

1 Question

  • Q1. Java

Interview Preparation Tips

Interview preparation tips for other job seekers - Yes

I applied via Campus Placement and was interviewed before Jun 2020. There were 7 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. What java
  • Ans. 

    Java is a high-level, object-oriented programming language used to develop applications for various platforms.

    • Java is platform-independent and can run on any platform with a JVM.

    • It is used for developing web, mobile, desktop, and enterprise applications.

    • Java has a vast library of pre-built classes and APIs.

    • It supports multithreading, exception handling, and garbage collection.

    • Java is widely used in the industry for its...

  • Answered by AI
  • Q2. Why java
  • Ans. 

    Java is a popular, versatile, and reliable programming language used for developing a wide range of applications.

    • Java is platform-independent, making it easy to write code once and run it on multiple platforms.

    • It has a vast library of pre-built classes and APIs, making development faster and easier.

    • Java is highly secure and provides built-in features for encryption and authentication.

    • It is widely used in enterprise app...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Yes

Skills evaluated in this interview

I was interviewed in Feb 2017.

Interview Questionnaire 

3 Questions

  • Q1. Basic Java questions, OOPs questions, Questions on abstract, Inteface classes, Spring questions, Hibernate questions, Tomcat server questions.
  • Q2. Related to Project in you worked, work experience, how many technology you know about
  • Q3. Hobbies, aspirations, your family background, what you like dislike, Salary negotiation.

Interview Preparation Tips

Round: Technical Interview
Experience: Interview was for 30 minutes duration. They have started with basic concepts like Abstract, Interface etc. Then they moved to core java. Some basic question on core java related to Exceptions, try-catch-finally blocks. Spring MVC basic questions, bean mapping questions. use of tomcat server in eclipse.
Tips: I was lucky at that day.
Interview was more likely of fresher level. I was first in the interview process, interviewer were not ready, so they directly asked few questions to me.
Level of interview was not up to the mark, I prepared for tougher interview, gone thru 500+ questions on core java, spring, hibernate, exceptions and try catch.
0-3 years in java is equivalent to fresher. But you have to be prepared for worst if you really wanted the job.
Before going to the interview, Do hands-on.

Round: Technical + HR Interview
Experience: They call it MR interview.
This interview was on call, after TR, same day. One HR dialed a no. for me.
The person asked about my previous experience in projects, How many technologies I have worked on. Why i am leaving my current employers as I have only 2 years of experience.
How much I am open up to new technologies.
Where i see myself after 5 years.
What are my career aspirations.
How much flexible I am with shifts and work loads.
Tips: Its simple round, You have to be sure why you want this job. give them a very valid reason of your own. Don't copy anybody else's answer. Be confident. If it is on call, speak clearly, maintain pace and voice. They may throw situations and puzzles. be calm, use your mind. Its fine if you don't know about anything. But don't tell directly that you don't know. Try to use all the positive words and phrases.

Round: HR Interview
Experience: They asked some question about myself. about family background. about hobbies and from your resume also, like how many projects you have done.How you are feeling in IT industry. Why this company.
At last salary negotiations. They have started with lowest, 10% hike. and i was expecting 40-50% hike.
I am getting 4 LPA right now, the offered me 5.2LPA at last. I had no options, so i agreed.
But i was very disappointed and tried my best to get more, but they convinced me that it is the best for my role.
Tips: Be confident and look happy, show the joy when you tell about your hobbies. It will lighten up the environment.
Don't insult your previous employer. Defend your current employer if the say something wrong, It a tricky ques

Contribute & help others!
anonymous
You can choose to be anonymous

Foray Software Interview FAQs

How many rounds are there in Foray Software SQL Developer interview?
Foray Software interview process usually has 3 rounds. The most common rounds in the Foray Software interview process are Resume Shortlist, Technical and HR.
What are the top questions asked in Foray Software SQL Developer interview?

Some of the top questions asked at the Foray Software SQL Developer interview -

  1. what join and type explain e...read more
  2. difference between function store produc...read more

Recently Viewed

REVIEWS

Foray Software

No Reviews

INTERVIEWS

Foray Software

20 top interview questions

INTERVIEWS

VHS Consulting

5.6k top interview questions

INTERVIEWS

Peel-works

No Interviews

JOBS

Real Time Data Services

No Jobs

SALARIES

Peel-works

INTERVIEWS

Fingent

No Interviews

REVIEWS

Foray Software

No Reviews

REVIEWS

VHS Consulting

No Reviews

REVIEWS

VHS Consulting

No Reviews

Tell us how to improve this page.

Foray Software SQL Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

SQL Developer Interview Questions from Similar Companies

View all
Foray Software SQL Developer Salary
based on 13 salaries
₹2.6 L/yr - ₹8.5 L/yr
21% more than the average SQL Developer Salary in India
View more details

Foray Software SQL Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
316 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Information Technology Recruiter
299 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
225 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
210 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Softwaretest Engineer
131 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Foray Software 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