Answer Posted / b.hari kumar reddy

mainly five type of indexes in sql

1.simple index
2.composite index
3.unique index
4.Clustered index
5.Non-clustered index

Where in ms sql server is ’100’ equal to ‘0’?

1092

---

What is an identity?

1022

---

What is the native system stored procedure to execute a command against all databases?

1032

---

Can you pass expressions to stored procedure parameters?

1040

---

What are the restraints imposed on the table design by a merge replication?

1039

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1007

---

How many types of built in functions are there in sql server 2012?

926

---

Can an automatic recovery be initiated by a user?

1019

---

Explain full-text indexing?

991

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

984

---

What is replace and stuff function in sql server?

1067

---

Explain differentiate between a having clause and a where clause?

914

---

What does executeupdate return?

981

---

What is ssl in sql server?

1082

---

What is temporary table in sql server? Why we use temp table?

957

---