1. Order type can be either limit or market order. You can see the meaning of different order types on this kite doc. Product type has to be CNC for buying stocks in delivery or to hold for more than 1 day.
2. Share will automatically get transferred to demat, you don't have to do anything.