Upload Button Icon Add office photos

Filter interviews by

Astroved.com SQL Developer Interview Questions and Answers

Updated 9 Sep 2024

Astroved.com SQL Developer Interview Experiences

1 interview found

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

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Joins, constraints
  • Q2. Subquery,CTE, Optimization

Interview questions from similar companies

I appeared for an interview in Dec 2016.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself tell me about your internship My interview was unstructured(i.e based on your reply interviewer was asking Questions)

Interview Preparation Tips

Round: Test
Experience: Questions were very difficult and solving one Question gets you shortlisted for interview
I don't remember the Questions
Duration: 1 hour 30 minutes
Total Questions: 2

Skills: Internship Work, Inter Person Communication Skills
College Name: IIT Roorkee
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jan 2024. There were 4 interview rounds.

Round 1 - Coding Test 

Machine Coding of Google Calendar

Round 2 - Coding Test 

Machine Coding of MP3 Player

Round 3 - One-on-one 

(1 Question)

  • Q1. Find Duplicates problem
  • Ans. 

    Find duplicates in an array of strings

    • Iterate through the array and store each element in a hash set

    • If an element is already in the hash set, it is a duplicate

    • Return a list of all duplicates found

  • Answered by AI
Round 4 - HR 

(1 Question)

  • Q1. Why Simpl? and compensation
  • Ans. 

    Simpl offers a collaborative and innovative work environment with competitive compensation.

    • Simpl values teamwork and creativity in software development

    • Competitive compensation package offered to attract top talent

    • Opportunities for growth and learning through challenging projects

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Mar 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

A Google Form-based Aptitude Test with Basic Questions

Round 3 - Technical 

(1 Question)

  • Q1. Asked Basic Time Complexity and DSA Questions like Time Complexity Of quick sort use of stack Data Structure etc
Round 4 - Coding Test 

It was the final round asked to do a medium-level coding Question to convert a number such as 244 to word i.e Two Hundred and Forty four

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

It was good , 2 questions are there to code.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Cs fundamental, Projects, coding.
  • Q2. A simple coding question of string using map
Round 3 - Technical 

(2 Questions)

  • Q1. What is React router. what does it do.
  • Ans. 

    React Router is a popular routing library for React applications.

    • React Router is used for handling navigation in React applications.

    • It allows defining multiple routes in the application and rendering different components based on the URL.

    • React Router provides components like BrowserRouter, Route, Switch, and Link for routing.

    • Example: will render the About component when the URL

  • Answered by AI
  • Q2. Questions based on react basics.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be patience you will do it easily.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Assignment 

A simple Google form assignment to shortlist candidates

Round 2 - Technical 

(2 Questions)

  • Q1. ML related questions
  • Q2. Find duplicates in array
  • Ans. 

    Use a hash set to find duplicates in an array of strings.

    • Create a hash set to store unique elements.

    • Iterate through the array and check if each element is already in the hash set.

    • If it is, then it is a duplicate.

    • Example: ['apple', 'banana', 'apple', 'orange'] should return 'apple' as a duplicate.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Eazy process

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed before Jul 2022. There were 5 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 - Aptitude Test 

50 questions in 12 minutes mostly test your arthimetic, logical knowledge.

Round 3 - Coding Test 

3 coding questions in 90 mins, 1st one is from arrays an easy question, 2nd one is related to stacks and queues relatively harder and last one is hard which i am also unable to attempt. I cracked the first two questions and my solutions passed all the test cases.

Round 4 - One-on-one 

(3 Questions)

  • Q1. Difference between sorting algorithms
  • Ans. 

    Sorting algorithms are methods used to arrange elements in a specific order.

    • Different sorting algorithms include bubble sort, selection sort, insertion sort, merge sort, quick sort, and heap sort.

    • Some algorithms are more efficient than others depending on the size of the data set and the initial order of the elements.

    • For example, quick sort is generally faster than bubble sort for large data sets.

  • Answered by AI
  • Q2. BFS and DFS in trees and imlementing them
  • Ans. 

    BFS and DFS are traversal algorithms used in trees. BFS explores level by level, while DFS explores depth first.

    • BFS (Breadth-First Search) visits nodes level by level, using a queue. Example: traversing a binary tree level by level.

    • DFS (Depth-First Search) explores as far as possible along each branch before backtracking. Example: in-order traversal of a binary tree.

  • Answered by AI
  • Q3. Sql questions and database questions
Round 5 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Explain the college life

Interview Preparation Tips

Interview preparation tips for other job seekers - learn the web development basics to get placed in any indian startup

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed before Sep 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Coding Test 

Question from Array,DP

Round 3 - One-on-one 

(3 Questions)

  • Q1. Resume based only
  • Q2. Data structure and algorithms
  • Q3. Object oriented programmings
Round 4 - HR 

(1 Question)

  • Q1. Behavioural questions
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Basic resume based questions
  • Q2. Explain your internship experience
Round 3 - HR 

(1 Question)

  • Q1. Basic resume based questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Referral and was interviewed in Oct 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
Round 2 - Aptitude Test 

NEED TO QUALIFY IN THIS TEST

Round 3 - Coding Test 

NEED TO QUALIFY THIS TEST ALSO

Round 4 - Technical 

(1 Question)

  • Q1. SOME DSA AND ROLE BASED QUATIONS.

Astroved.com Interview FAQs

How many rounds are there in Astroved.com SQL Developer interview?
Astroved.com interview process usually has 1 rounds. The most common rounds in the Astroved.com interview process are Technical.
How to prepare for Astroved.com SQL Developer 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 Astroved.com. The most common topics and skills that interviewers at Astroved.com expect are DDL, Dml, ETL, MS SQL Server and SQL.
What are the top questions asked in Astroved.com SQL Developer interview?

Some of the top questions asked at the Astroved.com SQL Developer interview -

  1. Subquery,CTE, Optimizat...read more
  2. Joins, constrai...read more

Tell us how to improve this page.

Astroved.com SQL Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

AmbitionBox Interview Questions
4.9
 • 153 Interviews
Cogoport Interview Questions
2.9
 • 53 Interviews
Treebo Hotels Interview Questions
3.2
 • 22 Interviews
Simpl Interview Questions
2.8
 • 17 Interviews
KrazyBee Interview Questions
3.7
 • 15 Interviews
MRI Software Interview Questions
3.7
 • 14 Interviews
EazyDiner Interview Questions
3.2
 • 14 Interviews
TripFactory Interview Questions
2.0
 • 13 Interviews
View all
Software Engineer
8 salaries
unlock blur

₹3.6 L/yr - ₹5.4 L/yr

Junior Software Engineer
8 salaries
unlock blur

₹2 L/yr - ₹4 L/yr

Junior Software Developer
7 salaries
unlock blur

₹2.2 L/yr - ₹2.8 L/yr

Web Designer
7 salaries
unlock blur

₹1.8 L/yr - ₹4.4 L/yr

Senior Customer Support Executive
6 salaries
unlock blur

₹3.6 L/yr - ₹4.6 L/yr

Explore more salaries
Compare Astroved.com with

Cogoport

2.9
Compare

KrazyBee

3.7
Compare

Treebo Hotels

3.2
Compare

Naaptol Online Shopping

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