How many clustered indexes can be on a single table and why?

There can be only one clustered index on a table. This is because the clustered index determines the physical order of data storage in the table. Since data can only be ordered in one way, multiple clustered indexes cannot exist simultaneously. The clustered index affects the performance of select and insert operations, as data is physically reorganized according to this index key.