Answer / naren

Only one clustered Index and 249 non clustered index
data is Physically order in CI and
The physical order of the rows is not same as the index order in NCI.

Answer / kumar.t

Index means to sort the data.

Cluster index is physical order of the data.

Non Cluster index is logical order of the data.

Answer / indraneelandhavarapu

The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual data
and the data is resorted in case of clustered index. Whereas
in case of non-clustered index the leaf level is actually a
pointer to the data in rows so we can have as many non-
clustered indexes as we can on the db.

How to execute a sql statement using odbc_exec()?

0 Answers  

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

---

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

---

What is policy based management (pbm)? : sql server database administration

0 Answers  

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

How much memory that we are using in Logshipping Concept?

0 Answers  

---

Tell me what is difference between view and materialized view?

0 Answers  

---

What is etl - extraction, transformation, and loading?

0 Answers  

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

---