AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Mindsprint
Compare
Filter interviews by
Mindsprint MS SQL DBA Interview Questions, Process, and Tips
Mindsprint MS SQL DBA Interview Experiences
1 interview found
Reshma Banu R
Selected
I appeared for an interview in Dec 2023.
(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...
- 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 ...
(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
- 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
- Q4. Details on Azure and devops knowledge
(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
- Q4. Discussion on shifts and work model
Interview Preparation Tips
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
G Akhil
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.
- 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
- 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
- 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
- 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
Interview Preparation Tips
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.
- 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.
- 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
- 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...
- 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.
- 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
- 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...
Interview Preparation Tips
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
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
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed before Aug 2021. There was 1 interview round.
(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...
Interview Preparation Tips
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
Software Engineer Interview Questions & Answers
HTC Global Services
ARUN PRASATH JAYABAL
posted on 15 Jul 2022
I applied via Approached by Company and was interviewed before Jul 2021. There were 2 interview rounds.
Basic programming questions
(1 Question)
- Q1. Salary and self intro discussion
Interview Preparation Tips
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
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
Mindsprint Interview FAQs
Tell us how to improve this page.
Mindsprint Interviews By Designations
- Mindsprint Specialist Interview Questions
- Mindsprint SAP SD Functional Consultant Interview Questions
- Mindsprint Senior Associate Interview Questions
- Mindsprint Lead Engineer Interview Questions
- Mindsprint Senior Consultant Interview Questions
- Mindsprint Financial Analyst Interview Questions
- Mindsprint Team Manager Interview Questions
- Mindsprint Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- SQL Database Administrator Interview Questions
- Oracle Apps DBA Interview Questions
- SQL Server Developer Interview Questions
- DBA Consultant Interview Questions
- Lead DBA Interview Questions
- SQL Server Database Administrator Interview Questions
- DBA Administrator Interview Questions
- Postgresql DBA Interview Questions
- Show more
Mindsprint MS SQL DBA Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Analyst
135
salaries
|  ₹3.5 L/yr - ₹7.6 L/yr |
|
Specialist
127
salaries
| ₹4.6 L/yr - ₹11.2 L/yr |
|
Deputy Manager
115
salaries
| ₹10 L/yr - ₹24 L/yr |
|
Senior Associate
108
salaries
| ₹2.5 L/yr - ₹5.2 L/yr |
|
Senior Specialist
72
salaries
| ₹6.7 L/yr - ₹13 L/yr |
Luxoft
ARCADIS
Photon Interactive
Trigent Software
- Home >
- Interviews >
- Mindsprint Interview Questions >
- Mindsprint MS SQL DBA Interview Questions
