LTIMindtree MS SQL DBA Interview Questions and Answers

Q1. WHAT IS YOUR EXPIRENCE?
Add your answer
Q2. WHAT IS YOUR HIGHER GRADUATION PERIOD.
Add your answer

Q1. Dba backups in sql
Ans. 
DBA backups in SQL are essential for data protection and disaster recovery.
• Regularly schedule full, differential, and transaction log backups to ensure data is protected.

• Store backups in secure locations to prevent data loss in case of hardware failure or corruption.

• Test backups regularly to ensure they can be restored successfully in case of emergency.
Answered by AI
Add your answer
Q2. Dba replication
Add your answer

Q1. Tell me about urself
Ans. 
I am a dedicated and experienced MS SQL DBA with a strong background in database administration and performance tuning.
• Over 5 years of experience working as a MS SQL DBA

• Proficient in database administration tasks such as backup and recovery, performance tuning, and security

• Skilled in troubleshooting and resolving database-related issues

• Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Serv...read more
Answered by AI
Add your answer
Q2. Strengths and weakness
Add your answer

Q1. What is pull request
Ans. 
A pull request is a method of submitting contributions to a project on GitHub for review and merging.
• Pull requests are commonly used in version control systems like Git to propose changes to a codebase.

• They allow developers to collaborate and discuss changes before merging them into the main branch.

• Pull requests typically include a description of the changes, related issues, and any necessary tests or documentation.

• Rev...read more
Answered by AI
Add your answer

Q1. What is sateful set
Ans. 
Stateful set is a Kubernetes controller that manages the deployment and scaling of a set of pods with persistent storage.
• Stateful set ensures that each pod in the set has a unique identity and stable network identity.

• Stateful set pods are created in order and are not replaced until they are deleted.

• Stateful set is commonly used for stateful applications like databases where each pod requires persistent storage.

• Example:...read more
Answered by AI
Add your answer

Q1. What are the steps involved in migration
Ans. 
Steps involved in migration process
• Assess current environment and identify migration goals

• Choose migration method (manual, scripted, tool-based)

• Prepare target environment and perform data migration

• Test migrated data and applications for functionality

• Implement post-migration tasks like user training and support
Answered by AI
Add your answer
Q2. How to do migrating from 2008 to 2019
Ans. 
Migrating from SQL Server 2008 to 2019 involves upgrading the database, transferring data, and testing for compatibility.
• Perform a side-by-side upgrade by installing SQL Server 2019 on a new server and transferring databases using backup and restore or detach and attach methods.

• Use the Data Migration Assistant tool to assess compatibility issues and plan for any necessary changes.

• Update applications and scripts to ensu...read more
Answered by AI
Add your answer

Q1. Difference between logshipping mirroring, tempdb corruption, master db corruption, agents used in replication
Ans. 
Explanation of differences between logshipping, mirroring, tempdb corruption, master db corruption, and agents used in replication
• Logshipping involves copying and restoring transaction logs from one server to another for disaster recovery.

• Mirroring involves maintaining an exact copy of a database on a secondary server for failover purposes.

• Tempdb corruption can occur due to hardware failures, software bugs, or other is...read more
Answered by AI
Add your answer

Q1. Share your experience about your company with us
Add your answer
Q2. Tell me about roles and responsibilities
Add your answer

Q1. What ctc are you expecting
Ans. 
I am expecting a competitive salary based on my experience, skills, and the market rate for MS SQL DBAs.
• I am looking for a salary that reflects my expertise in MS SQL Server administration.

• I am open to negotiation based on the specific responsibilities and benefits offered.

• I have researched the average salary range for MS SQL DBAs in this location and industry.

• I am also considering other factors such as opportunities f
Answered by AI
Add your answer
Q2. Are you willing to relocate
Add your answer

Q1. SQL patching, migration
Add your answer

Logical Aptitude, Verbal, Numerical

2 codes one small and easy , another big and medium difficultly

Q1. Introduction , Academic Project,
Add your answer
Q2. Coding Questions, Company Related Questions
Add your answer