SQL Server Architecture interview questions - freshers, experienced

RAID stands for Redundant Array of Independent Disks. RAID defines data storage schemes to divide.......
When there is not enough room on a page for a new row, a Server splits the page, allocates.......
Database architecture describes the design of the database. It explains how the data is stored. The data of the server is stored in databases.......
The logical components are usually used to connect to the database. Any object that a user can use to......
Database objects such as tables, primary key, and foreign key describe the structure of the content of a database. These objects also represent the properties of a server.....
The physical database architecture describes how the database and files are organized in a SQL server........
A page is a unit of data storage in SQL. The size of a page is 8Kb. A page has a header and a body. Different types of pages are:......