Add a qoption to enable tests to use transactional mode

in scheduled query tests; the executor is launched form a qoption - however scheduled queries do make a snapshot of the actual hiveconf and as such there is no way to alter hiveconf keys for scheduled executions in the tests.

moving the "usual" transactional enabler settings to a qoption may also help clean up our tests a bit