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.

How use inner join in sql server?

0 Answers  

---

What is the stuff?

0 Answers  

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

---

How do use Having,Group by,Group function in SQL?

0 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

what is physical sort data and logical sort data in index?

2 Answers  

---

What are the advantages of user defined function?

0 Answers  

---

Explain different types of self contained sub query?

0 Answers  

---

Explain the cursor lock types?

0 Answers  

---

What is purpose of normalization?

0 Answers  

---

How get current date in SQL server 2000

6 Answers   Cap Gemini,

---