Answer / brijesh kumar

Index is used for fast retrival data from a table. There are
two types of index
1.clustered Index
2.Non-clustered Index
1. clustered index is created on primary key and it can be
only on per table
2.Non-clustered Index can be created any column and it can
be more than one in a table

Composite key:- Composite is the combination of more than
one attribute composite key is created when it is not
possible to identify any column in a table that has unique
value in such
a situation combination of more than column is chosen by
which
record can be identify easly clear it is just like primary
key.

What is Dependency Injection and provide example?

0 Answers  

---

What is similarity and difference between truncate and delete in sql?

0 Answers  

---

Can you use order by when defining a view?

0 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  

---

---

Can we perform backup restore operation on tempdb? : sql server database administration

0 Answers  

---

Is natural join and equi join same?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

What is in place upgrade in sql server?

0 Answers  

---

Explain about Joins?

0 Answers   Infosys,

---

How do you make a trace?

0 Answers  

---

What is the default value of an integer data type in sql server 2005?

0 Answers  

---