Podcast
Questions and Answers
What is the term used for when the data row is too large to store in one page in SQL server?
What is the term used for when the data row is too large to store in one page in SQL server?
- Row (correct)
- Page
- Partition
- Extent
Where does the SQL server store the overflow data when the data row is too large to fit in one page?
Where does the SQL server store the overflow data when the data row is too large to fit in one page?
- IN_OVERFLOW_DATA
- LOB_DATA
- IN_ROW_DATA
- ROW_OVERFLOW_DATA (correct)
What happens when a page is modified in the buffer cache in SQL server?
What happens when a page is modified in the buffer cache in SQL server?
- Changes are immediately written to the datafiles before writing in the log cache.
- Changes are written to the data file and the log cache at the same time. (correct)
- Changes are immediately written to the log cache as log records.
- Changes are immediately written to the datafiles without writing to the log cache.
Which statement is false about SQL server data files?
Which statement is false about SQL server data files?
What is a correct function of file groups in SQL server?
What is a correct function of file groups in SQL server?