Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 1K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

RATE NOW!
- ABECA 2025
  
  RATE NOW!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Employer? Claim Account for FREE

Atos

Compare

3.8

based on 2.9k Reviews

Filter interviews by

Atos MS SQL DBA Interview Questions and Answers

Updated 29 Mar 2023

1 interview found

Sort by: Popular

MS SQL DBA Interview Questions

Anonymous

posted on 29 Mar 2023

Interview experience

Good

Difficulty level

Duration

Result

4 Interview Rounds

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

Aptitude Test Round

Asked question from basic aptitude topics

Technical Round (1 Question)

Q1. Asked question coding languages like c, python, java, SQL
Add Answer

HR Round (1 Question)

Q1. Discussed about terms and policies of company. Also work profile
Add Answer

Interview Preparation Tips

Interview preparation tips for other job seekers - I joined this company as fresher. For fresher if you are having basic aptitude and technical knowledge then it is easy to crack interview

Useful Resources

Atos MS SQL DBA Fresher Interview Questions

Top trending discussions

View All

I’m 27, I’m looking for Career transition

Hello ,I hold bachelor degree in mechanical engineering 2019. With 4.5 yoe in Total 1)Associate product compliance engineer - 1.5 years 2)Currently working as Project engineer (compliance). 3 years I see no growth in my current company and current role.so I’m looking for career shift,high growth and good package. Skills 1) Environmental compliance(REACH,ROHS,..) 2)Basic networking OS,Linux basic, Aws cloud 3) SAP MM (in progress) 4) Project Management (self preparation from PMBOk) I’m confused between sap mm consultant and project management I’m getting difficult to choose,Which would be great choice according to my background and high pay, stable job Can anybody recommend which domain /role is good for career transition! I’m looking for career shift Help will be appreciated. Current role Project engineer handling projects related to environmental compliance. FYI

Got a question about Atos?

Ask anonymously on communities.

Interview questions from similar companies

MS SQL DBA Interview Questions

Capgemini

Anonymous

posted on 7 Nov 2024

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

Technical Round (1 Question)

Q1. What is pull request
View Answers (1)

Technical Round (1 Question)

Q1. What is sateful set
View Answers (1)

Useful Resources

Capgemini MS SQL DBA Experienced Interview Questions

MS SQL DBA Interview Questions

DXC Technology

Anonymous

posted on 12 Dec 2020

I applied via Naukri.com and was interviewed before Dec 2019.

3 Interview Rounds

Interview Questions

Q1. Introduce yourself Add Answer
Q2. What are blockings ? What are deadlocks and difference to blockings ? View Answers (2)
Q3. How to know about deadlocks in sql server? View Answers (1)
Q4. What is the parameter (-1) used in DBCC TRACEON(1204,-1) ? Why it is used? View Answers (1)
Q5. What is the backup strategy you have? View Answers (1)
Q6. What is point in time recovery? View Answers (2)
Q7. What are the issues you faced in log shipping? View Answers (1)
Q8. What are some critical issues you faced in your previous projects? Add Answer
Q9. While applyong patching, some msi files are missing ? How do you resolve this? View Answers (1)
Q10. Do you have idea on replication ? View Answers (2)
Q11. How to index reorganize and index rebuild based on index fragmentation? View Answers (1)
Q12. When to update statistics with respect to index rebuild and reorganize ? (Maintenance plans) View Answers (1)
Q13. What is the database size you jave used in your previous project? View Answers (2)
Q14. What is the backup strategy for the biggest database you handled? View Answers (2)
Q15. Every day i take full backup at midnight, log backup every one hour. Can i perform point in time recovery upto 07:30pm ? View Answers (1)
Q16. What is the command for the Tail log backup? View Answers (2)
Q17. What is your notice period in your current company? Add Answer
Q18. Do you have any idea on SQL Profiler ? View Answers (2)
Q19. If TempDB is full, how do you resolve it? View Answers (1)
Q20. What are the isolation levels in sql server? View Answers (1)
Q21. What is the default isolation level in sql server? What happens with that isolation level ? View Answers (3)
Q22. What is the default port of sql server & Can we change the default port, if so where can we change it? View Answers (3)
Q23. If someone has deleted the table in a database, then how can you find out the user that has deleted the table ? Can you find out using the log file? Can you ret...read more View Answers (3)
Q24. When we run CheckDB, what command it runs in the background ? View Answers (2)
Q25. What is the difference between Summary.txt and Detail.txt ? View Answers (1)
Q26. Do you use any monitoring tool for monitoring Sql server? View Answers (1)
Q27. What ticketing tool you use? View Answers (2)
Q28. What do you used to do using the ticketing tool? View Answers (1)
Q29. Will you only work on the tickets or do you raise any tickets ? Add Answer
Q30. Do you have any questions to me? Add Answer
Q31. Are you fine with rotational shifts? Add Answer
Q32. Are you immediate joiner? Add Answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on routine activites of your job role as SQL DBA.

Skills evaluated in this interview

Useful Resources

DXC Technology MS SQL DBA Experienced Interview Questions

SQL Database Administrator Interview Questions

NTT Data Information Processing Services

Anonymous

posted on 11 Nov 2024

Interview experience

Average

Difficulty level

Duration

Result

1 Interview Round

Technical Round (2 Questions)

Q1. Architecture of sql
View Answers (1)
Q2. Recovery models
Add Answer

SQL Database Administrator Interview Questions

IBM

Anonymous

posted on 17 May 2024

Interview experience

Excellent

Difficulty level

Moderate

Duration

Less than 2 weeks

Result

Not Selected

I applied via Company Website and was interviewed in Apr 2024.

3 Interview Rounds

Coding Test Round

Test your algorithmic thinking and problem solving skills

One-on-one Round (1 Question)

Q1. Communications,clearity of answers
Add Answer

HR Round (1 Question)

Q1. Discussion about packages,joining date
Add Answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Self assessment,Techical preparation

Useful Resources

IBM SQL Database Administrator Experienced Interview Questions

SQL Database Administrator Interview Questions

Accenture

Anonymous

posted on 28 Jun 2024

Interview experience

Excellent

Difficulty level

Duration

Result

I applied via Campus Placement

2 Interview Rounds

Aptitude Test Round

It was simple round.

Coding Test Round

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

Oracle Apps DBA Interview Questions

Genpact

Anonymous

posted on 4 Feb 2023

Interview experience

Excellent

Difficulty level

Moderate

Duration

Less than 2 weeks

Result

Selected

I applied via Referral and was interviewed before Feb 2022.