Add office photos
Filter interviews by
TSS Techsoft Solution MS SQL DBA Interview Questions and Answers
TSS Techsoft Solution MS SQL DBA Interview Experiences
1 interview found
Venkatesh G
Time and work, analigy
(2 Questions)
- Q1. Steps for setup always on group?
- Ans.
Setting up Always On group involves configuring multiple SQL Server instances for high availability and disaster recovery.
Configure Windows Failover Cluster
Install SQL Server on each node
Enable Always On Availability Groups feature
Create availability group and add databases
Configure listener for client connections
- Q2. Can you explain log shipping?
- Ans.
Log shipping is a method used to maintain a secondary copy of a database for disaster recovery purposes.
Transaction logs are backed up from the primary database and then copied to the secondary server.
The transaction logs are then restored on the secondary server to keep it synchronized with the primary database.
Log shipping can be set up to occur at regular intervals to minimize data loss in case of a failure.
It is a ...
(2 Questions)
- Q1. What is your current ctc ?
- Q2. How much your expected ctc ?
- Ans.
My expected CTC is negotiable based on the job responsibilities and market standards.
My expected CTC is based on my experience, skills, and the job responsibilities.
I am open to discussing the salary range during the interview process.
I am looking for a competitive salary that aligns with industry standards.
I am flexible and willing to consider other benefits in addition to the salary.
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Anonymous
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
(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...
(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:...
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
(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.
- Q2. Dba replication
(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...
- Q2. Strengths and weakness
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(4 Questions)
- 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...
- Q2. Differential backup query
- Q3. Sql server statics
- Q4. Log file architecture
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
(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...
urugonda soumya
I applied via Recruitment Consulltant and was interviewed in Jun 2024. There was 1 interview round.
(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
- 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...
Skills evaluated in this interview
(1 Question)
- Q1. SQL patching, migration
(2 Questions)
- Q1. Share your experience about your company with us
- Q2. Tell me about roles and responsibilities
(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
- Q2. Are you willing to relocate
Interview Preparation Tips
I applied via Walk-in and was interviewed in Aug 2022. There were 2 interview rounds.
(2 Questions)
- Q1. WHAT IS YOUR EXPIRENCE?
- Q2. WHAT IS YOUR HIGHER GRADUATION PERIOD.
Interview Preparation Tips
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.
Interview Preparation Tips
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
TSS Techsoft Solution Interview FAQs
Tell us how to improve this page.
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
MS SQL DBA Interview Questions from Similar Companies
|
Devops Engineer
4
salaries
|  ₹4.8 L/yr - ₹6 L/yr |
|
Analyst
3
salaries
| ₹3.2 L/yr - ₹3.5 L/yr |
|
Software Engineer
3
salaries
| ₹4.5 L/yr - ₹5.6 L/yr |
|
QA Engineer
3
salaries
| ₹4.8 L/yr - ₹11 L/yr |
|
Salesforce Administrator
3
salaries
| ₹4 L/yr - ₹4.9 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- TSS Techsoft Solution Interview Questions >
- TSS Techsoft Solution MS SQL DBA Interview Questions
