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 the difference between dataadapter and datareader?

758

---

Tell me what is use of except clause? How it differs from not in clause?

724

---

When to use null data driven subscription?

190

---

How to select an exiting database using mssql_select_db()?

689

---

System requirements for sql server 2005 express edition?

753

---

Does order by actually change the order of the data in the tables or does it just change the output?

936

---

What are the approximate numeric data types?

727

---

What is meant by referential integrity?

769

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

764

---

What is a partitioned view?

790

---

What are the advantages of paper records?

737

---

Can we update data in a view?

798

---

How can you insert null values in a column while inserting the data?

956

---

explain the storage models of olap? : Sql server database administration

703

---

What is the difference between mysql and mysqli?

782

---