Premium Employer

i

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

Infosys Verified Tick

Compare button icon Compare button icon Compare
3.6

based on 37.8k Reviews

Filter interviews by

Infosys SQL Database Administrator Interview Questions and Answers

Updated 14 Dec 2024

Infosys SQL Database Administrator Interview Experiences

2 interviews found

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

(1 Question)

  • Q1. What major issues have you faced in your professional experience?
Round 2 - HR 

(1 Question)

  • Q1. What are your salary expectations for this position?

Interview Questionnaire 

1 Question

  • Q1. HA DR, back up, logs, Replication

Interview Preparation Tips

Interview preparation tips for other job seekers - High availability and disaster recovery

SQL Database Administrator Interview Questions Asked at Other Companies

asked in TCS
Q1. What is a database management System and what is concept of prima ... read more
asked in TCS
Q2. Diff composite and non composite key and then to create primary k ... read more
asked in TechnoGen
Q3. how to create new users/ login, how to create new job, what are t ... read more
asked in TCS
Q4. Which programming language do you prefer and why?
asked in TCS
Q5. What is Maps, Hash maps, Skeleton class OOPS concepts?

SQL Database Administrator Jobs at Infosys

View all

Interview questions from similar companies

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

I applied via Referral and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What is dirty read.
  • Ans. 

    Dirty read is when a transaction reads data that has been modified by another transaction but not yet committed.

    • Occurs when a transaction reads uncommitted data from another transaction

    • Can lead to inconsistent or incorrect results

    • Can be prevented by using proper isolation levels in database transactions

  • Answered by AI
  • Q2. What all processes occurres when a db restarts.
  • Ans. 

    When a database restarts, various processes occur such as recovery, rollback, and reapplying transactions.

    • Recovery process ensures that the database is in a consistent state by rolling back uncommitted transactions and redoing committed transactions.

    • Rollback process undoes any changes made by transactions that were not committed before the restart.

    • Reapplying transactions involves re-executing transactions that were com...

  • Answered by AI
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Architecture of sql
  • Ans. 

    SQL architecture refers to the structure and components of a SQL database system.

    • SQL architecture includes components like storage engine, query processor, and buffer manager.

    • The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

    • The buffer manager handles caching and memory management to optimize performance.

    • Examples of SQL architectures include MySQL, Oracle, and SQL Se

  • Answered by AI
  • Q2. Recovery models

Skills evaluated in this interview

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

I applied via Company Website and was interviewed in Apr 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Test your algorithmic thinking and problem solving skills

Round 2 - One-on-one 

(1 Question)

  • Q1. Communications,clearity of answers
Round 3 - HR 

(1 Question)

  • Q1. Discussion about packages,joining date

Interview Preparation Tips

Interview preparation tips for other job seekers - Self assessment,Techical preparation
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

It was simple round.

Round 2 - Coding Test 

It fully based on the array concept

Interview Preparation Tips

Interview preparation tips for other job seekers - please find the right job with your knowledge and interest .Thank you
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Oct 2023. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Salary discussion
  • Q2. About previous company and quit reason
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 Feb 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

It was a normal assessment including coding questions and then English Test.

Round 2 - Technical 

(1 Question)

  • Q1. Basic questions about DB, OS and Networking

I applied via Referral and was interviewed in Apr 2022. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Logshipping, mirroring, failover clustering and always on

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong with sql hadr scenarios and concepts. Adding dmvs in the answer make a good impression.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed before Aug 2022. There were 3 interview rounds.

Round 1 - Aptitude Test 

Aptitude test was conducted.

Round 2 - Technical 

(1 Question)

  • Q1. Technical questions were asked
Round 3 - HR 

(1 Question)

  • Q1. What's the salary expectation

Infosys Interview FAQs

How many rounds are there in Infosys SQL Database Administrator interview?
Infosys interview process usually has 2 rounds. The most common rounds in the Infosys interview process are Technical and HR.
How to prepare for Infosys SQL Database Administrator 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 Infosys. The most common topics and skills that interviewers at Infosys expect are Database Administration, SQL, SQL DBA, Postgresql and Performance Engineering.

Tell us how to improve this page.

Infosys SQL Database Administrator Interview Process

based on 3 interviews

Interview experience

4.3
  
Good
View more
Join Infosys Creating the next opportunity for people, businesses & communities
Infosys SQL Database Administrator Salary
based on 215 salaries
₹3 L/yr - ₹11.7 L/yr
7% more than the average SQL Database Administrator Salary in India
View more details

Infosys SQL Database Administrator Reviews and Ratings

based on 16 reviews

3.0/5

Rating in categories

3.2

Skill development

3.1

Work-life balance

2.2

Salary

3.3

Job security

3.2

Company culture

2.1

Promotions

2.5

Work satisfaction

Explore 16 Reviews and Ratings
Postgresql Database Administrator

Pune,

Chennai

+1

4-9 Yrs

Not Disclosed

Explore more jobs
Technology Analyst
56.2k salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Senior Systems Engineer
50k salaries
unlock blur

₹2.8 L/yr - ₹9.2 L/yr

System Engineer
39.2k salaries
unlock blur

₹2.5 L/yr - ₹5.5 L/yr

Technical Lead
30.7k salaries
unlock blur

₹5.2 L/yr - ₹19.5 L/yr

Senior Associate Consultant
27.4k salaries
unlock blur

₹6.2 L/yr - ₹17 L/yr

Explore more salaries
Compare Infosys with

TCS

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.8
Compare

Accenture

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