Multiple choice technology databases

Which are the System Databases in SQL Server 2005?

  1. (a) Model database

  2. (b) Master Database

  3. (c) msdb

  4. (d) Temporary database
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

SQL Server 2005 has four system databases that are essential for server operation. Master is the core database with system metadata, Model serves as a template for new databases, msdb stores SQL Agent jobs and SSIS packages, and tempdb is for temporary objects. The option 'Temporary database' is misleading - the actual name is 'tempdb'.

Keep practicing — related questions