Upload Button Icon Add office photos

Filter interviews by

IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst Interview Questions and Answers

Updated 23 Feb 2024

IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst Interview Experiences

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 experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
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 

(2 Questions)

  • Q1. Q.About SQL Server T-SQL
  • Q2. Q.Normal scenario based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - HR is too busy. HR called to schedule the interview but forgot to schedule interview. After reminding HR, HR scheduled the interview but did not give any feedback after the interview. sending messages and emails, but HR didn't respond.waste of time.
Round 1 - Technical 

(1 Question)

  • Q1. Needs to aware of troubleshooting skills

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to aware of troubleshooting skills and knowledge

I applied via LinkedIn and was interviewed before Aug 2021. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Basic technical questions Database Architecture Tablespace management User management Db links/networking Rman backup strategy
Round 2 - Technical 

(1 Question)

  • Q1. Performance tuning Dataguard Rac basic ASM

Interview Preparation Tips

Interview preparation tips for other job seekers - Good place to learn...with medium scale salary but less work load

I applied via Referral and was interviewed in Jan 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Expert level SQL knowledge,questions on SQL queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and if you don't know the answer asked in interview do not panic
Just assure the interviewer that ur ready to learn anything given an opportunity
Do not fake or do not show the desperation for the job
Never tell yes to everything
Provide a stipulated time for you to learn the process

IVY SOFTWARE DEVELOPMENT SERVICES Interview FAQs

How many rounds are there in IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst interview?
IVY SOFTWARE DEVELOPMENT SERVICES interview process usually has 2 rounds. The most common rounds in the IVY SOFTWARE DEVELOPMENT SERVICES interview process are Technical and HR.
How to prepare for IVY SOFTWARE DEVELOPMENT SERVICES Database Analyst 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 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?

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

  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

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.6k Interviews
Wipro Interview Questions
3.7
 • 5.7k 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
 • 810 Interviews
TCS iON Interview Questions
3.9
 • 365 Interviews
View all
Senior Software Engineer
53 salaries
unlock blur

₹10.5 L/yr - ₹18 L/yr

Test Engineer
46 salaries
unlock blur

₹5.9 L/yr - ₹8.9 L/yr

Software Engineer
44 salaries
unlock blur

₹7.7 L/yr - ₹14 L/yr

System Analyst
38 salaries
unlock blur

₹15 L/yr - ₹23 L/yr

Senior Test Engineer
23 salaries
unlock blur

₹8.5 L/yr - ₹15 L/yr

Explore more salaries
Compare IVY SOFTWARE DEVELOPMENT SERVICES with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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