Answer Posted / chandu

Clustered index:
A Table have only one clustered index.
Once we defined a column with primary key constraint, sql
server automatically creates unique clustered index on that
column,
Actual rows arranged in same order as index.
Eg: Dictionary.

Non-clustered index:

Atable have 249 non clustered index.
Once we defined a column with unique key constrain , sql
server automatically create non clustered index.
Actual rows not arranged in same order as index.
Eg: Text book

What is a collation?

1093

---

How can you tell if a database object is invalid?

1074

---

what is normalization? Explain different levels of normalization? : Sql server database administration

1331

---

What is fill factor and pad index?

1014

---

what are the different types of SSRS reports?

153

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

952

---

Can you index views?

895

---

What are the different authentication modes in sql server?

1119

---

When would you use a before or after trigger?

908

---

What are types of scd? : sql server analysis services, ssas

1016

---

What is the difference between join and inner join?

1014

---

What is isolation levels?

1032

---

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

---

What is application role in sql server database security? : sql server security

1058

---

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

1029

---