Premium Employer

i

This company page is being actively managed by Mindsprint Team. If you also belong to the team, you can get access from here

Mindsprint Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Mindsprint MS SQL DBA Interview Questions, Process, and Tips

Updated 26 Jun 2024

Mindsprint MS SQL DBA Interview Experiences

1 interview found

MS SQL DBA Interview Questions & Answers

user image Reshma Banu R

posted on 26 Jun 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview in Dec 2023.

Round 1 - Technical 

(3 Questions)

  • Q1. Sql error identification and rectification
  • Q2. Difference between Functions and stored procedure
  • Ans. 

    Functions return a single value, while stored procedures can perform multiple operations.

    • Functions return a single value, while stored procedures can return multiple values or perform operations.

    • Functions can be used in SELECT statements, while stored procedures cannot be used in SELECT statements.

    • Functions cannot modify the database state, while stored procedures can modify the database state.

    • Functions can be called f...

  • Answered by AI
  • Q3. Index and its type
  • Ans. 

    An index is a data structure that improves the speed of data retrieval operations on a database table.

    • Types of indexes include clustered, non-clustered, unique, and filtered indexes.

    • Clustered indexes physically order the data in the table based on the index key.

    • Non-clustered indexes store a separate copy of the indexed columns and a pointer to the actual data.

    • Unique indexes ensure that no two rows have the same values ...

  • Answered by AI
Round 2 - Technical 

(4 Questions)

  • Q1. Script deployment process
  • Q2. How to avoid deadlocks
  • Ans. 

    Avoid deadlocks by setting proper isolation levels, minimizing transaction duration, using indexes, and handling errors.

    • Set appropriate isolation levels to prevent locks from escalating to deadlocks

    • Minimize transaction duration to reduce the likelihood of deadlocks

    • Use indexes to improve query performance and reduce the chance of deadlocks

    • Handle errors gracefully to avoid leaving transactions in an inconsistent state

  • Answered by AI
  • Q3. Difference between CTE and views
  • Ans. 

    CTE is a temporary result set while views are permanent virtual tables.

    • CTE is defined using WITH keyword, while views are defined using CREATE VIEW statement.

    • CTEs can be referenced within the same query, while views can be referenced in multiple queries.

    • CTEs are not stored as objects in the database, while views are stored as objects.

    • CTEs are mainly used for complex queries or recursive queries, while views are used fo

  • Answered by AI
  • Q4. Details on Azure and devops knowledge
Round 3 - HR 

(4 Questions)

  • Q1. About self and previous work experience
  • Q2. What you know about the Company
  • Q3. Expected CTC and justification
  • Ans. 

    Expected CTC should be based on industry standards, experience, skills, and responsibilities of the role.

    • Consider industry standards for MS SQL DBA roles

    • Take into account your level of experience and expertise

    • Factor in the responsibilities and workload of the position

    • Research average salaries for similar roles in your location

    • Be prepared to justify your expected CTC based on your qualifications and value you bring to t

  • Answered by AI
  • Q4. Discussion on shifts and work model

Interview Preparation Tips

Interview preparation tips for other job seekers - Do prepare on concepts related to job description and have confidence while attending interviews. Keep up good attitude and gentle posture.

Answer whatever you know upto the mark, do not turn around the bushes. Be open and inform them that you don't know on topics that are not sure of. At last ask feed back on your performance and areas of improvement.

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

7 Questions

  • Q1. You have 10 boxes of balls (each ball weighing exactly10 gm) with one box with defective balls (each one of the defective balls weigh 9 gm). You are given an electronic weighing machine and only one chance...
  • Q2. Guesstimate- 1) Find the number of petrol bunks in India?
  • Ans. 

    There are approximately 70,000 petrol bunks in India.

    • India has a population of over 1.3 billion people, and a large number of them own vehicles.

    • The number of petrol bunks varies from state to state, with some having more than others.

    • According to a report by the Petroleum Planning and Analysis Cell, there were 69,648 petrol bunks in India as of January 2021.

  • Answered by AI
  • Q3. Guesstimate- 2) Find the no of cricket balls sold in a year in India?(I told cricket is my hobby so interviewer asked question related to cricket)
  • Ans. 

    Approximately 10 million cricket balls are sold in India every year.

    • Consider the number of cricket matches played in India each year

    • Take into account the number of cricket academies and schools in India

    • Factor in the popularity of cricket in India

    • Assume an average lifespan of a cricket ball

    • Approximately 10 million cricket balls are sold in India every year

  • Answered by AI
  • Q4. Basic Finance question: Put option, Call option, payoff diagrams etc.,
  • Q5. Tell me about yourself?
  • Ans. 

    I am a highly motivated and detail-oriented business analyst with experience in data analysis and project management.

    • Experienced in data analysis and project management

    • Highly motivated and detail-oriented

    • Strong communication and problem-solving skills

  • Answered by AI
  • Q6. Your short term goal and long term goal?
  • Ans. 

    Short term goal is to gain experience and contribute to the company's success. Long term goal is to become a respected industry expert.

    • Short term goal: Gain experience and contribute to company's success

    • Long term goal: Become a respected industry expert

    • Examples: Attend industry conferences, take on challenging projects, seek mentorship

  • Answered by AI
  • Q7. Any issues working in Gurgaon?
  • Ans. 

    No major issues working in Gurgaon.

    • Traffic congestion during peak hours

    • Limited public transportation options

    • High cost of living compared to other cities

    • Pollution levels can be high

    • Availability of skilled resources

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: It was easy and try to practice daily, you can easily crack the test. I guess around 100 people has given the test and 65 got shortlisted for interviews.
Tips: Indiabix is a very good website, it helps in getting better and better by giving mock tests.
TIME materials

Duration: 60 minutes

Round: Technical Interview
Experience: Basically i thought of getting into a field of data analytics but they did not come here for data analyst. He asked me questions related to quantitative finance. Since i had financial engineering course in previous semester so it was bit easy and i didn't even prepare particularly for finance. Anyways finance knowledge is not mandatory, if you have it is an added advantage. I answered every question very confidently, so it created some good impression. All that matters is how confidently you are answering the questions (important questions are puzzles and guesstimates) with a smile on your face. The interviewer is so kind and that really boosted me up. Then he asked about coding, i told frankly that i'm not interested in coding but i know analytical languages like SAS, R etc., and in case if you want i can learn coding. Overall it was a great experience.
Tips: Heard on the street book and geeksforgeeks for puzzles
Have some idea on guesstimates(from Quora)
John C Hull book for finance

Round: HR Interview
Experience: It was basic HR questions and i know that i will surely get selected for this company after my technical interview so easily answered them. Finally as i hail from Visakhapatnam(South) so she asked me any issues working in Gurgaon? I told i don't have any problems and i'm pretty fine with that. And most important thing ask some questions after the completion of your interview. Thanks and good luck. Hence i got selected as Business Analyst in financial services. 9 people got offers from those 65 shortlisted people.
Tips: Do not get nervous & Put a smile on your face.
Be confident you will surely get selected.
Thanks
Akhil

General Tips: Stay calm and confident
Skill Tips: Tips are as mentioned above in interviews.
Skills: Logical Puzzles, Guesstimation Cases, Finance Basics, Analytical Skills
College Name: IIT Kharagpur
Motivation: Standard Company and basically profile is very good. Profile- Business Analyst in Financial services.
Funny Moments: I enjoyed each and every moment

Interview Questionnaire 

7 Questions

  • Q1. Tell me about yourself?
  • Ans. 

    I am a software developer with experience in Java and Python.

    • I have a Bachelor's degree in Computer Science.

    • I have worked on various projects involving web development and data analysis.

    • I am proficient in Java and Python programming languages.

    • I am a quick learner and enjoy working in a team environment.

  • Answered by AI
  • Q2. Do you know anything about DBMS? Where is it used?
  • Ans. 

    DBMS stands for Database Management System. It is used to manage and organize data in a structured manner.

    • DBMS is used in various industries such as healthcare, finance, education, and more.

    • It helps in creating, modifying, and deleting data in a database.

    • DBMS provides security features to protect data from unauthorized access.

    • Examples of DBMS include MySQL, Oracle, Microsoft SQL Server, and PostgreSQL.

  • Answered by AI
  • Q3. Practical example of object
  • Ans. 

    An object is a self-contained entity that contains data and behavior.

    • Objects are instances of classes

    • They have attributes (data) and methods (behavior)

    • Objects can interact with each other through method calls

    • Example: A car object has attributes like color, make, and model, and methods like start and stop

  • Answered by AI
  • Q4. Practical implementation of sorting
  • Ans. 

    Sorting is the process of arranging data in a particular order.

    • Sorting can be done in ascending or descending order.

    • Common sorting algorithms include bubble sort, insertion sort, and quicksort.

    • Sorting can be done on various data types, including strings, numbers, and objects.

    • Sorting can be done using built-in functions in programming languages such as sort() in JavaScript.

    • Sorting can be optimized for performance by cho...

  • Answered by AI
  • Q5. Difference between C and C++
  • Ans. 

    C is a procedural programming language while C++ is an object-oriented programming language.

    • C++ supports classes and objects while C does not.

    • C++ has better support for polymorphism and inheritance than C.

    • C++ has a larger standard library than C.

    • C++ allows function overloading while C does not.

    • C++ supports exception handling while C does not.

  • Answered by AI
  • Q6. Tell me about yourself
  • Ans. 

    I am a software developer with experience in Java and Python. I am passionate about coding and always eager to learn new technologies.

    • Experienced in Java and Python

    • Passionate about coding

    • Eager to learn new technologies

  • Answered by AI
  • Q7. Will your family allow you to move to Hyderabad
  • Ans. 

    Yes, my family is supportive of my career and relocation decisions.

    • My family understands the importance of career growth and is supportive of my decisions.

    • We have discussed the possibility of relocation and they are willing to make the necessary adjustments.

    • They trust my judgment and believe that this move will be beneficial for my career.

    • We have also considered the quality of life in Hyderabad and believe that it will...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Level was pretty high in case of Quant. You not only need a lot of practice but also practice of some really good questions.
Other than quant all the other sections are easy and direct.
Duration: 60 minutes
Total Questions: 45

Round: Group Discussion
Experience: They give 10 mins to think about the topic and 20 mins for discussion. Main purpose is to check your communication skills so keep on discussing . Even if you can't think of any new point repeat your points
Duration: 20 minutes

Round: Technical Interview
Experience: There were many other questions other than this but what they were emphasizing was whether you have done any practical implementation of IT or the coding skills. Tell them about your projects and how you implemented the coding part.They are much interested in logic than syntax.
Since I'm from ECE these were the main things I talked about.

Round: HR Interview
Experience: It was much of an interactive session.They again asked about projects-nothing technical only some basic idea. Lasted hardly 10 mins.

Round: Other Interview
Experience: In this round they mainly explained the salary structure. This one too was of 10 mins.

General Tips: Even if you don't have excellent coding knowledge do appear for the company. They are not looking for same qualities in each candidate. You should be willing enough to learn.
Skills: Aptitude, Communication Skills, Basic Technical Knowledge-mainly emphasized on the implementation part.
College Name: NIT Bhopal
Motivation: The company dates back to 1983 with locations in almost every US state. It is the 43rd company in Fortune 100 US companies. You have options to switch within the departments. Other than this the compensation is 6lpa.

Skills evaluated in this interview

I appeared for an interview in Sep 2019.

Interview Questionnaire 

1 Question

  • Q1. Pl sql related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - y resume was referd through a guy. Later I got call from HR for interview schedule he asked me my expected ctc and Notice Period to which I clearly said 3 months. He scheduled my interview on weekends morning 8am I reached there by 8.30am The interview process got started late by 10am it was an walk in type interview 1 round was Technical I cleared that round and had a feedback session with HR he said we are processing u to next round which was Manager round there itself I told the HR my NP is 3months the Hr Told its not an issue.
Laterly after I had lunch by 2pm Hr came n told me that Manager is not available now so we will be conducting ur further round in weekdays.
Then there was no mail or call so I purposely mailed them still haven't got proper response from them, so at last I told my friend who referd me to ask for an update the same HR told him that they want Immediate joiner so we can't process him to further round. Wasted my whole day over there

I applied via Recruitment Consultant and was interviewed before Jan 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What Prog Languages known? Prior Software Experience? How good on U.S. Client Face to Face and telephonic interaction for projects?
  • Ans. 

    I am proficient in Java, Python, and C++. I have 2 years of experience in software development. I have excellent communication skills for client interaction.

    • Proficient in Java, Python, and C++

    • 2 years of software development experience

    • Excellent communication skills for client interaction

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I wasn't fluent or good in Programming languages but I was clear on the flowchart and the basic concept of OOPS. Also, I was confident about solving the scenarios given to me at interview rounds. I also had good experience in US customer handling over telephonic and Face to Face interaction.

I applied via Recruitment Consulltant and was interviewed before Aug 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. What is stored procedure
  • Ans. 

    Stored procedure is a precompiled set of SQL statements that can be executed multiple times.

    • Stored procedure is stored in a database and can be called by applications.

    • It can accept input parameters and return output parameters.

    • It can be used to simplify complex SQL queries and improve performance.

    • It can be used to enforce security by granting permissions to execute the procedure instead of individual SQL statements.

    • Exa...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be polite and when I’m doubt try to use the STAR METHOD.

I applied via Naukri.com and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Question about desktop support

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared to answer with confidence

I applied via Approached by Company and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic programming questions

Round 2 - HR 

(1 Question)

  • Q1. Salary and self intro discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic interview questions and self intro

I applied via Naukri.com and was interviewed before May 2018. There were 5 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Telephonic technical
  • Q2. Core Java related exception handling ,design pattern ,oops solid design principle, rest API, different annotations of spring and jpa
  • Q3. Same questions on telephonic round but detailed elaborate and given simple problem statement we had to justify that why it's time n space complexity valid. Rest API questions hibernate orm use
  • Q4. Manager round just to check whether you have actually worked on project or not stress testing performance questions scenario questions

Interview Preparation Tips

General Tips: Quite easy just go with preparation
Skills: Core Java sevlet JSP hibernate spring rest API, Communication, Body Language, Problem Solving, Analytical Skills, Decision Making Skills
Duration: 1-4 weeks

I applied via Recruitment Consultant and was interviewed in May 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions & team leading

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview is not difficult..

Mindsprint Interview FAQs

How many rounds are there in Mindsprint MS SQL DBA interview?
Mindsprint interview process usually has 3 rounds. The most common rounds in the Mindsprint interview process are Technical and HR.
What are the top questions asked in Mindsprint MS SQL DBA interview?

Some of the top questions asked at the Mindsprint MS SQL DBA interview -

  1. Difference between Functions and stored proced...read more
  2. How to avoid deadlo...read more
  3. Difference between CTE and vi...read more

Tell us how to improve this page.

Mindsprint MS SQL DBA Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join Mindsprint Sprint into mindful possibilities

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
Mphasis Interview Questions
3.4
 • 796 Interviews
CitiusTech Interview Questions
3.4
 • 270 Interviews
View all
Analyst
135 salaries
unlock blur

₹3.5 L/yr - ₹7.6 L/yr

Specialist
127 salaries
unlock blur

₹4.6 L/yr - ₹11.2 L/yr

Deputy Manager
115 salaries
unlock blur

₹10 L/yr - ₹24 L/yr

Senior Associate
108 salaries
unlock blur

₹2.5 L/yr - ₹5.2 L/yr

Senior Specialist
72 salaries
unlock blur

₹6.7 L/yr - ₹13 L/yr

Explore more salaries
Compare Mindsprint with

Luxoft

3.7
Compare

ARCADIS

4.1
Compare

Photon Interactive

4.0
Compare

Trigent Software

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview