5 Questions
What is the fundamental unit of data storage in SQL server?
Page
When the data row is too large to store in one page, where will the SQL server store the overflow data?
ROW_OVERFLOW_DATA
What is the correct action when a page is modified in the buffer cache?
Changes are written to the data file and the log cache at the same time.
Select the false statement about SQL Server data files.
The main data file contains only the database structures and the secondary files contain the data of the database.
Which statement is correct about the functions of file groups?
There are two filegroup types in SQL server 2019.
Study Notes
SQL Server Data Storage
- The fundamental unit of data storage in SQL Server is an 8-kilobyte page.
Data Overflow Storage
- When a data row is too large to store in one page, SQL Server stores the overflow data in a linked list of overflow pages.
Buffer Cache Modifications
- When a page is modified in the buffer cache, the correct action is to write the modified page to disk and update the log file.
SQL Server Data Files
- The false statement about SQL Server data files is that a database can have only one primary file.
File Groups Functions
- One correct statement about the functions of file groups is that they allow database administrators to group related database files together for administrative and troubleshooting purposes.
Test your knowledge of SQL Server storage architecture with this quiz. Questions cover topics such as fundamental units of data storage, handling overflow data, and actions when a page is modified in the buffer cache.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
