Answer Posted / yashpal

Clustered index will be created by default when u
create primary key on a column. only one clustered index is
created per table

Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.

Explain about analysis services?

980

---

What are the new features in sql server 2016?

929

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

977

---

Can we shrink data file in sql server?

997

---

Explain the use of containers in ssis and also their types?

908

---

What is the maximum size of a row in sql server?

905

---

What are different types of subquery?

1180

---

what is sql server? : Sql server database administration

928

---

What is the difference in accessing db between sql server vs sql azure?

174

---

Explain the difference between primary keys and foreign keys?

943

---

What is open database communication (odbc)?

1004

---

Explain mixed authentication mode of sql server?

989

---

What is use of @@ spid in sql server?

1145

---

How to find the source of a table in sql server?

921

---

How many types of triggers in sql server?

970

---