Microland MS SQL DBA Interview Questions and Answers

Q1. Explain locks and latches
Ans. 
Locks and latches are mechanisms used in database management systems to control access to data and ensure data integrity.
• Locks are used to control access to data by preventing multiple users from modifying the same data simultaneously.

• Latches are lightweight synchronization mechanisms used to protect data structures in memory.

• Locks can be of different types such as shared locks, exclusive locks, and update locks.

• Latche...read more
Answered by AI
Add your answer
Q2. Isolation level in DB
Ans. 
Isolation level determines how transactions interact with each other in a database.
• Isolation levels include Read Uncommitted, Read Committed, Repeatable Read, Serializable.

• Higher isolation levels provide more data consistency but may lead to more locking and potential performance issues.

• Example: Using Read Uncommitted isolation level allows reading uncommitted data, while Serializable ensures data integrity but may lea...read more
Answered by AI
Add your answer

Basic Apptitude. SQL & logic in

Very easy topic. You just need to have fluent English.

They took two GD as many people were selected

Q1. They asked basic and advanced SQL queries
Add your answer

They took aptitude test in which there was a set of 30 questions like mathematical and logical

Q1. Where do you live? Tell me about your family. Will you get shift in another city if required?
Add your answer
Q2. Tell me about your family
Add your answer
Q3. For which job role are you looking for ?
Add your answer

Q1. Tell me about your project. What technologies has been used in your project? Is there anyone in your family who comes from I.T background? And question related to mysql queries
Add your answer

Q1. In this process HR gives Basic idea regarding salary and ask basic questions
Add your answer

Q1. Explain locks and latches
Ans. 
Locks and latches are mechanisms used in database management systems to control access to data and ensure data integrity.
• Locks are used to control access to data by preventing multiple users from modifying the same data simultaneously.

• Latches are lightweight synchronization mechanisms used to protect data structures in memory.

• Locks can be of different types such as shared locks, exclusive locks, and update locks.

• Latche...read more
Answered by AI
Add your answer
Q2. Isolation level in DB
Ans. 
Isolation level determines how transactions interact with each other in a database.
• Isolation levels include Read Uncommitted, Read Committed, Repeatable Read, Serializable.

• Higher isolation levels provide more data consistency but may lead to more locking and potential performance issues.

• Example: Using Read Uncommitted isolation level allows reading uncommitted data, while Serializable ensures data integrity but may lea...read more
Answered by AI
Add your answer

Q1. DB Architecture questions
Add your answer
Q2. Performance tuning Question
Add your answer

Q1. Db model, Db role & Server role, SQL server architecture,
Ans. Log shipping, migration, HA, Always on, clustering, mirroring
Answered Anonymously
Add your answer
Q2. Sql server database administrator structure
Ans. 
The SQL Server DBA structure includes roles such as junior DBA, senior DBA, and lead DBA.
• Junior DBA: responsible for basic tasks such as backups and restores

• Senior DBA: responsible for performance tuning and troubleshooting

• Lead DBA: responsible for managing the team and making strategic decisions

• Other roles may include database architect and database developer

• The structure may vary depending on the organization's size
Answered by AI
Add your answer

Easy aptitude test. Nothing difficult.

Q1. Technical round involves your basic understanding of Database management systems. How it works ? What is the role of a DBA ?
Add your answer

Q1. Very normal HR round
Add your answer