CNC means taking delivery of the stocks. Typically, on the 3rd day, you’ll receive the shares in your demat account. You can hold the shares in your demat account as long as you want.
MIS means intrday. Both buy and sell on the same day. No role of demat account here.