Answer / guest

4 key default dbs :-
Master db : Holds info of all dbs located on SQL Server
insytance. Main db (else SQL Server won't work !)
MSdb : Stores info regarding Backups, SQL Agent info, DTS
packages, SQL Server jobs, replication info for log
shipping.
Tempdb : To hold temp objects like global & local temp
tables, sps
Model db: Used in creation of any new database within the
SQL Server instance of which it(model) is a part.

Answer / hari

In 2005 .newly implemented Resource Db

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

0 Answers  

---

What is difference between aggregate and analytic function?

0 Answers  

---

What part does database design plays a role in performance of an sql server-based application?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

---

Difference between 2NF &3NF ?

0 Answers   Cap Gemini,

---

How to create a user name in a database?

0 Answers  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

---

How many types of database relationship in sql server?

0 Answers  

---

How to download and install microsoft .net framework version 2.0?

0 Answers  

---

Explain what are page splits? : SQL Server Architecture

0 Answers  

---