1. Why in question They treat both clustered and primary indices Different, because both are the same thing(written in Korth).
Only the thing is Primary indices means search key is Primary Key and Clustered means it can be any search Key and both defines the same order as the order of database records right ?
Like in this Question :https://gateoverflow.in/414/gate2008-16-isro2016-60 the answer should be both A and C right ?
2. Can we have One Clustered and one unclustered indices on different set of attributes for the Records ? I know the records are only physically ordered in one way But Say i took Primary key which is in order with file and created a clustered index and i took another attribute not in the order say Salary and created a different Secondary index on the Records ?