Upload Button Icon Add office photos

Filter interviews by

IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst Interview Questions and Answers for Freshers

Updated 23 Feb 2024

IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst Interview Experiences for Freshers

1 interview found

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

I applied via Naukri.com and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. How do you find the scope of tuning in a sql query?
  • Ans. 

    Scope of tuning in a SQL query can be found by analyzing query performance, identifying bottlenecks, and optimizing indexes.

    • Analyze query performance using tools like SQL Profiler or Execution Plan

    • Identify bottlenecks such as slow queries, high CPU usage, or long execution times

    • Optimize indexes by adding, removing, or modifying indexes to improve query performance

  • Answered by AI
  • Q2. What is difference between insert and insert all? is it same or different?
  • Ans. 

    Insert is used to add a single row into a table, while insert all is used to add multiple rows into a table in a single statement.

    • Insert is used to add a single row into a table.

    • Insert all is used to add multiple rows into a table in a single statement.

    • Insert all is more efficient than using multiple insert statements.

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Why you want to join IVY?

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

8 Questions

  • Q1. Java
  • Q2. Python
  • Q3. Django
  • Q4. Html
  • Q5. Css
  • Q6. JavaScript
  • Q7. Sql
  • Q8. Dbms

I applied via Referral and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Tell me about your self

Interview Preparation Tips

Interview preparation tips for other job seekers - Non huge jbijoh ibihbih ih8hihihi ihihihibu

I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 6 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops concepts with examples, SQL query to find second highest salary, diff between fail fast and fail safe, how did u implement security in your app, etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic Java concepts

I appeared for an interview in Sep 2017.

Interview Questionnaire 

4 Questions

  • Q1. Technical interview take by client technical person actually they are hiring for another client so they took total 3 technical round and final will HR round
  • Q2. Asking about life cycle of Dot net mvc contols entity frame work and SQL queries
  • Q3. Problem based on oops and SQL queries outputs
  • Q4. Basic questions about my self ,salary discussion basic formalities form I have to fill up

Interview Preparation Tips

Round: Test
Experience: There were around 15 objective question that includes mvc, c#.net and SQL server. It was very simple question like different types of filters,Acton results in mvc. Basic oops concept and dot net web page regarding

Round: Resume Shortlist
Experience: After completing test round another was technical round discussed maily for mvc and SQL server questions. Around 30 mint discussion. After qualify this round another round will start from client technical staff.

General Tips: It was for 2-3 year experience person very simple to crack but focus on you which profile you are looking for study interview questions from net
Skills: Dot net mve oops concept jQuery and SQL server

I appeared for an interview in Sep 2017.

Interview Questionnaire 

3 Questions

  • Q1. What is deadlock
  • Ans. 

    Deadlock is a situation where two or more processes are unable to proceed because each is waiting for the other to release a resource.

    • Deadlock occurs when two or more processes are stuck in a circular wait, where each process is waiting for a resource held by another process.

    • Four necessary conditions for deadlock are mutual exclusion, hold and wait, no preemption, and circular wait.

    • Example: Process A holds resource X a...

  • Answered by AI
  • Q2. Which technology you know and worked
  • Ans. 

    I have experience with various technologies including Java, Python, HTML/CSS, JavaScript, and SQL.

    • Java

    • Python

    • HTML/CSS

    • JavaScript

    • SQL

  • Answered by AI
  • Q3. Why you are looking for change and what is your notice period
  • Ans. 

    I am looking for a change to explore new opportunities and challenges. My notice period is 30 days.

    • Seeking new opportunities and challenges

    • Want to learn and grow in a different environment

    • Exploring better career prospects

    • Seeking a company with a better work-life balance

    • Notice period is 30 days

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 25 objective ques from Java and 25 from English
Tips: should prepare with Java Technology
Duration: 1 hour
Total Questions: 50

Round: Technical Interview
Experience: describe clearly
Tips: should prepared

Round: Technical Interview
Experience: do you know about jsf
Tips: yes, I worked

Round: Technical + HR Interview
Experience: this is my dream company actually, and notice is 15 to 20 days.
Tips: be confident

Skills evaluated in this interview

I appeared for an interview in Sep 2019.

Interview Questionnaire 

1 Question

  • Q1. Pl sql related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - y resume was referd through a guy. Later I got call from HR for interview schedule he asked me my expected ctc and Notice Period to which I clearly said 3 months. He scheduled my interview on weekends morning 8am I reached there by 8.30am The interview process got started late by 10am it was an walk in type interview 1 round was Technical I cleared that round and had a feedback session with HR he said we are processing u to next round which was Manager round there itself I told the HR my NP is 3months the Hr Told its not an issue.
Laterly after I had lunch by 2pm Hr came n told me that Manager is not available now so we will be conducting ur further round in weekdays.
Then there was no mail or call so I purposely mailed them still haven't got proper response from them, so at last I told my friend who referd me to ask for an update the same HR told him that they want Immediate joiner so we can't process him to further round. Wasted my whole day over there

I applied via Recruitment Consultant and was interviewed before Jan 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What Prog Languages known? Prior Software Experience? How good on U.S. Client Face to Face and telephonic interaction for projects?
  • Ans. 

    I am proficient in Java, Python, and C++. I have 2 years of experience in software development. I have excellent communication skills for client interaction.

    • Proficient in Java, Python, and C++

    • 2 years of software development experience

    • Excellent communication skills for client interaction

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I wasn't fluent or good in Programming languages but I was clear on the flowchart and the basic concept of OOPS. Also, I was confident about solving the scenarios given to me at interview rounds. I also had good experience in US customer handling over telephonic and Face to Face interaction.

I applied via Campus Placement and was interviewed before Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Mostly hr questions and software questions

Interview Preparation Tips

Interview preparation tips for other job seekers - just give your best

I applied via Naukri.com and was interviewed before Oct 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions related to angular,c# and sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to be technically strong

IVY SOFTWARE DEVELOPMENT SERVICES Interview FAQs

How many rounds are there in IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst interview for freshers?
IVY SOFTWARE DEVELOPMENT SERVICES interview process for freshers usually has 2 rounds. The most common rounds in the IVY SOFTWARE DEVELOPMENT SERVICES interview process for freshers are Technical and HR.
How to prepare for IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst interview for freshers?
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 IVY SOFTWARE DEVELOPMENT SERVICES. The most common topics and skills that interviewers at IVY SOFTWARE DEVELOPMENT SERVICES expect are Oracle 11G, Data Modeling, Data Warehousing, Oracle SQL and PLSQL.
What are the top questions asked in IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst interview for freshers?

Some of the top questions asked at the IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst interview for freshers -

  1. How do you find the scope of tuning in a sql que...read more
  2. What is difference between insert and insert all? is it same or differe...read more

Tell us how to improve this page.

IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst Interview Process for Freshers

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS iON Interview Questions
3.9
 • 369 Interviews
ITC Infotech Interview Questions
3.6
 • 341 Interviews
CitiusTech Interview Questions
3.3
 • 277 Interviews
NeoSOFT Interview Questions
3.6
 • 268 Interviews
Tiger Analytics Interview Questions
3.7
 • 227 Interviews
Altimetrik Interview Questions
3.8
 • 223 Interviews
Episource Interview Questions
3.9
 • 220 Interviews
View all
Senior Software Engineer
55 salaries
unlock blur

₹9.1 L/yr - ₹19.8 L/yr

Test Engineer
49 salaries
unlock blur

₹5.9 L/yr - ₹8.9 L/yr

Software Engineer
45 salaries
unlock blur

₹6.8 L/yr - ₹14 L/yr

System Analyst
36 salaries
unlock blur

₹16.1 L/yr - ₹26.5 L/yr

Senior System Analyst
24 salaries
unlock blur

₹19 L/yr - ₹35 L/yr

Explore more salaries
Compare IVY SOFTWARE DEVELOPMENT SERVICES with

ITC Infotech

3.6
Compare

CMS IT Services

3.1
Compare

KocharTech

3.9
Compare

3i Infotech

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