Add office photos
Engaged Employer
i
This company page is being actively managed by
DXC Technology Team. If you also belong to the team, you
can get access from
here
DXC Technology
Compare
Filter interviews by
DXC Technology MS SQL DBA Interview Questions, Process, and Tips
Updated
12 Dec 2020
1 DXC Technology MS SQL DBA Interview Experience
32 questions found
Sort by:
Popular
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
Interview questions from similar companies
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)
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
4 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
Aptitude Test Round
Asked question from basic aptitude topics
3
Technical Round (1 Question)
- Q1. Asked question coding languages like c, python, java, SQL Add Answer
4
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
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
1
Technical Round (2 Questions)
- Q1. Architecture of sql View Answers (1)
- Q2. Recovery models Add Answer
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
1
Coding Test Round
Test your algorithmic thinking and problem solving skills
2
One-on-one Round (1 Question)
- Q1. Communications,clearity of answers Add Answer
3
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
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
I applied via Campus Placement
2 Interview Rounds
1
Aptitude Test Round
It was simple round.
2
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
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Referral and was interviewed before Feb 2022.
4 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2
Technical Round (2 Questions)
- Q1. How user login flow happens for ERP? View Answers (1)
- Q2. Many online resources available. You can answer based on your understanding Add Answer
3
Technical Round (2 Questions)
- Q1. Can we apply ebs patches using adpatch in EBS 12.2? View Answers (2)
- Q2. No. EBS 12.2 supports only adop to apply patches View Answers (1)
4
HR Round (2 Questions)
- Q1. What is your current CTC and Expected CTC? Add Answer
- Q2. This is personal to every one Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Get Package while joining itself. Yearly hikes are less than 10%
Great work culture and team leads. Genpact having excellent DBA projects with latest technologies.
Great work culture and team leads. Genpact having excellent DBA projects with latest technologies.
Skills evaluated in this interview
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 experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Jul 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Difference between logshipping mirroring, tempdb corruption, master db corruption, agents used in replication View Answers (1)
DXC Technology Interview FAQs
What are the top questions asked in DXC Technology MS SQL DBA interview?
Some of the top questions asked at the DXC Technology MS SQL DBA interview -
Tell us how to improve this page.
DXC Technology Interviews By Designations
- DXC Technology Associate Software Engineer Interview Questions
- DXC Technology Associate Professional Interview Questions
- DXC Technology Software Engineer Interview Questions
- DXC Technology Associate Professional Software Engineer Interview Questions
- DXC Technology Software Developer Interview Questions
- DXC Technology Associate Engineer Interview Questions
- DXC Technology Business Analyst Interview Questions
- DXC Technology Senior Assistant Service Delivery Coordinator Interview Questions
- Show more
Interview Questions for Popular Designations
- SQL Database Administrator Interview Questions
- Oracle Apps DBA Interview Questions
- DBA Consultant Interview Questions
- Lead DBA Interview Questions
- SQL Server Developer Interview Questions
- SQL Server Database Administrator Interview Questions
- DBA Administrator Interview Questions
- Postgresql DBA Interview Questions
- Show more
People are getting interviews through
based on 1 DXC Technology interview
Job Portal
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
MS SQL DBA Interview Questions from Similar Companies
Fast track your campus placements
7%
less
than the average MS SQL DBA Salary in India
View more details
DXC Technology MS SQL DBA Reviews and Ratings
based on 4 reviews
Rating in categories
|
Associate Professional Software Engineer
2.4k
salaries
|  ₹2.6 L/yr - ₹6.7 L/yr |
|
Software Engineer
2.2k
salaries
| ₹2.4 L/yr - ₹11.1 L/yr |
|
Associate Professional
2k
salaries
| ₹2.2 L/yr - ₹7.2 L/yr |
|
Associate Software Engineer
1.4k
salaries
| ₹2.5 L/yr - ₹7 L/yr |
|
Professional 1
1.2k
salaries
| ₹3 L/yr - ₹12.5 L/yr |
Explore more salaries
Compare DXC Technology with
Cognizant
Compare
Capgemini
Compare
TCS
Compare
Wipro
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 >
- DXC Technology Interview Questions >
- DXC Technology MS SQL DBA Interview Questions
Share an Interview