Interview Questions

1. Tell me something about the SQL Server Architecture?

SQL Server is divided into two main engines: the Relational Engine and the Storage Engine. The Relational Engine contains below components:

  • Cmd Parser
  • Optimizer
  • Query Executor The Storage Engine contains below components:
  •  Access Methods code
  • Buffer Manager
  • Transaction Manager
By Expert User 2 0
Is this helpful? Yes No

Submit an interview question

Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.

Get Started

Comments

Leave a Comment


Check out more interview questions

Based on your skills

MS SQL Server

2391830 1720 39 859

Angular

62410 92 0 46

Wordpress

52477 72 1 36