Add office photos
Engaged Employer
i
This company page is being actively managed by
Cognizant Team. If you also belong to the team, you
can get access from
here
Cognizant
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Cognizant Lead DBA Interview Questions and Answers
Updated
9 Jul 2022
1 interview found
Sort by:
Popular
Anonymous
I applied via Naukri.com and was interviewed in Jul 2021.
2 Interview Rounds
Interview Questions
- Q1. Architecture of mysql ,innodb , performance tuning
Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be confident , have cloud basic idea, understanding of current environment
Interview questions from similar companies
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. RAC,ASM,GG, Oracle Architecture Standby database Add Answer
2
HR Round (1 Question)
- Q1. General, salary discussion` Add Answer
I applied via Recruitment Consulltant and was interviewed before Sep 2021.
3 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 (2 Questions)
- Q1. I don't remember them now Add Answer
- Q2. I don't remember them now yes Add Answer
3
HR Round (2 Questions)
- Q1. I don't remember them now ? Add Answer
- Q2. I don't remember them now ? No Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - I don't remember them now , i don't remember them now
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
-
I applied via Approached by Company and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (3 Questions)
- Q1. SQL Question on window functions to find the highest sale amount per day of the stores Add Answer
- Q2. Build an ETL Pipeline to read json files which are dropping at irregular times into storage. So how do you transform and match the schema etc., Add Answer
- Q3. Write a pyspark code to join two tables and explain broadcastjoin() & what it does? Add Answer
Interview experience
Excellent
Difficulty level
-
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Oct 2024.
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. What is pull request View Answers (1)
2
Technical Round (1 Question)
- Q1. What is sateful set View Answers (1)
Prathapgowda P M
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. What is dba, explain the architecture of dba View Answers (1)
- Q2. How you will maintain the database and what are the types of backup View Answers (1)
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Dataguard architecture Add Answer
- Q2. Rman backup and restoration Add Answer
2
HR Round (1 Question)
- Q1. Why you join inm View Answers (1)
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (3 Questions)
- Q1. Given a DataFrame df with columns 'A', 'B','C' how would you group the data by the values in column 'A' and calculate the mean of column 'B' for each group, whi...read more View Answers (1)
- Q2. Explain the difference deepcopy() and copy() methods in Python's copy module. Provide a scenario where you would use deepcopy() over copy(). View Answers (1)
- Q3. Discuss the concept of Python decorators and provide an example of how you would use decorators to measure the execution time of a function. View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - I would like you to approach the interview with enthusiasm, demonstrating passion and eagerness in your interview aligns with their mission of driving innovation and positive change.
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via LinkedIn and was interviewed in Jun 2024.
2 Interview Rounds
1
Coding Test Round
Sql queries on top clause
2
HR Round (2 Questions)
- Q1. Why u want to join View Answers (1)
- Q2. What is the salary expectation View Answers (1)
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (1 Question)
- Q1. Tell about yourself View Answers (1)
Tell us how to improve this page.
Cognizant Interviews By Designations
- Cognizant Programmer Analyst Interview Questions
- Cognizant Programmer Analyst Trainee Interview Questions
- Cognizant Associate Interview Questions
- Cognizant Senior Associate Interview Questions
- Cognizant Processing Executive Interview Questions
- Cognizant Software Engineer Interview Questions
- Cognizant Senior Processing Executive Interview Questions
- Cognizant Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- MS SQL DBA Interview Questions
- Oracle Apps DBA Interview Questions
- Lead Data Engineer Interview Questions
- DBA Consultant Interview Questions
- DBA Administrator Interview Questions
- Postgresql DBA Interview Questions
- Oracle Database Administrator Interview Questions
- ETL Lead Interview Questions
- Show more
People are getting interviews through
based on 1 Cognizant interview
Job Portal
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Interview Questions from Similar Companies
Fast track your campus placements
16%
less
than the average Lead DBA Salary in India
View more details
Cognizant Lead DBA Reviews and Ratings
based on 1 review
Rating in categories
|
Associate
75.5k
salaries
|  ₹2.8 L/yr - ₹14 L/yr |
|
Programmer Analyst
56.3k
salaries
| ₹2.4 L/yr - ₹9.6 L/yr |
|
Senior Associate
47.4k
salaries
| ₹8.8 L/yr - ₹26.3 L/yr |
|
Senior Processing Executive
28.5k
salaries
| ₹1.8 L/yr - ₹9 L/yr |
|
Technical Lead
17.9k
salaries
| ₹5.9 L/yr - ₹24 L/yr |
Explore more salaries
Compare Cognizant with
TCS
Compare
Infosys
Compare
Wipro
Compare
Accenture
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
- Home >
- Interviews >
- Cognizant Interview Questions >
- Cognizant Lead DBA Interview Questions
Share an Interview