Answer Posted / sreeja.t.pillai

Default databases in SQL server are
1.Master
2.Model
3.tempdb
4.msbd

Master-Contains information about all databases and contains system objects.

Model-It is a template database used in creation of any new database.

msdb-It contains information about sql agent,job,dts packaging and some replication information.

tempdb-contains temporary stored procedures and tables.

What is the difference between Stored Procedures and triggers?

1044

---

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

135

---

What is difference between rownum and rowid?

862

---

Differentiate between sql temp table vs table variable?

845

---

What is the difference between a primary key and a unique key? Are they the same?

1017

---

What do you mean by SQL injection attack?

1012

---

What are the purposes of floor and sign functions?

934

---

What is an index in sql?

968

---

Where sql server usernames and passwords are stored in a sql server?

941

---

Is sql different from sql server?

1011

---

how to use DTS package in 2000,2005,2008 in sql server

1797

---

what are different types of raid configurations? : Sql server database administration

1006

---

How to disable triggers using "disable trigger"?

1012

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1082

---

What is usually the first word in a sql query?

1078

---