SQL Server Interview Full

This QUIZ has 202 questions about the inner workings of SQL Server.

The contents of this application is based on my 20 years of experience as a PRODUCTION DBA. My primary role was to tune TSQL queries and stored procedures optimally given the available hardware at a client.

The following topics will be discussed:

- Optimizer/Cardinality Estimator

- Locking/blocking/Latching.

- Data/Procedure cache management.

- Index Usage

- Plan Reuse

- Isolation levels

- Query optimization

- Query hints

Important hints for using the app.

- Long click on Next/Previous buttons, goes to the Next/Previous unanswered question.

- By default, when you run the app, "Quiz Mode" is off (FAB Icon is Green), turn it ON to update the stats from settings or use FAB icon.

- Your answers are saved when exit the app and if "Quiz Mode" in settings is ON or FAB Icon is Red.

- If you want to uninstall the app, go to settings and see the section "Delete ALL"