Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by LTIMindtree Team. If you also belong to the team, you can get access from here

LTIMindtree Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 18.9k Reviews

Filter interviews by

LTIMindtree DB2 Database Administrator Interview Questions and Answers

Updated 17 Nov 2024

1 interview found

Sort by: Popular
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Approached by Company and was interviewed in May 2024.

2 Interview Rounds

1

Aptitude Test Round

It was good interview everyone was friendly

2

HR Round (2 Questions)

  • Q1. Why are you switching your current job
  • Q2. What is your expected CTC

Interview questions from similar companies

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 4-6 weeks
Result
Selected  Selected

I was interviewed before Dec 2023.

4 Interview Rounds

1

Aptitude Test Round

It was moderate for selection

2

Technical Round (2 Questions)

  • Q1. Don't remember as more than year had passed
  • Q2. Scenarios based question
3

Behavioral Round (2 Questions)

  • Q1. Brief intro about self,studies and all
  • Q2. Regarding relocation and all
4

HR Round (2 Questions)

  • Q1. Intro and asked about strength and weakness
  • Q2. Don't remember

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing give your best,be honest rest getting placed or not that's the second thing
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed before Apr 2023.

2 Interview Rounds

1

Technical Round (3 Questions)

  • Q1. Sql related queries
  • Q2. Database maintenance
  • Q3. Monitoring and performance tuning
2

Technical Round (2 Questions)

  • Q1. In deep related to queries
  • Q2. Backup and recovery

I applied via LinkedIn and was interviewed in Mar 2022.

2 Interview Rounds

1

Resume Shortlist Round

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
2

Technical Round (1 Question)

  • Q1. Database questions What is your roles and responsibilities Tell me about the technology you are working

Interview Preparation Tips

Interview preparation tips for other job seekers - First is technical round
Second is client and thrid is salary discussion
Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. What is dba, explain the architecture of dba
  • Q2. How you will maintain the database and what are the types of backup
Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. How you will find that some user SQL running slow without discussing with user?
  • Q2. How you will patch specific db components to reduce downtime?
2

HR Round (2 Questions)

  • Q1. Why you have so many hopping in your resume?
  • Q2. How you will rate yourself as an dba?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared technically.
Be loyal in interview , if you don't know just tell
Try to be solution oriented person
Give genuine real time faced issues
Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

One-on-one Round (5 Questions)

  • Q1. What is CAP theorem What is column families What function are used in cassandra what is key value pair
  • Q2. What is Cloumn families
  • Q3. What are the functions in cassandra
  • Q4. Fundamentels of cassandra
  • Q5. What is key value pair

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Dataguard architecture
  • Q2. Rman backup and restoration
2

HR Round (1 Question)

  • Q1. Why you join inm
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 -
Result
Selected  Selected

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. What is database architecture?
  • Q2. Difference between delete and truncate

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well

Skills evaluated in this interview

Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
 -

I applied via Naukri.com and was interviewed in Mar 2024.

1 Interview Round

1

Technical Round (1 Question)

  • Q1. How would you monitor a db performance with OEM AWR report?

Interview Preparation Tips

Topics to prepare for Accenture Oracle Database Administrator interview:
  • Dataguard
  • BACKUP & recovery
  • ASM
  • Oracle RAC
Interview preparation tips for other job seekers - Be strong with basic knowledge of the how to configure, install, patch, migrate and upgrade database.. if you have mentioned RAC and performance tuning they expect you to answer more and dive deep into scenarios. Dataguard, ASM they would expect to have knowledge in these areas as well.. Moreover, have a throughout preparation based on scenarios, as they expect you to answer in scenarios where you don’t have OEM as a monitoring tool.. and if things are manually done..

LTIMindtree Interview FAQs

How many rounds are there in LTIMindtree DB2 Database Administrator interview?
LTIMindtree interview process usually has 2 rounds. The most common rounds in the LTIMindtree interview process are HR and Aptitude Test.

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10k Interviews
Accenture Interview Questions
3.9
 • 7.8k Interviews
Infosys Interview Questions
3.7
 • 7.4k Interviews
Wipro Interview Questions
3.7
 • 5.4k Interviews
Cognizant Interview Questions
3.8
 • 5.4k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.6
 • 3.6k Interviews
Genpact Interview Questions
3.9
 • 2.9k Interviews
IBM Interview Questions
4.1
 • 2.3k Interviews
View all
LTIMindtree DB2 Database Administrator Salary
based on 21 salaries
₹4.5 L/yr - ₹10.2 L/yr
25% less than the average DB2 Database Administrator Salary in India
View more details

LTIMindtree DB2 Database Administrator Reviews and Ratings

based on 3 reviews

4.6/5

Rating in categories

4.6

Skill development

4.1

Work-Life balance

4.1

Salary & Benefits

3.7

Job Security

4.1

Company culture

3.7

Promotions/Appraisal

4.6

Work Satisfaction

Explore 3 Reviews and Ratings
Senior Software Engineer
21.1k salaries
unlock blur

₹4.7 L/yr - ₹18.3 L/yr

Software Engineer
16.1k salaries
unlock blur

₹2 L/yr - ₹10 L/yr

Module Lead
6.8k salaries
unlock blur

₹7 L/yr - ₹25 L/yr

Technical Lead
6.5k salaries
unlock blur

₹9.4 L/yr - ₹36.6 L/yr

Senior Engineer
4.4k salaries
unlock blur

₹4.2 L/yr - ₹16.3 L/yr

Explore more salaries
Compare LTIMindtree with

Cognizant

3.8
Compare

Capgemini

3.8
Compare

Accenture

3.9
Compare

TCS

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview