Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

Inspiroz It Services

Compare button icon Compare button icon Compare
3.3

based on 24 Reviews

Filter interviews by

Inspiroz It Services MS SQL DBA Interview Questions and Answers

Updated 22 Sep 2022

Inspiroz It Services MS SQL DBA Interview Experiences

1 interview found

MS SQL DBA Interview Questions & Answers

user image Sushant Nanaware

posted on 22 Sep 2022

I applied via Naukri.com and was interviewed in Aug 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

Logical reasoning and verbal reasoning kind of test

Round 3 - Technical 

(1 Question)

  • Q1. What are the daily activities that you do in your organization?
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. About Salary negotiation
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare technical side of your profile for interview. Other rounds like aptitude is easy

Top trending discussions

View All
Interview Tips & Stories
2w (edited)
timepasstiwari
·
A Digital Markter
Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question
So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours. Seriously, they didn't even acknowledge me until 10. Then this HR lady calls me in, and she's totally unprofessional. She's like, on her phone, making personal calls while I'm sitting right there. And then she starts asking me these really weird questions, like what my nickname is, and what my dad does for a living. It got really uncomfortable when she started pressing for details about where my dad works. I mean, what does that have to do with anything? So I politely told her I didn't want to answer, and she actually said, "Then we can't continue this interview." I was honestly shocked. But instead of arguing, I just stood up and said, “Alright then.” And walked out. I left feeling pissed. Not only did they waste an hour of my time, but the HR rep was also rude and unprofessional..
Got a question about Inspiroz It Services?
Ask anonymously on communities.

Interview questions from similar companies

MS SQL DBA Interview Questions & Answers

Capgemini user image Anonymous

posted on 7 Nov 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. What is pull request
  • Ans. 

    A pull request is a method of submitting contributions to a project on GitHub for review and merging.

    • Pull requests are commonly used in version control systems like Git to propose changes to a codebase.

    • They allow developers to collaborate and discuss changes before merging them into the main branch.

    • Pull requests typically include a description of the changes, related issues, and any necessary tests or documentation.

    • Rev...

    • Answered by AI
    Add your answer
Round 2 - Technical 

(1 Question)

  • Q1. What is sateful set
  • Ans. 

    Stateful set is a Kubernetes controller that manages the deployment and scaling of a set of pods with persistent storage.

    • Stateful set ensures that each pod in the set has a unique identity and stable network identity.

    • Stateful set pods are created in order and are not replaced until they are deleted.

    • Stateful set is commonly used for stateful applications like databases where each pod requires persistent storage.

    • Example:...

    • Answered by AI
    Add your answer

Skills evaluated in this interview

MS SQL DBA Interview Questions & Answers

TCS user image urugonda soumya

posted on 15 Jul 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What are the steps involved in migration
  • Ans. 

    Steps involved in migration process

    • Assess current environment and identify migration goals

    • Choose migration method (manual, scripted, tool-based)

    • Prepare target environment and perform data migration

    • Test migrated data and applications for functionality

    • Implement post-migration tasks like user training and support

    • Answered by AI
    Add your answer
  • Q2. How to do migrating from 2008 to 2019
  • Ans. 

    Migrating from SQL Server 2008 to 2019 involves upgrading the database, transferring data, and testing for compatibility.

    • Perform a side-by-side upgrade by installing SQL Server 2019 on a new server and transferring databases using backup and restore or detach and attach methods.

    • Use the Data Migration Assistant tool to assess compatibility issues and plan for any necessary changes.

    • Update applications and scripts to ensu...

    • Answered by AI
    Add your answer

Skills evaluated in this interview

MS SQL DBA Interview Questions & Answers

Capgemini user image Anonymous

posted on 21 Aug 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Difference between logshipping mirroring, tempdb corruption, master db corruption, agents used in replication
  • Ans. 

    Explanation of differences between logshipping, mirroring, tempdb corruption, master db corruption, and agents used in replication

    • Logshipping involves copying and restoring transaction logs from one server to another for disaster recovery.

    • Mirroring involves maintaining an exact copy of a database on a secondary server for failover purposes.

    • Tempdb corruption can occur due to hardware failures, software bugs, or other is...

    • Answered by AI
    Add your answer

MS SQL DBA Interview Questions & Answers

Wipro user image Anonymous

posted on 15 Jan 2022

I applied via Naukri.com and was interviewed in Dec 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Personal Details, Strength and Strong Areas, SQL Server Performance Optimization, Windows Clustering, Always On, Shipping, Mirroring, Replication.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - 1.Personal Details
2.Communication must be good
3.Strong Knowledge of Technology and the fundamentals
4.Resume Should be Good
5.Show Your Good areas
6.Be Confident While Interview

MS SQL DBA Interview Questions & Answers

Infosys user image Anonymous

posted on 19 Sep 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Dba backups in sql
  • Ans. 

    DBA backups in SQL are essential for data protection and disaster recovery.

    • Regularly schedule full, differential, and transaction log backups to ensure data is protected.

    • Store backups in secure locations to prevent data loss in case of hardware failure or corruption.

    • Test backups regularly to ensure they can be restored successfully in case of emergency.

    • Answered by AI
    Add your answer
  • Q2. Dba replication
    • Add your answer
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about urself
  • Ans. 

    I am a dedicated and experienced MS SQL DBA with a strong background in database administration and performance tuning.

    • Over 5 years of experience working as a MS SQL DBA

    • Proficient in database administration tasks such as backup and recovery, performance tuning, and security

    • Skilled in troubleshooting and resolving database-related issues

    • Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Serv...

    • Answered by AI
    Add your answer
  • Q2. Strengths and weakness
    • Add your answer

Skills evaluated in this interview

MS SQL DBA Interview Questions & Answers

HCLTech user image Anonymous

posted on 5 Jun 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Share your experience about your company with us
    • Add your answer
  • Q2. Tell me about roles and responsibilities
    • Add your answer
Round 2 - HR 

(2 Questions)

  • Q1. What ctc are you expecting
  • Ans. 

    I am expecting a competitive salary based on my experience, skills, and the market rate for MS SQL DBAs.

    • I am looking for a salary that reflects my expertise in MS SQL Server administration.

    • I am open to negotiation based on the specific responsibilities and benefits offered.

    • I have researched the average salary range for MS SQL DBAs in this location and industry.

    • I am also considering other factors such as opportunities f

    • Answered by AI
    Add your answer
  • Q2. Are you willing to relocate
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - very good

MS SQL DBA Interview Questions & Answers

Accenture user image Anonymous

posted on 2 Jan 2025

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL patching, migration
    • Add your answer

MS SQL DBA Interview Questions & Answers

Infosys user image Anonymous

posted on 3 Sep 2022

I applied via Walk-in and was interviewed in Aug 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. WHAT IS YOUR EXPIRENCE?
    • Add your answer
  • Q2. WHAT IS YOUR HIGHER GRADUATION PERIOD.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - MY NAME IS NAVEEN KUMAR . I AM FROM BADVEL. MY HIGHER GRADUATION DEGREE BSC COMPUTERS.

Analyst Interview Questions & Answers

HCLTech user image Anonymous

posted on 10 Sep 2017

I appeared for an interview before Sep 2016.

Interview Questionnaire 

1 Question

  • Q1. It was an online technical test. Questions were related to ME outlook, mobile device management , Networking and many more
    • Add your answer

Interview Preparation Tips

Round: Grammar Round
Experience: It was a written English grammar test to analyse how grammatically sound you are.
Tips: Just revise your basic English grammar like prepositions verbs nd essay/paragraph writing

Round: COMMUNICATION SKILLS Round
Experience: In this round they ask you to speak something on the given topic or sometimes group discussion . Basically they test your vocabulary, your thought process, pronunciation, accent and above all confidence.
Tips: Be confident in whatever you speak. Remember if you get nervous you will need with your words .

Round: Technical Interview
Experience: This was an online test and it had 50 questions all objective types.
Tips: Be technically sound. You cannot Google them as these search engines are blocked

College Name: Babu Banarasi Das National Institute Of Technology And Management (BBDNITM)

Inspiroz It Services Interview FAQs

How many rounds are there in Inspiroz It Services MS SQL DBA interview?
Inspiroz It Services interview process usually has 4 rounds. The most common rounds in the Inspiroz It Services interview process are Resume Shortlist, Aptitude Test and Technical.

Tell us how to improve this page.

Inspiroz It Services Interviews By Designations

Interview Questions for Popular Designations

MS SQL DBA Interview Questions from Similar Companies

Infosys MS SQL DBA Interview Questions
3.6
 • 2 Interviews
Capgemini MS SQL DBA Interview Questions
3.7
 • 2 Interviews
TCS MS SQL DBA Interview Questions
3.7
 • 1 Interview
Accenture MS SQL DBA Interview Questions
3.8
 • 1 Interview
Wipro MS SQL DBA Interview Questions
3.7
 • 1 Interview
HCLTech MS SQL DBA Interview Questions
3.5
 • 1 Interview
LTIMindtree MS SQL DBA Interview Questions
3.8
 • 1 Interview
View all

Inspiroz It Services MS SQL DBA Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

-

Skill development

-

Work-life balance

-

Salary

-

Job security

-

Company culture

-

Promotions

-

Work satisfaction

Explore 1 Review and Rating
Inspiroz It Services Salaries in India
Process Associate
15 salaries
unlock blur

₹3.4 L/yr - ₹4.3 L/yr

Technical Support Engineer
8 salaries
unlock blur

₹3 L/yr - ₹4.2 L/yr

Information Security Analyst
6 salaries
unlock blur

₹3 L/yr - ₹6.3 L/yr

Team Lead
5 salaries
unlock blur

₹5 L/yr - ₹9 L/yr

Senior Associate
4 salaries
unlock blur

₹3.6 L/yr - ₹3.6 L/yr

Explore more salaries
Compare Inspiroz It Services with

TCS

3.7
Compare

Accenture

3.8
Compare

Cognizant

3.7
Compare

Infosys

3.6
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview