Multiple choice technology databases

Which of the following are valid filegroup types? (Choose all that apply.)

  1. Read-only

  2. Write-Only

  3. Default

  4. Primary
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

SQL Server supports several filegroup types: Primary (contains the primary data files and system tables), Default (the default filegroup where objects are created if not specified), and Read-only (can be set to prevent modifications). Write-Only is not a valid filegroup type in SQL Server. Filegroups control how data files are organized and managed within a database.

Keep practicing — related questions