Add office photos
Engaged Employer
i
This company page is being actively managed by
Yes Madam Team. If you also belong to the team, you
can get access from
here
Yes Madam
Compare
Filter interviews by
Yes Madam MS SQL DBA Interview Questions and Answers
Updated
25 Jan 2020
Yes Madam MS SQL DBA Interview Experiences
2 interviews found
Anonymous
I applied via Recruitment Consultant and was interviewed in Dec 2019. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Tell me something about master and slave? Replication and it's working
- Ans.
Master and slave are terms used in database replication. Master is the primary database and slave is a copy of it.
Master database is the primary database that is used for read and write operations.
Slave database is a copy of the master database that is used for read-only operations.
Replication is the process of copying data from one database to another.
Replication can be one-way or two-way.
In one-way replication, chang...
- Q2. Diff between Group By and Order By? Few scenario-based questions
Answered by
AI
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - I reached to Yes Madam office for SQL Server DBA job profile as per interview call discussion with HR(Aarti) but while technical interview time they are looking for a candidate who has knowledge of below all technologies:
SQL SERVER DBA
MYSQL DBA
Oracle DBA
TSQL/Developer Complex Queries with advanced skills.
Company HR Kumud has asked my resume, went into the room and after 2 hours sent Vikas to take my interview.
My interview was started, Vikas discussed notice period, current company, CTC and expected CTC, Experience, etc. Then the interview went outside for discussion with HR as "Vikas told our budget is very low as the company is currently growing phase......(meeting room gate close so not able heard complete discussion) and after 1-2 minute HR sent him back to the meeting room and technical interview started. He already searched questions from google before the interview with answers and ask accordingly.
The most important point is interviewer has less knowledge about Oracle/SQL DBA and developer tasks. He may be not worked on database technologies. Lack of confidence while asking questions in an interview.
Suggestion: As per company requirement shared at interview time
-->If you are a fresher with Developer + DBA skills on MSSQL, MYSQL and Oracle then this is a good company to start your career.
-->If you have hands-on experience with SQL and Oracle technologies and salary is less than 4 lakh then go to this company to increase salary (Max limit - 5 lakhs) else ignore it.
SQL SERVER DBA
MYSQL DBA
Oracle DBA
TSQL/Developer Complex Queries with advanced skills.
Company HR Kumud has asked my resume, went into the room and after 2 hours sent Vikas to take my interview.
My interview was started, Vikas discussed notice period, current company, CTC and expected CTC, Experience, etc. Then the interview went outside for discussion with HR as "Vikas told our budget is very low as the company is currently growing phase......(meeting room gate close so not able heard complete discussion) and after 1-2 minute HR sent him back to the meeting room and technical interview started. He already searched questions from google before the interview with answers and ask accordingly.
The most important point is interviewer has less knowledge about Oracle/SQL DBA and developer tasks. He may be not worked on database technologies. Lack of confidence while asking questions in an interview.
Suggestion: As per company requirement shared at interview time
-->If you are a fresher with Developer + DBA skills on MSSQL, MYSQL and Oracle then this is a good company to start your career.
-->If you have hands-on experience with SQL and Oracle technologies and salary is less than 4 lakh then go to this company to increase salary (Max limit - 5 lakhs) else ignore it.
I applied via Recruitment Consultant and was interviewed in Dec 2019. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Tell me about the master-slave? Architecture, Working and manage user traffic on the company website.
- Q2. Diff between group by and Order By? Few scenario-based questions
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - I have visited for SQL Server DBA job profile as per HR call discussion and job description sent in mail but while interview time they are looking for a candidate who has knowledge of below all technologies:
SQL SERVER DBA
MYSQL DBA
Oracle DBA
TSQL/Developer Complex Queries with advanced skills.
-------------------------------------------------------------------------------------------------------------------
I reached to Yes Madam office and Company HR Kumud has taken my resume and after 2 hours sent someone to take my interview.
My interview was started, He discussed notice period, current company, CTC and expected CTC, Experience, etc. Then the interview went outside for discussion with HR as He told our budget is very low as the company is currently growing phase......(meeting room gate closed) and HR sent him back to the meeting room and technical interview started. He already searched questions from google and remembered answers and ask accordingly.
The most important point is interviewer has the only basic knowledge about the database. He may be not worked on database technologies. So, He does not look confident while asking questions and taking more time.
Suggestion :
If you are a fresher with Developer + DBA skills on MSSQL, MYSQL and Oracle then this is a good company to start a career.
If you have hand-on experience with SQL and Oracle technologies and salary is less than 4 lakh then go to this company else ignore it.
SQL SERVER DBA
MYSQL DBA
Oracle DBA
TSQL/Developer Complex Queries with advanced skills.
-------------------------------------------------------------------------------------------------------------------
I reached to Yes Madam office and Company HR Kumud has taken my resume and after 2 hours sent someone to take my interview.
My interview was started, He discussed notice period, current company, CTC and expected CTC, Experience, etc. Then the interview went outside for discussion with HR as He told our budget is very low as the company is currently growing phase......(meeting room gate closed) and HR sent him back to the meeting room and technical interview started. He already searched questions from google and remembered answers and ask accordingly.
The most important point is interviewer has the only basic knowledge about the database. He may be not worked on database technologies. So, He does not look confident while asking questions and taking more time.
Suggestion :
If you are a fresher with Developer + DBA skills on MSSQL, MYSQL and Oracle then this is a good company to start a career.
If you have hand-on experience with SQL and Oracle technologies and salary is less than 4 lakh then go to this company else ignore it.
asked in
DXC Technology
Q1. If someone has deleted the table in a database, then how can you ... read more
asked in
DXC Technology
Q2. What is the default port of sql server & Can we change the de ... read more
asked in
DXC Technology
Q3. What is the default isolation level in sql server? What happens w ... read more
asked in
DXC Technology
Q4. What is the backup strategy for the biggest database you handled?
asked in
DXC Technology
Q5. When we run CheckDB, what command it runs in the background ?
Top trending discussions
View All
Interview Tips & Stories
2w
honestword
·
ex -
Oxane Partners
Disappointing Interview Experience with D.E. Shaw
I recently interviewed with D.E. Shaw, and it turned out to be one of the most draining experiences I’ve had. The interviewer’s approach felt unnecessarily harsh and dismissive, which made the entire process uncomfortable. At multiple points, the interviewer asked me to drop off the call, even when I tried asking basic questions about the designation, job description, and other details. After the interview, I found myself sitting there for a few minutes, trying to process what just happened. It left me questioning the overall tone and professionalism of the interview. Definitely not the experience I was expecting from such a well-known firm.
Got a question about Yes Madam?
Ask anonymously on communities.
Yes Madam Interview FAQs
Tell us how to improve this page.
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
People are getting interviews through
based on 2 Yes Madam interviews
Recruitment Consultant
100%
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Interview Questions from Similar Companies
|
Beautician
8
salaries
|  ₹1.3 L/yr - ₹6 L/yr |
|
Branch Manager
4
salaries
| ₹2 L/yr - ₹4.8 L/yr |
|
Customer Service Executive
4
salaries
| ₹2.3 L/yr - ₹3.2 L/yr |
|
Category Manager
4
salaries
| ₹2.6 L/yr - ₹6.2 L/yr |
|
Beauty Trainer
4
salaries
| ₹3 L/yr - ₹6 L/yr |
Explore more salaries
Compare Yes Madam with
Urban Company
Compare
Housejoy
Compare
Qube Services
Compare
MyGlamm
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 >
- Yes Madam Interview Questions >
- Yes Madam MS SQL DBA Interview Questions
Share an Interview