The 13 October quiz tested your knowledge of the DBMS_ERRLOG package and what happens when you try to create an error logging table for a table that has unsupported column types, such as CLOB.
Several players wrote with objections along this line:
The question stated "I execute the following statements:" and indeed the execution of this block:
BEGIN DBMS_ERRLOG.create_error_log (dml_table_name => 'PLCH_EMPLOYEES'); END; /
will result in ORA-20069 being raised. But we never stated that each of these statements ran without error, only that we ran them.
Then, because the error logging table was not created, the attempt to use LOG ERRORS with the DML statement causes ORA-00942 (table or view does not exist) to be raised.
My main objective with this quiz was to make you aware that you could get a very puzzling error (table or view does not exist) from a DML statement against a table that clearly does exist. It is not in any way obvious that the error has to do with the fact that the underlying, unnamed error logging table does not exist.
But if you agree that "this is true" - that (to repeat the choice we scored as correct):
ORA-00942: table or view does not exist
Then I do not see how you can also argue that no choices are correct.
Cheers, Steven Feuerstein