Answer Posted / seema

Clustered Index :-
1.There can be only one Clustered index for a table
2.usually made on the primary key
3.the logical order of the index matches the physical stored
order of the rows on disk

Non-Clustered Index
1.There can be only 249 Clustered index for a table
2.usually made on the any key
3.the logical order of the index does not match the physical
stored order of the rows on disk

What are locks in sql?

1013

---

What is sql or structured query language?

1197

---

Can you force a query to use a specific index?

985

---

How to delete existing triggers using "drop trigger"?

1096

---

What is the concept of optimization?

1105

---

Why truncate is ddl?

1133

---

Can foreign key be duplicate?

1116

---

Explain for xml explicit mode?

1024

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1067

---

What authentication modes does sql server support?

1147

---

What are the advantages of using stored procedures?

1004

---

How to name query output columns in ms sql server?

1012

---

System requirements for sql server 2005 express edition?

1064

---

What do you know about system database? : SQL Server Architecture

1033

---

What are the types of subscriptions in SQL Server replication?

1100

---