Explain what are the basic functions for master, msdb, model, tempdb databases?
- 1 Answers
- 1053 Views
- I also Faced
- E-Mail Answers
Answer Posted / Vaibhab Kumar
{"master": "Holds system tables and system procedures that support SQL Server itself. Contains system catalog views, system stored procedures, and system database objects. It is read-only during normal operations.
"msdb": "Used by SQL Server Agent for storing its jobs, schedules, alerts, operators, etc.
"model": "Contains the template for creating new databases. When a new database is created, the structure of the model database is copied to create the new database. It is read-only and should not be modified.
"tempdb": "Used by SQL Server as a temporary workspace to store intermediate results during query processing and other operations. Data stored in tempdb is lost when the session ends or the SQL Server service is restarted."}
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the kinds of subquery?
What kind of problems occurs if we do not implement proper locking strategy?
Explain “row_number()” in sql server with an example?
Can one drop a column from a table?
what is spatial nonclustered index
What are wait types?
How to provide default values to function parameters?
What are the properties of the transaction?
Explain system functions or built-in functions? What are different types of system functions?
How to rebuild the master database?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is a coalesce function?
What is sql or structured query language?
Where can you add custom error messages to sql server?
