The interviewer asked question-related to past experience and roles and responsibility in my project. Scenario-based question on Always ON, Log shipping, and Blocking. Installation and troubleshooting SQL errors during installation. User login issues and how we troubleshooting this.
A lot of questions aiming at how much you know about SQL, noSQL, networking, troubleshooting etc... was asked to write some queries on a whiteboard/ draw some diagram about some topic.
what is the role of auto page recovery
basic accounts
Technical interview: I was asked questions relevant to my experience with the various technologies related to SQL Server Database Administration. They asked different level of questions. What was the scope of your work? What kind of problems did you solve and how. Management interview: I was asked some questions such as following: What are you looking for in your prospective employer? Where do you see after 3 years in this organisation?
1/2 technical and 1/2 related to why I left previous jobs
All questions were from the technical part (job description and current work).
How many years of experience
ACID property, Isolation levels, Replication
Database performance tuning and troubleshooting.
Viewing 2351 - 2360 interview questions