Answer / pradeep

Schema is a logical set of data. It contains tables, views,
Packages, constraints. This is treated as a whole database.
This has assigned with a unique id called as SID i.e.
System ID. Because of this ID one can create n number of
DBs on a single DB server. Obviously within the limit of
the hardware of DB server.

What is difference between joins and subqueries?

0 Answers  

---

How do I install only the client tools of sql server 2000?

0 Answers  

---

How to use linked server?

0 Answers  

---

Define self join?

0 Answers  

---

Explain different isolation levels?

4 Answers  

---

---

Describe and explain about SQL native client?

0 Answers  

---

What is difference between equi join and natural join?

0 Answers  

---

What are the functions in sql server?

0 Answers  

---

Can you index views?

0 Answers  

---

What are exact numeric data types in ms sql server?

0 Answers  

---

Define left outer join?

0 Answers  

---

What are sp_configure commands and set commands?

0 Answers  

---