COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Model
|
|
|
Master
|
|
|
Tempdb
|
|
|
Msdb
|
Detailed explanation-1: -9. Which of the following system database occupies more space and memory? Explanation: The master database records all of the system level information for a SQL Server system.
Detailed explanation-2: -The Master database is the primary configuration database in SQL Server. It contains information on all the databases that exist on the server, including the physical database files and their locations. The Master database also contains SQL Server’s configuration settings and login account information.
Detailed explanation-3: -Explanation: Server-scoped Dynamic Management View is stored only in the Master database.
Detailed explanation-4: -System databases are the databases that are installed during the SQL Server installation. System databases consist of Master, MSDB, TempDB, and Model.
Detailed explanation-5: -The model database is used as the template for all databases created on an instance of SQL Server.