Describe the physical structure of a database.
What will be an ideal response?
Each database that is mounted on a SQL Server instance has two main physical file types. Data files store the database objects and their underlying data. These files are given a .mdf file extension. Data files are subdivided into physical units of storage called pages, which are grouped together for space management into extents, which are collections of eight pages. Log files record the series of changes that occur to a database over time, and they enable a database to be restored to a specific point in time. These files are given an .ldf file extension.
You might also like to view...
A ________ is informational text that displays when you point to commands or thumbnails on the Ribbon
A) hyperlink B) KeyTip C) ScreenTip D) snip
When a Faraday cage is applied to an entire room, electromagnetic energy will not pass through the walls in either direction
Indicate whether the statement is true or false