CNC is for buying and keeping stocks with you more than 1 day (example 2-3 days)
NRML is for buying or selling futures and options and hold it with you more than 1 day (many days before expiry)
MIS cannot be used for keeping it for 2-3 days
CNC cannot be used to sell, if you do not have stock already in your demat account.