Will I be "knocked out" or unconscious during my dental procedure?

No. Most forms of dental sedation will leave you drowsy but conscious and able to voluntarily move and speak.