Will I be unconscious during the procedure with oral sedation?

No, you'll be drowsy and might even doze off, but you'll still be somewhat responsive if prompted.