Answer Posted / rajesh bhawsar

1.Model
Model database is templete. when u create new database
system gives u a copy of model database
2.Tempdb
Tempdb is scratchpad of sql server
3.msdb
4.master

Tell me about pre-defined functions of sql?

1158

---

In what version of sql server were synonyms released?

1000

---

What is the full form of ddl?

965

---

How to read data in a table with "select" statements?

1028

---

How to download and install sql server 2005 books online?

1275

---

What is difference between inner join and join?

1096

---

Differentiate between a having clause and a where clause.

1010

---

What is cursors?

1259

---

Explain how many normalization forms?

1077

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2546

---

How does clustered and non clustered index work?

978

---

What is a system database and what is a user database?

1138

---

What are 3 ways to get a count of the number of records in a table?

1122

---

What is the purpose of linked server configuration in sql server?

1093

---

What is difference between rollback immediate and with no_wait during alter database?

1133

---