SQL Interview: 115 Database information in master

This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.

Section: Administration Level: Advanced

Question:

Most information about each database is stored within the database.

Can you list three types of database information that live in the master database?

Answer:

Pick three of the following:

Database IDs, names, creation date
Compatibility level
Collation
Recovery model
Status (ONLINE, RESTORING, SUSPECT)
File locations and size metadata (from sys.master_files)
Ownership (database owner)
Availability Group membership
Replication information
Database GUIDs, resource IDs

2025-12-20