Question: what is the main difference between clustered and nonclustered index?
Answer: A clustered index actually describes the order in which records are physically stored on the disk, hence the reason you can only have one. A Non-Clustered Index defines a logical order that does not match the physical order on disk. A clustered index is essentially a sorted copy of the data in the indexed columns.