Multiple choice technology databases

How many types of system database are therand which database stores information about jobs running on the SQL server

  1. 4,Model

  2. 4,MSDB

  3. 5,MSDB

  4. 5,Master
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL Server has 5 system databases: Master (stores system-level information), Model (template database), MSDB (stores SQL Agent jobs, alerts, and operators), TempDB (temporary workspace), and Resource (read-only system objects). MSDB specifically stores information about scheduled jobs running on SQL Server. The correct answer is '5,MSDB'.

Keep practicing — related questions