Microland MS SQL DBA Interview Questions and Answers

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

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 IS YOUR EXPIRENCE?
Add your answer
Q2. WHAT IS YOUR HIGHER GRADUATION PERIOD.
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. 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

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

Q1. Basic questions of java.
Add your answer

Q1. Intro and other hr related questions.
Add your answer

Puzzles, Psychometric Test

Q1. Some water in 3 Jars question, you had to measure out 5L correctly
Add your answer