Answer Posted / naren

clustered index is created on actual data.

Non clustered index ix created on pointer of data.

If there is primary key by default clustered index is
created.
else non clustered index created.

only one clustered index is possible to create.


249 non clustered indexex can be created.

What is a trace frag?

1040

---

What is rs.exe utility?

152

---

What is a schema in ms sql server 2005?

922

---

Do you know the policy based administration feature of sql server 2008?

914

---

Can we take the full database backup in log shipping?

903

---

How to create indexed view?

994

---

What is the Disadvantage of indexed sequential file.

1033

---

Can a function call a stored procedure in sql server?

916

---

What is a filestream?

949

---

What is data modeling and Reterminal integrity?

1915

---

How to insert multiple rows with one insert statement in ms sql server?

1069

---

How would you go about developing a ssrs report?

162

---

What is the new security features added in sql server 2016? : sql server security

1065

---

What are user-defined functions (udfs) in sql server?

947

---

What is the difference between executequery () and executeupdate ()?

976

---