Infosys MS SQL DBA Interview Questions and Answers

Q1. Start up parameters of sql server
Ans. 
Start up parameters are used to configure the behavior of SQL Server when it starts up.
• Start up parameters are specified in the SQL Server Configuration Manager.

• Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.

• Start up parameters can be modified to customize the behavior of SQL Server during startup.

• Example: -dC:\Program Files\Microso...read more
Answered by AI
Add your answer
Q2. Differential backup query
Add your answer
Q3. Sql server statics
Add your answer
Q4. Log file architecture
Add your answer

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...read more
Answered by AI
Add your answer

Q1. SQL patching, migration
Add your answer

Sql queries on top clause

Q1. Why u want to join
Ans. 
I am passionate about database management and eager to contribute my skills to your team.
• I have a strong background in database administration

• I am excited about the opportunity to work with a reputable company like yours

• I am eager to learn and grow in my career as a SQL DBA
Answered by AI
Add your answer
Q2. What is the salary expectation
Ans. 
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.
• Research the average salary range for MS SQL DBAs in your location and industry

• Consider your years of experience and any specialized skills or certifications you have

• Be prepared to negotiate based on the specific responsibilities and requirements of the role
Answered by AI
Add your answer

Q1. Share your experience about your company with us
Add your answer
Q2. Tell me about roles and responsibilities
Add your answer

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

Asked question from basic aptitude topics

Q1. Asked question coding languages like c, python, java, SQL
Add your answer

Q1. Discussed about terms and policies of company. Also work profile
Add your answer