7.how many primary keys allowed on 1 table and why?
Sigiloso
only 1 is allowed because it creates clustered index on the table and stores the table physically based on the primary key into the memory. only one clustered index possible on a table coz only one way tp store table's data physically in the memory.