SQL

Question 1

SQL default port

Answer 1

TCP 1433

Question 2

What is the Master database

Answer 2

The master database holds information for all databases located on the SQL Server instance and is theglue that holds the engine together

Question 3

What is the MSDB database

Answer 3

The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping

Question 4

What is the TempDB

Answer 4

The tempdb holds temporary objects such as global and local temporary tables and stored procedures.

Question 5

What is the Model DB

Answer 5

The model is essentially a template database used in the creation of any new user database created in the instance.

Question 6

What is the Resource DB

Answer 6

The resoure Database is a read-only database that contains all the system objects that are included with SQL Server

Question 7

How do you rebuild the Master DB?

Answer 7

Run Setup.exe, verify, and repair a SQL Server instance, and rebuild the system databases