Icon of program: SQL Server Interview Full

SQL Server Interview Full for Android


Key Details of SQL Server Interview Full

  • This QUIZ has 202 questions about the inner workings of SQL Server.
  • Last updated on 9/24/2018
  • There have been 7 updates
  • Virus scan status:

    Clean (it's extremely likely that this software program is clean)


Enlarged image for SQL Server Interview Full

Developer's Description

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

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"