Add office photos
i
e-Zest
Compare
Filter interviews by
e-Zest MS SQL DBA Interview Questions and Answers
e-Zest MS SQL DBA Interview Experiences
1 interview found
Anonymous
(1 Question)
- Q1. What is DBA? Roles
- Ans.
DBA stands for Database Administrator. They are responsible for managing and maintaining databases.
Responsible for ensuring the availability and performance of databases
Implementing security measures to protect data
Backup and recovery of data
Monitoring database activity and optimizing performance
Troubleshooting and resolving database issues
Interview questions from similar companies
I applied via Referral and was interviewed in Apr 2024. There were 4 interview rounds.
They took aptitude test in which there was a set of 30 questions like mathematical and logical
(3 Questions)
- Q1. Where do you live? Tell me about your family. Will you get shift in another city if required?
- Q2. Tell me about your family
- Q3. For which job role are you looking for ?
(1 Question)
- 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
(1 Question)
- Q1. In this process HR gives Basic idea regarding salary and ask basic questions
Interview Preparation Tips
- MySQL
(3 Questions)
- Q1. New SQL Server installation and configuration
- Ans.
New SQL Server installation and configuration
Determine hardware and software requirements
Install SQL Server software
Configure server settings and security
Create and configure databases
Set up backup and recovery procedures
- Q2. Maintaining high availability like log shipping mirroring transactional replication always on and clustering
- Q3. Database migration from lower version to higher version
- Ans.
Database migration involves upgrading a lower version of a database to a higher version.
Ensure compatibility between the source and target database versions
Backup the source database before migration
Use a migration tool or script to transfer data and schema
Test the migrated database thoroughly before deploying to production
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Aug 2023. There was 1 interview round.
(2 Questions)
- 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...
- 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...
Interview Preparation Tips
SQL Database Administrator Interview Questions & Answers
Mastek
Jessica Gonsalves
posted on 16 Oct 2023
I applied via campus placement at St Francis Institute of Technology, Mumbai and was interviewed in Apr 2023. There were 5 interview rounds.
Basic Apptitude. SQL & logic in
Very easy topic. You just need to have fluent English.
They took two GD as many people were selected
(1 Question)
- Q1. They asked basic and advanced SQL queries
Interview Preparation Tips
- SQL
- Logic
I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Interview with KGISL..?
Interview Preparation Tips
I applied via Referral and was interviewed in Apr 2024. There were 4 interview rounds.
They took aptitude test in which there was a set of 30 questions like mathematical and logical
(3 Questions)
- Q1. Where do you live? Tell me about your family. Will you get shift in another city if required?
- Q2. Tell me about your family
- Q3. For which job role are you looking for ?
(1 Question)
- 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
(1 Question)
- Q1. In this process HR gives Basic idea regarding salary and ask basic questions
Interview Preparation Tips
- MySQL
(3 Questions)
- Q1. New SQL Server installation and configuration
- Ans.
New SQL Server installation and configuration
Determine hardware and software requirements
Install SQL Server software
Configure server settings and security
Create and configure databases
Set up backup and recovery procedures
- Q2. Maintaining high availability like log shipping mirroring transactional replication always on and clustering
- Q3. Database migration from lower version to higher version
- Ans.
Database migration involves upgrading a lower version of a database to a higher version.
Ensure compatibility between the source and target database versions
Backup the source database before migration
Use a migration tool or script to transfer data and schema
Test the migrated database thoroughly before deploying to production
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Aug 2023. There was 1 interview round.
(2 Questions)
- 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...
- 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...
Interview Preparation Tips
(2 Questions)
- Q1. DB Architecture questions
- Q2. Performance tuning Question
Interview Preparation Tips
e-Zest Interview FAQs
Tell us how to improve this page.
e-Zest Interviews By Designations
- e-Zest Software Engineer Interview Questions
- e-Zest Software Engineer Trainee Interview Questions
- e-Zest Software Developer Interview Questions
- e-Zest Technical Lead Interview Questions
- e-Zest Associate Project Manager Interview Questions
- e-Zest Automation Test Engineer Interview Questions
- e-Zest Business Analyst Interview Questions
- e-Zest Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- SQL Database Administrator Interview Questions
- Oracle Apps DBA Interview Questions
- DBA Consultant Interview Questions
- SQL Server Developer Interview Questions
- Lead DBA Interview Questions
- SQL Server Database Administrator Interview Questions
- DBA Administrator Interview Questions
- Postgresql DBA Interview Questions
- Show more
MS SQL DBA Interview Questions from Similar Companies
|
Softwaretest Engineer
559
salaries
|  ₹2.4 L/yr - ₹8.5 L/yr |
|
Software Engineer
294
salaries
| ₹3.2 L/yr - ₹16.8 L/yr |
|
Senior Software Engineer
208
salaries
| ₹9 L/yr - ₹29.2 L/yr |
|
Software Quality Analyst
138
salaries
| ₹3.5 L/yr - ₹5.8 L/yr |
|
Software Developer
115
salaries
| ₹5.3 L/yr - ₹21.6 L/yr |
Persistent Systems
TCS
Infosys
Wipro
Calculate your in-hand salary
- Home >
- Interviews >
- e-Zest Interview Questions >
- e-Zest MS SQL DBA Interview Questions
